APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_CON_STATUS_HIST

Line 1022: * caused this into database tables OKC_REP_CON_STATUS_HIST.

1018:
1019:
1020: /**
1021: * This procedure changes status of a contract and logs the user action that
1022: * caused this into database tables OKC_REP_CON_STATUS_HIST.
1023: * @param IN p_contract_id Id of the contract whose status to be changed
1024: * @param IN p_contract_version Version number of the contract whose status to be changed
1025: * @param IN p_status_code New status code to be set on the contract
1026: * @param IN p_user_id Id of the user who caused this change

Line 1091: -- Log this status change into OKC_REP_CON_STATUS_HIST table

1087: g_module || l_api_name,
1088: 'After updating Contract Status');
1089: END IF;
1090:
1091: -- Log this status change into OKC_REP_CON_STATUS_HIST table
1092: IF (p_user_id IS NULL) THEN
1093: l_user_id := FND_GLOBAL.user_id();
1094:
1095: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1108: 'Before inserting a row into OKC_REP_CON_STATUS_HIST');

1104:
1105: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1106: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1107: g_module || l_api_name,
1108: 'Before inserting a row into OKC_REP_CON_STATUS_HIST');
1109: END IF;
1110:
1111: -- Insert row into OKC_REP_CON_STATUS_HIST
1112: INSERT INTO OKC_REP_CON_STATUS_HIST(

Line 1111: -- Insert row into OKC_REP_CON_STATUS_HIST

1107: g_module || l_api_name,
1108: 'Before inserting a row into OKC_REP_CON_STATUS_HIST');
1109: END IF;
1110:
1111: -- Insert row into OKC_REP_CON_STATUS_HIST
1112: INSERT INTO OKC_REP_CON_STATUS_HIST(
1113: contract_id,
1114: contract_version_num,
1115: status_code,

Line 1112: INSERT INTO OKC_REP_CON_STATUS_HIST(

1108: 'Before inserting a row into OKC_REP_CON_STATUS_HIST');
1109: END IF;
1110:
1111: -- Insert row into OKC_REP_CON_STATUS_HIST
1112: INSERT INTO OKC_REP_CON_STATUS_HIST(
1113: contract_id,
1114: contract_version_num,
1115: status_code,
1116: status_change_date,

Line 1140: 'After inserting a row into OKC_REP_CON_STATUS_HIST');

1136:
1137: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1138: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1139: g_module || l_api_name,
1140: 'After inserting a row into OKC_REP_CON_STATUS_HIST');
1141: END IF;
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5591: -- It also insert a record into OKC_REP_CON_STATUS_HIST for every record

5587: --Type : Private.
5588: --Function : Insert validated contracts and parties into production tables
5589: -- i.e., move from OKC_REP_IMP_CONTRACTS_T and OKC_REP_IMP_PARTIES_T
5590: -- to OKC_REP_CONTRACTS_ALL AND OKC_REP_CONTRACT_PARTIES
5591: -- It also insert a record into OKC_REP_CON_STATUS_HIST for every record
5592: -- inserted into OKC_REP_CONTRACTS_ALL.
5593: --Pre-reqs : Currently only called from repository import.
5594: -- Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table
5595: -- Date should all be validated in OKC_REP_IMP_CONTRACTS_T,

Line 5934: INSERT INTO okc_rep_con_status_hist

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: (
5936: contract_id,
5937: contract_version_num,
5938: status_code,

Line 5966: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_con_status_hist *****');

5962: AND created_by = FND_GLOBAL.USER_ID
5963: AND contract_id >= l_start_contract_id
5964: AND contract_id < l_start_contract_id + l_insert_batch_size;
5965:
5966: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_con_status_hist *****');
5967:
5968: --kkolukul
5969: --insert into party contacts
5970: INSERT INTO okc_rep_party_contacts