Update Customer site Use record gives error using hz_cust_account_site_v2pub.update_cust_site_use AP
Hi,
2 FROM hz_cust_site_uses
3 where site_use_id = 28982
4 ;
SITE_USE_ID OBJECT_VERSION_NUMBER
---------------- ---------------------
28982 1 The PL/SQL code is given below. DECLARE
r_bill_cust_site_use hz_cust_account_site_v2pub.cust_site_use_rec_type;
vv_return_status VARCHAR2(2000);
vn_msg_count NUMBER;
vv_msg_data VARCHAR2(2000);
vn_version NUMBER := 1;
BEGIN
FND_GLOBAL.APPS_INITIALIZE (1922, 50767, 222);
MO_GLOBAL.INIT ('AR');
mo_global.set_policy_context ('S', 84);
r_bill_cust_site_use.site_use_id := 28982;
r_bill_cust_site_use.location := '0010';
Please help me resolve this error.
Input data:
SQL> SELECT site_use_id, object_version_number2 FROM hz_cust_site_uses
3 where site_use_id = 28982
4 ;
SITE_USE_ID OBJECT_VERSION_NUMBER
---------------- ---------------------
28982 1 The PL/SQL code is given below. DECLARE
r_bill_cust_site_use hz_cust_account_site_v2pub.cust_site_use_rec_type;
vv_return_status VARCHAR2(2000);
vn_msg_count NUMBER;
vv_msg_data VARCHAR2(2000);
vn_version NUMBER := 1;
BEGIN
FND_GLOBAL.APPS_INITIALIZE (1922, 50767, 222);
MO_GLOBAL.INIT ('AR');
mo_global.set_policy_context ('S', 84);
r_bill_cust_site_use.site_use_id := 28982;
r_bill_cust_site_use.location := '0010';
0