[Home] [Help]
5127: AND contract_id < l_start_contract_id + l_insert_batch_size;
5128:
5129: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_contract_parties *****');
5130:
5131: --insert into okc_rep_signature_details
5132: INSERT INTO OKC_REP_SIGNATURE_DETAILS
5133: (
5134: contract_id,
5135: contract_version_num,
5128:
5129: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_contract_parties *****');
5130:
5131: --insert into okc_rep_signature_details
5132: INSERT INTO OKC_REP_SIGNATURE_DETAILS
5133: (
5134: contract_id,
5135: contract_version_num,
5136: party_role_code,
5171: AND contract_id IS NOT NULL
5172: AND contract_id >= l_start_contract_id
5173: AND contract_id < l_start_contract_id + l_insert_batch_size;
5174:
5175: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO OKC_REP_SIGNATURE_DETAILS *****');
5176:
5177: --insert into status history
5178: INSERT INTO okc_rep_con_status_hist
5179: (