APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_SIGNATURE_DETAILS

Line 1341: --Function : Inserts a record into table OKC_REP_SIGNATURE_DETAILS.

1337:
1338: -- Start of comments
1339: --API name : add_signature_hist_record
1340: --Type : Private.
1341: --Function : Inserts a record into table OKC_REP_SIGNATURE_DETAILS.
1342: --Pre-reqs : None.
1343: --Parameters :
1344: --IN : p_api_version IN NUMBER Required
1345: -- : p_init_msg_list IN VARCHAR2 Optional

Line 1414: 'Before inserting a row into OKC_REP_SIGNATURE_DETAILS');

1410:
1411: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1412: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1413: g_module || l_api_name,
1414: 'Before inserting a row into OKC_REP_SIGNATURE_DETAILS');
1415: END IF;
1416:
1417: -- Insert a row into okc_rep_signature_details
1418: INSERT INTO OKC_REP_SIGNATURE_DETAILS(

Line 1417: -- Insert a row into okc_rep_signature_details

1413: g_module || l_api_name,
1414: 'Before inserting a row into OKC_REP_SIGNATURE_DETAILS');
1415: END IF;
1416:
1417: -- Insert a row into okc_rep_signature_details
1418: INSERT INTO OKC_REP_SIGNATURE_DETAILS(
1419: contract_id,
1420: sequence_level,
1421: contact_id,

Line 1418: INSERT INTO OKC_REP_SIGNATURE_DETAILS(

1414: 'Before inserting a row into OKC_REP_SIGNATURE_DETAILS');
1415: END IF;
1416:
1417: -- Insert a row into okc_rep_signature_details
1418: INSERT INTO OKC_REP_SIGNATURE_DETAILS(
1419: contract_id,
1420: sequence_level,
1421: contact_id,
1422: party_id,

Line 1460: 'After inserting a row into OKC_REP_SIGNATURE_DETAILS');

1456:
1457: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1458: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1459: g_module || l_api_name,
1460: 'After inserting a row into OKC_REP_SIGNATURE_DETAILS');
1461: END IF;
1462: EXCEPTION
1463: WHEN FND_API.G_EXC_ERROR THEN
1464: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5885: --insert into okc_rep_signature_details

5881: AND contract_id < l_start_contract_id + l_insert_batch_size;
5882:
5883: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_contract_parties *****');
5884:
5885: --insert into okc_rep_signature_details
5886: INSERT INTO OKC_REP_SIGNATURE_DETAILS
5887: (
5888: contract_id,
5889: contract_version_num,

Line 5886: INSERT INTO OKC_REP_SIGNATURE_DETAILS

5882:
5883: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_contract_parties *****');
5884:
5885: --insert into okc_rep_signature_details
5886: INSERT INTO OKC_REP_SIGNATURE_DETAILS
5887: (
5888: contract_id,
5889: contract_version_num,
5890: party_role_code,

Line 5931: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO OKC_REP_SIGNATURE_DETAILS *****');

5927: AND sig.contract_id >= l_start_contract_id
5928: AND sig.contract_id < l_start_contract_id + l_insert_batch_size
5929: AND sig.contract_id = con.contract_id;
5930:
5931: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO OKC_REP_SIGNATURE_DETAILS *****');
5932:
5933: --insert into status history
5934: INSERT INTO okc_rep_con_status_hist
5935: (