DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSM_SR_EVENT_PKG

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

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

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

956: ,P_PK1_NUM_VALUE => c_exist_ib_items.instance_id
957: ,P_USER_ID => p_user_id
958: );
959:
960: csm_sr_event_pkg.g_ib_count := csm_sr_event_pkg.g_ib_count + 1;
961: END LOOP;
962:
963: -- Greater than check for Profile IB count was reset to a lower value
964: IF csm_sr_event_pkg.g_ib_count >= l_max_ib_at_location THEN

Line 964: IF csm_sr_event_pkg.g_ib_count >= l_max_ib_at_location THEN

960: csm_sr_event_pkg.g_ib_count := csm_sr_event_pkg.g_ib_count + 1;
961: END LOOP;
962:
963: -- Greater than check for Profile IB count was reset to a lower value
964: IF csm_sr_event_pkg.g_ib_count >= l_max_ib_at_location THEN
965: RETURN;
966: ELSE
967: /** Insert For other IB's at location */
968: FOR c_ib_items IN c_new_ib_at_location_csr (

Line 972: IF csm_sr_event_pkg.g_ib_count < l_max_ib_at_location

968: FOR c_ib_items IN c_new_ib_at_location_csr (
969: p_user_id, p_party_site_id , p_location_id, p_party_id )
970: LOOP
971:
972: IF csm_sr_event_pkg.g_ib_count < l_max_ib_at_location
973: THEN
974: CSM_ACC_PKG.Insert_Acc
975: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
976: ,P_ACC_TABLE_NAME => g_acc_table_name1

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

979: ,P_PK1_NUM_VALUE => c_ib_items.instance_id
980: ,P_USER_ID => p_user_id
981: );
982:
983: csm_sr_event_pkg.g_ib_count := csm_sr_event_pkg.g_ib_count + 1;
984: ELSE
985: EXIT;
986: END IF;
987: