APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on FII_CHANGE_LOG

Line 167: UPDATE FII_Change_Log

163:
164: SELECT nvl(MAX(Batch_Party_ID), -1) INTO l_max_batch_party_id
165: FROM HZ_Merge_Party_History;
166:
167: UPDATE FII_Change_Log
168: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
169: = (SELECT l_max_batch_party_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
170: WHERE log_item = 'MAX_BATCH_PARTY_ID';
171:

Line 173: INSERT INTO FII_Change_Log (Log_Item, Item_Value, Creation_Date, Created_By, Last_Update_Date, Last_Update_Login, Last_Updated_By)

169: = (SELECT l_max_batch_party_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
170: WHERE log_item = 'MAX_BATCH_PARTY_ID';
171:
172: IF SQL%ROWCOUNT = 0 THEN
173: INSERT INTO FII_Change_Log (Log_Item, Item_Value, Creation_Date, Created_By, Last_Update_Date, Last_Update_Login, Last_Updated_By)
174: VALUES ('MAX_BATCH_PARTY_ID', l_max_batch_party_id, sysdate, g_fii_user_id, sysdate, g_fii_login_id, g_fii_user_id);
175: END IF;
176:
177: --If a hierarchy_type is chosen, populate hierarchical parties:

Line 298: UPDATE FII_Change_Log

294:
295: SELECT nvl(MAX(Cust_Account_ID),-1) INTO l_max_cust_account_id
296: FROM HZ_Cust_Accounts;
297:
298: UPDATE FII_Change_Log
299: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
300: = (SELECT l_max_cust_account_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
301: WHERE log_item = 'MAX_CUST_ACCOUNT_ID';
302:

Line 304: INSERT INTO FII_Change_Log (Log_Item, Item_Value, Creation_Date, Created_By, Last_Update_Date, Last_Update_Login, Last_Updated_By)

300: = (SELECT l_max_cust_account_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
301: WHERE log_item = 'MAX_CUST_ACCOUNT_ID';
302:
303: IF SQL%ROWCOUNT = 0 THEN
304: INSERT INTO FII_Change_Log (Log_Item, Item_Value, Creation_Date, Created_By, Last_Update_Date, Last_Update_Login, Last_Updated_By)
305: VALUES ('MAX_CUST_ACCOUNT_ID', l_max_cust_account_id, sysdate, g_fii_user_id, sysdate, g_fii_login_id, g_fii_user_id);
306: END IF;
307:
308: --From HZ_Cust_Accounts, outer join to FII_Customer_Hierarchies to:

Line 564: FROM fii_change_log

560: end if;
561:
562: SELECT item_value
563: INTO l_prev_max_batch_party_id
564: FROM fii_change_log
565: WHERE log_item = 'MAX_BATCH_PARTY_ID';
566:
567: g_state := 'Storing the current maximum batch party id.';
568: if g_debug_flag = 'Y' then

Line 578: UPDATE FII_Change_Log

574: WHERE Batch_Party_ID >= l_prev_max_batch_party_id;
575:
576: IF l_max_batch_party_id > l_prev_max_batch_party_id THEN
577:
578: UPDATE FII_Change_Log
579: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
580: = (SELECT l_max_batch_party_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
581: WHERE log_item = 'MAX_BATCH_PARTY_ID';
582:

Line 873: FROM fii_change_log

869: end if;
870:
871: SELECT item_value
872: INTO l_prev_max_cust_account_id
873: FROM fii_change_log
874: WHERE log_item = 'MAX_CUST_ACCOUNT_ID';
875:
876: g_state := 'Storing the current maximum customer account id.';
877: if g_debug_flag = 'Y' then

Line 885: UPDATE FII_Change_Log

881: SELECT nvl(MAX(Cust_Account_ID),-1) INTO l_max_cust_account_id
882: FROM HZ_Cust_Accounts
883: WHERE Cust_Account_ID >= l_prev_max_cust_account_id;
884:
885: UPDATE FII_Change_Log
886: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
887: = (SELECT NVL(l_max_cust_account_id, l_prev_max_cust_account_id), sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
888: WHERE log_item = 'MAX_CUST_ACCOUNT_ID';
889: