34: G_BULK_SIZE NUMBER := 10000;
35: G_EXCEPTION_HALT_PROCESS EXCEPTION;
36: l_phid_mapping_tab l_phid_mapping_tab_type;
37: l_party_payment_hdr_counter NUMBER := 1;
38: l_created_by NUMBER := fnd_global.user_id;
39: l_last_updated_by NUMBER := fnd_global.user_id;
40: l_last_update_login NUMBER := fnd_global.login_id;
41: l_contract_exists BOOLEAN := FALSE;
42:
35: G_EXCEPTION_HALT_PROCESS EXCEPTION;
36: l_phid_mapping_tab l_phid_mapping_tab_type;
37: l_party_payment_hdr_counter NUMBER := 1;
38: l_created_by NUMBER := fnd_global.user_id;
39: l_last_updated_by NUMBER := fnd_global.user_id;
40: l_last_update_login NUMBER := fnd_global.login_id;
41: l_contract_exists BOOLEAN := FALSE;
42:
43:
36: l_phid_mapping_tab l_phid_mapping_tab_type;
37: l_party_payment_hdr_counter NUMBER := 1;
38: l_created_by NUMBER := fnd_global.user_id;
39: l_last_updated_by NUMBER := fnd_global.user_id;
40: l_last_update_login NUMBER := fnd_global.login_id;
41: l_contract_exists BOOLEAN := FALSE;
42:
43:
44: --Function to migrate api_components tbl
20708: ) VALUES (
20709: l_copied_id, 0, 1,
20710: 1, l_created_by, SYSDATE,
20711: l_last_updated_by, SYSDATE, l_last_update_login
20712: --FND_GLOBAL.SECURITY_GROUP_ID
20713: );
20714: EXCEPTION WHEN OTHERS THEN
20715: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20716: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);