DBA Data[Home] [Help]

APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 95: l_accessid_lst asg_download.access_list;

91: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
92: l_sqlerrno varchar2(20);
93: l_sqlerrmsg varchar2(2000);
94: l_markdirty BOOLEAN;
95: l_accessid_lst asg_download.access_list;
96: l_userid_lst asg_download.user_list;
97: l_last_run_date JTM_CON_REQUEST_DATA.LAST_RUN_DATE%TYPE;
98:
99: BEGIN

Line 96: l_userid_lst asg_download.user_list;

92: l_sqlerrno varchar2(20);
93: l_sqlerrmsg varchar2(2000);
94: l_markdirty BOOLEAN;
95: l_accessid_lst asg_download.access_list;
96: l_userid_lst asg_download.user_list;
97: l_last_run_date JTM_CON_REQUEST_DATA.LAST_RUN_DATE%TYPE;
98:
99: BEGIN
100: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_UPD',FND_LOG.LEVEL_EXCEPTION);

Line 119: l_markdirty := asg_download.mark_dirty( g_pub_item,l_accessid_lst

115:
116: FETCH c_cust_accnt_upd BULK COLLECT INTO l_accessid_lst,l_userid_lst LIMIT 50;
117: EXIT WHEN l_accessid_lst.COUNT=0;
118:
119: l_markdirty := asg_download.mark_dirty( g_pub_item,l_accessid_lst
120: ,l_userid_lst, 'U', sysdate );
121:
122: COMMIT;
123: END LOOP;