DBA Data[Home] [Help]

APPS.CSM_SERIAL_NUMBERS_EVENT_PKG dependencies on CSM_PROFILE_PKG

Line 428: l_user_palm_organization_id:=csm_profile_pkg.get_organization_id(l_usr_list_for_serial(l_count));

424: FETCH l_usr_rsrc_list_serial BULK COLLECT INTO l_rsrc_list_for_serial,l_usr_list_for_serial;
425: CLOSE l_usr_rsrc_list_serial;
426: IF l_usr_list_for_serial.COUNT > 0 THEN
427: FOR l_count in 1..l_usr_list_for_serial.COUNT LOOP
428: l_user_palm_organization_id:=csm_profile_pkg.get_organization_id(l_usr_list_for_serial(l_count));
429: --updating/deleting serial numbers already present in the ACC
430: update_mtl_serial_numbers(l_user_palm_organization_id,l_last_run_date,l_rsrc_list_for_serial(l_count),l_usr_list_for_serial(l_count));
431: --inserting new serial numbers
432: insert_mtl_serial_numbers(l_user_palm_organization_id,l_last_run_date,l_rsrc_list_for_serial(l_count),l_usr_list_for_serial(l_count));