APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on OKC_REP_IMPORT_RUN_ID_S

Line 198: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;

194: -- Initialize API return status to success
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196:
197: IF p_create_contract = fnd_api.g_true THEN
198: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;
199: END IF;
200:
201: --Call API to populate Header and controls
202: populate_contract_hdr(p_api_version => p_api_version,

Line 813: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;

809: END IF;
810:
811: --create a run id sequence and populate the run_id column in all the interface tables
812:
813: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;
814:
815: --stamp the request id column for the records that are being imported.
816: --update OKC_REP_IMP_CONTRACTS_T with the run_id and request_id generated
817:

Line 1520: run_id = okc_rep_import_run_id_s.NEXTVAL

1516: contract_status_code = 'DRAFT',
1517: last_updated_by = FND_GLOBAL.user_id(),
1518: last_update_login = FND_GLOBAL.user_id(),
1519: last_update_date = SYSDATE,
1520: run_id = okc_rep_import_run_id_s.NEXTVAL
1521: WHERE contract_id = p_contract_id;
1522:
1523:
1524: ELSE -- IF l_contract_status IN ('SIGNED', 'APPROVED', 'CANCELLED')