APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_CON_STATUS_HIST

Line 941: * caused this into database tables OKC_REP_CON_STATUS_HIST.

937:
938:
939: /**
940: * This procedure changes status of a contract and logs the user action that
941: * caused this into database tables OKC_REP_CON_STATUS_HIST.
942: * @param IN p_contract_id Id of the contract whose status to be changed
943: * @param IN p_contract_version Version number of the contract whose status to be changed
944: * @param IN p_status_code New status code to be set on the contract
945: * @param IN p_user_id Id of the user who caused this change

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

1006: g_module || l_api_name,
1007: 'After updating Contract Status');
1008: END IF;
1009:
1010: -- Log this status change into OKC_REP_CON_STATUS_HIST table
1011: IF (p_user_id IS NULL) THEN
1012: l_user_id := FND_GLOBAL.user_id();
1013:
1014: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1023:
1024: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1025: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1026: g_module || l_api_name,
1027: 'Before inserting a row into OKC_REP_CON_STATUS_HIST');
1028: END IF;
1029:
1030: -- Insert row into OKC_REP_CON_STATUS_HIST
1031: INSERT INTO OKC_REP_CON_STATUS_HIST(

Line 1030: -- Insert row into OKC_REP_CON_STATUS_HIST

1026: g_module || l_api_name,
1027: 'Before inserting a row into OKC_REP_CON_STATUS_HIST');
1028: END IF;
1029:
1030: -- Insert row into OKC_REP_CON_STATUS_HIST
1031: INSERT INTO OKC_REP_CON_STATUS_HIST(
1032: contract_id,
1033: contract_version_num,
1034: status_code,

Line 1031: INSERT INTO OKC_REP_CON_STATUS_HIST(

1027: 'Before inserting a row into OKC_REP_CON_STATUS_HIST');
1028: END IF;
1029:
1030: -- Insert row into OKC_REP_CON_STATUS_HIST
1031: INSERT INTO OKC_REP_CON_STATUS_HIST(
1032: contract_id,
1033: contract_version_num,
1034: status_code,
1035: status_change_date,

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

1055:
1056: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1057: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1058: g_module || l_api_name,
1059: 'After inserting a row into OKC_REP_CON_STATUS_HIST');
1060: END IF;
1061: EXCEPTION
1062: WHEN FND_API.G_EXC_ERROR THEN
1063: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4891: --Type : Private.
4892: --Function : Insert validated contracts and parties into production tables
4893: -- i.e., move from OKC_REP_IMP_CONTRACTS_T and OKC_REP_IMP_PARTIES_T
4894: -- to OKC_REP_CONTRACTS_ALL AND OKC_REP_CONTRACT_PARTIES
4895: -- It also insert a record into OKC_REP_CON_STATUS_HIST for every record
4896: -- inserted into OKC_REP_CONTRACTS_ALL.
4897: --Pre-reqs : Currently only called from repository import.
4898: -- Contracts should be saved to the OKC_REP_IMP_CONTRACTS_T table
4899: -- Date should all be validated in OKC_REP_IMP_CONTRACTS_T,

Line 5178: INSERT INTO okc_rep_con_status_hist

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: (
5180: contract_id,
5181: contract_version_num,
5182: status_code,

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

5206: AND created_by = FND_GLOBAL.USER_ID
5207: AND contract_id >= l_start_contract_id
5208: AND contract_id < l_start_contract_id + l_insert_batch_size;
5209:
5210: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_con_status_hist *****');
5211:
5212: COMMIT;
5213:
5214: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** COMMIT *****');