DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSM_SR_EVENT_PKG

Line 169: csm_sr_event_pkg.g_ib_count := NVL(csm_sr_event_pkg.g_ib_count,0) + 1;

165:
166: -- increment count of item instances downloaded
167: -- this is used to determine how many IB instances are downloaded at a location
168: IF p_flowtype IS NULL OR p_flowtype <> 'HISTORY' THEN
169: csm_sr_event_pkg.g_ib_count := NVL(csm_sr_event_pkg.g_ib_count,0) + 1;
170: END IF;
171: END IF;
172:
173: p_error_msg := 'SUCCESS';

Line 915: csm_sr_event_pkg.g_ib_count := csm_sr_event_pkg.g_ib_count + 1;

911: p_user_id,
912: l_error_msg,
913: l_return_status);
914:
915: csm_sr_event_pkg.g_ib_count := csm_sr_event_pkg.g_ib_count + 1;
916: END LOOP;
917:
918: -- Greater than check for Profile IB count was reset to a lower value
919: IF csm_sr_event_pkg.g_ib_count >= l_max_ib_at_location THEN

Line 919: IF csm_sr_event_pkg.g_ib_count >= l_max_ib_at_location THEN

915: csm_sr_event_pkg.g_ib_count := csm_sr_event_pkg.g_ib_count + 1;
916: END LOOP;
917:
918: -- Greater than check for Profile IB count was reset to a lower value
919: IF csm_sr_event_pkg.g_ib_count >= l_max_ib_at_location THEN
920: RETURN;
921: ELSE
922: /** Insert For other IB's at location */
923: FOR c_ib_items IN c_new_ib_at_location_csr (

Line 927: IF csm_sr_event_pkg.g_ib_count < l_max_ib_at_location

923: FOR c_ib_items IN c_new_ib_at_location_csr (
924: p_user_id, p_party_site_id , p_location_id, p_party_id )
925: LOOP
926:
927: IF csm_sr_event_pkg.g_ib_count < l_max_ib_at_location
928: THEN
929: CSM_ACC_PKG.Insert_Acc
930: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
931: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 944: csm_sr_event_pkg.g_ib_count := csm_sr_event_pkg.g_ib_count + 1;

940: p_user_id,
941: l_error_msg,
942: l_return_status);
943:
944: csm_sr_event_pkg.g_ib_count := csm_sr_event_pkg.g_ib_count + 1;
945: ELSE
946: EXIT;
947: END IF;
948: