eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_REP_CONTRACTS_ALL

Line 46: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%TYPE;

42: l_api_name VARCHAR2(30);
43: l_api_version NUMBER;
44: l_user_key wf_items.user_key%TYPE;
45: l_wf_sequence wf_items.item_key%TYPE;
46: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%TYPE;
47:
48: CURSOR contract_csr IS
49: SELECT contract_number
50: FROM okc_rep_contracts_all

Line 50: FROM okc_rep_contracts_all

46: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%TYPE;
47:
48: CURSOR contract_csr IS
49: SELECT contract_number
50: FROM okc_rep_contracts_all
51: WHERE contract_id = p_contract_id;
52:
53: BEGIN
54:

Line 217: -- Update WF columns in OKC_REP_CONTRACTS_ALL

213: itemkey => l_wf_sequence);
214:
215:
216:
217: -- Update WF columns in OKC_REP_CONTRACTS_ALL
218: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
219: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
220: 'Updating workflow columns in OKC_REP_CONTRACTS_ALL');
221: END IF;

Line 220: 'Updating workflow columns in OKC_REP_CONTRACTS_ALL');

216:
217: -- Update WF columns in OKC_REP_CONTRACTS_ALL
218: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
219: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
220: 'Updating workflow columns in OKC_REP_CONTRACTS_ALL');
221: END IF;
222: UPDATE OKC_REP_CONTRACTS_ALL
223: SET wf_item_type = G_APPROVAL_ITEM_TYPE, wf_item_key = l_wf_sequence
224: WHERE contract_id=p_contract_id;

Line 222: UPDATE OKC_REP_CONTRACTS_ALL

218: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
219: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
220: 'Updating workflow columns in OKC_REP_CONTRACTS_ALL');
221: END IF;
222: UPDATE OKC_REP_CONTRACTS_ALL
223: SET wf_item_type = G_APPROVAL_ITEM_TYPE, wf_item_key = l_wf_sequence
224: WHERE contract_id=p_contract_id;
225:
226: COMMIT WORK;

Line 568: FROM OKC_REP_CONTRACTS_ALL

564: l_api_version NUMBER;
565:
566: CURSOR contract_csr IS
567: SELECT contract_type, contract_version_num
568: FROM OKC_REP_CONTRACTS_ALL
569: WHERE contract_id = p_contract_id;
570:
571: contract_rec contract_csr%ROWTYPE;
572:

Line 1378: -- Lock_Row for:OKC_REP_CONTRACTS_ALL --

1374: ---------------------------------------------------------------------------
1375: -- PROCEDURE Lock_Row
1376: ---------------------------------------------------------------------------
1377: -----------------------------------
1378: -- Lock_Row for:OKC_REP_CONTRACTS_ALL --
1379: -----------------------------------
1380: FUNCTION Lock_Contract_Header(
1381: p_contract_id IN NUMBER,
1382: p_object_version_number IN NUMBER

Line 1386: l_object_version_number OKC_REP_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE;

1382: p_object_version_number IN NUMBER
1383: ) RETURN VARCHAR2 IS
1384:
1385: l_return_status VARCHAR2(1);
1386: l_object_version_number OKC_REP_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE;
1387: l_row_notfound BOOLEAN := FALSE;
1388: l_api_name VARCHAR2(30);
1389:
1390: CURSOR lock_csr (cp_contract_id NUMBER, cp_object_version_number NUMBER) IS

Line 1392: FROM OKC_REP_CONTRACTS_ALL

1388: l_api_name VARCHAR2(30);
1389:
1390: CURSOR lock_csr (cp_contract_id NUMBER, cp_object_version_number NUMBER) IS
1391: SELECT object_version_number
1392: FROM OKC_REP_CONTRACTS_ALL
1393: WHERE CONTRACT_ID = cp_contract_id
1394: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1395: FOR UPDATE OF object_version_number NOWAIT;
1396:

Line 1399: FROM OKC_REP_CONTRACTS_ALL

1395: FOR UPDATE OF object_version_number NOWAIT;
1396:
1397: CURSOR lchk_csr (cp_contract_id NUMBER) IS
1398: SELECT object_version_number
1399: FROM OKC_REP_CONTRACTS_ALL
1400: WHERE CONTRACT_ID = cp_contract_id;
1401: BEGIN
1402:
1403: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1494: --Function : Locks a row in OKC_REP_CONTRACTS_ALL table

1490:
1491: -- Start of comments
1492: --API name : lock_contract_header
1493: --Type : Private.
1494: --Function : Locks a row in OKC_REP_CONTRACTS_ALL table
1495: --Pre-reqs : None.
1496: --Parameters :
1497: --IN : p_contract_id IN NUMBER Required
1498: -- Contract ID of the contract to be locked.

Line 1607: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;

1603: x_return_status OUT NOCOPY VARCHAR2) IS
1604:
1605: l_api_name VARCHAR2(30);
1606: l_api_version NUMBER;
1607: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
1608: l_prev_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
1609: l_prev_con_vers_status OKC_REP_CONTRACTS_ALL.contract_status_code%TYPE;
1610: l_is_activated VARCHAR2(1);
1611:

Line 1608: l_prev_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;

1604:
1605: l_api_name VARCHAR2(30);
1606: l_api_version NUMBER;
1607: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
1608: l_prev_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
1609: l_prev_con_vers_status OKC_REP_CONTRACTS_ALL.contract_status_code%TYPE;
1610: l_is_activated VARCHAR2(1);
1611:
1612:

Line 1609: l_prev_con_vers_status OKC_REP_CONTRACTS_ALL.contract_status_code%TYPE;

1605: l_api_name VARCHAR2(30);
1606: l_api_version NUMBER;
1607: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
1608: l_prev_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
1609: l_prev_con_vers_status OKC_REP_CONTRACTS_ALL.contract_status_code%TYPE;
1610: l_is_activated VARCHAR2(1);
1611:
1612:
1613: CURSOR contract_csr IS

Line 1615: FROM OKC_REP_CONTRACTS_ALL

1611:
1612:
1613: CURSOR contract_csr IS
1614: SELECT contract_type, contract_version_num
1615: FROM OKC_REP_CONTRACTS_ALL
1616: WHERE contract_id = p_contract_id;
1617:
1618: CURSOR prev_con_vers_status (p_contract_id IN NUMBER, p_con_version IN NUMBER) IS
1619: SELECT contract_status_code

Line 2090: -- Delete contract header from the main header table OKC_REP_CONTRACTS_ALL

2086: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2088: 'Deleting Contract header record');
2089: END IF;
2090: -- Delete contract header from the main header table OKC_REP_CONTRACTS_ALL
2091: DELETE FROM OKC_REP_CONTRACTS_ALL
2092: WHERE contract_id = p_contract_id;
2093:
2094: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2091: DELETE FROM OKC_REP_CONTRACTS_ALL

2087: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2088: 'Deleting Contract header record');
2089: END IF;
2090: -- Delete contract header from the main header table OKC_REP_CONTRACTS_ALL
2091: DELETE FROM OKC_REP_CONTRACTS_ALL
2092: WHERE contract_id = p_contract_id;
2093:
2094: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2095: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2101: INSERT INTO OKC_REP_CONTRACTS_ALL(

2097: END IF;
2098: -- If Version > 1, copy the latest version from the archive table.
2099: if (contract_rec.contract_version_num > 1) THEN
2100: l_prev_version := contract_rec.contract_version_num - 1;
2101: INSERT INTO OKC_REP_CONTRACTS_ALL(
2102: CONTRACT_ID,
2103: CONTRACT_VERSION_NUM,
2104: CONTRACT_NUMBER,
2105: CONTRACT_TYPE,

Line 2704: FROM OKC_REP_CONTRACTS_ALL

2700:
2701: -- Contract cursor to get contract_type and version
2702: CURSOR contract_csr IS
2703: SELECT contract_type, contract_version_num
2704: FROM OKC_REP_CONTRACTS_ALL
2705: WHERE contract_id = p_source_contract_id;
2706:
2707: contract_rec contract_csr%ROWTYPE;
2708: BEGIN

Line 3120: x_target_contract_id OKC_REP_CONTRACTS_ALL.CONTRACT_ID%TYPE;

3116: l_api_version NUMBER;
3117: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
3118:
3119: -- Repository Enhancement 12.1 (For Duplicate Action)
3120: x_target_contract_id OKC_REP_CONTRACTS_ALL.CONTRACT_ID%TYPE;
3121: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;
3122: -- Repository Enhancement 12.1 ends
3123:
3124:

Line 3127: FROM OKC_REP_CONTRACTS_ALL

3123:
3124:
3125: CURSOR source_contract_csr IS
3126: SELECT contract_type, owner_id
3127: FROM OKC_REP_CONTRACTS_ALL
3128: WHERE contract_id = p_source_contract_id;
3129:
3130: source_contract_rec source_contract_csr%ROWTYPE;
3131:

Line 3518: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;

3514: x_msg_count OUT NOCOPY NUMBER,
3515: x_return_status OUT NOCOPY VARCHAR2) IS
3516: l_api_name VARCHAR2(30);
3517: l_api_version NUMBER;
3518: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
3519: l_contract_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
3520: -- Repository Enhancement 12.1 (For Create New Version Action)
3521: l_conterms_exist_flag VARCHAR2(1);
3522:

Line 3519: l_contract_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;

3515: x_return_status OUT NOCOPY VARCHAR2) IS
3516: l_api_name VARCHAR2(30);
3517: l_api_version NUMBER;
3518: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
3519: l_contract_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
3520: -- Repository Enhancement 12.1 (For Create New Version Action)
3521: l_conterms_exist_flag VARCHAR2(1);
3522:
3523: CURSOR contract_csr IS

Line 3525: FROM OKC_REP_CONTRACTS_ALL

3521: l_conterms_exist_flag VARCHAR2(1);
3522:
3523: CURSOR contract_csr IS
3524: SELECT contract_type, contract_version_num, contract_status_code
3525: FROM OKC_REP_CONTRACTS_ALL
3526: WHERE contract_id = p_contract_id;
3527:
3528: contract_rec contract_csr%ROWTYPE;
3529: -- Repository Enhancement 12.1 (For Create New Version Action)

Line 3713: FROM OKC_REP_CONTRACTS_ALL

3709: CONTRACT_LAST_UPDATE_DATE,
3710: CONTRACT_LAST_UPDATED_BY,
3711: REFERENCE_DOCUMENT_TYPE,
3712: REFERENCE_DOCUMENT_NUMBER
3713: FROM OKC_REP_CONTRACTS_ALL
3714: WHERE contract_id = p_contract_id;
3715:
3716: -- Get contract_type of the contract, required for deliverables and documents APIs
3717: OPEN contract_csr;

Line 3900: DELETE FROM OKC_REP_CONTRACTS_ALL

3896: END IF;
3897:
3898:
3899: -- Delete the header record
3900: DELETE FROM OKC_REP_CONTRACTS_ALL
3901: WHERE contract_id=p_contract_id;
3902:
3903: -- Standard check of p_commit
3904: IF FND_API.To_Boolean( p_commit ) THEN

Line 4013: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;

4009: l_update_event_tbl EVENT_TBL_TYPE;
4010: l_sync_flag VARCHAR2(1);
4011: l_expiration_date_matches_flag VARCHAR2(1);
4012: l_effective_date_matches_flag VARCHAR2(1);
4013: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4014: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4015:
4016: CURSOR contract_csr IS
4017: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date

Line 4014: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;

4010: l_sync_flag VARCHAR2(1);
4011: l_expiration_date_matches_flag VARCHAR2(1);
4012: l_effective_date_matches_flag VARCHAR2(1);
4013: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4014: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4015:
4016: CURSOR contract_csr IS
4017: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date
4018: FROM OKC_REP_CONTRACTS_ALL

Line 4018: FROM OKC_REP_CONTRACTS_ALL

4014: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4015:
4016: CURSOR contract_csr IS
4017: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date
4018: FROM OKC_REP_CONTRACTS_ALL
4019: WHERE contract_id = p_contract_id;
4020:
4021: CURSOR arch_contract_csr (l_contract_version NUMBER) IS
4022: SELECT contract_effective_date, contract_expiration_date

Line 4316: UPDATE okc_rep_contracts_all

4312: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4313: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4314: 'Updating latest_signed_ver_number column');
4315: END IF;
4316: UPDATE okc_rep_contracts_all
4317: SET latest_signed_ver_number = contract_rec.contract_version_num
4318: WHERE contract_id = p_contract_id;
4319: CLOSE contract_csr;
4320: -- Standard check of p_commit

Line 4445: FROM OKC_REP_CONTRACTS_ALL

4441:
4442: CURSOR contract_csr IS
4443: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date,
4444: contract_expiration_date, termination_date
4445: FROM OKC_REP_CONTRACTS_ALL
4446: WHERE contract_id = p_contract_id;
4447:
4448: contract_rec contract_csr%ROWTYPE;
4449: BEGIN

Line 5022: 'Updating okc_rep_contracts_all and okc_rep_contract_vers with wf_exp_ntf_item_key ' || l_item_key);

5018: itemkey => l_item_key);
5019:
5020: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5021: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5022: 'Updating okc_rep_contracts_all and okc_rep_contract_vers with wf_exp_ntf_item_key ' || l_item_key);
5023: END IF;
5024:
5025: --update contracts with sent notifications
5026: UPDATE okc_rep_contracts_all c

Line 5026: UPDATE okc_rep_contracts_all c

5022: 'Updating okc_rep_contracts_all and okc_rep_contract_vers with wf_exp_ntf_item_key ' || l_item_key);
5023: END IF;
5024:
5025: --update contracts with sent notifications
5026: UPDATE okc_rep_contracts_all c
5027: SET c.wf_exp_ntf_item_key = l_item_key
5028: WHERE c.contract_id = p_contract_id
5029: AND c.contract_version_num = p_contract_version;
5030:

Line 5169: l_contract_status okc_rep_contracts_all.contract_status_code%TYPE;

5165: l_api_name VARCHAR2(30);
5166: l_api_version NUMBER;
5167: l_wf_type wf_item_activity_statuses.item_type%TYPE;
5168: l_wf_key wf_item_activity_statuses.item_key%TYPE;
5169: l_contract_status okc_rep_contracts_all.contract_status_code%TYPE;
5170: l_contract_number okc_rep_contracts_all.contract_number%TYPE;
5171:
5172: CURSOR contract_csr IS
5173: SELECT wf_item_type, wf_item_key, contract_status_code, contract_number

Line 5170: l_contract_number okc_rep_contracts_all.contract_number%TYPE;

5166: l_api_version NUMBER;
5167: l_wf_type wf_item_activity_statuses.item_type%TYPE;
5168: l_wf_key wf_item_activity_statuses.item_key%TYPE;
5169: l_contract_status okc_rep_contracts_all.contract_status_code%TYPE;
5170: l_contract_number okc_rep_contracts_all.contract_number%TYPE;
5171:
5172: CURSOR contract_csr IS
5173: SELECT wf_item_type, wf_item_key, contract_status_code, contract_number
5174: FROM okc_rep_contracts_all

Line 5174: FROM okc_rep_contracts_all

5170: l_contract_number okc_rep_contracts_all.contract_number%TYPE;
5171:
5172: CURSOR contract_csr IS
5173: SELECT wf_item_type, wf_item_key, contract_status_code, contract_number
5174: FROM okc_rep_contracts_all
5175: WHERE contract_id = p_contract_id;
5176:
5177: BEGIN
5178:

Line 5442: l_contract_number OKC_REP_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE;

5438: l_doc_sequence_id NUMBER;
5439: l_profile_doc_seq VARCHAR2(1);
5440: l_result NUMBER;
5441: l_row_notfound BOOLEAN := FALSE;
5442: l_contract_number OKC_REP_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE;
5443:
5444:
5445: CURSOR l_get_sob_csr IS
5446: SELECT OI2.ORG_INFORMATION3 SET_OF_BOOKS_ID

Line 5459: FROM OKC_REP_CONTRACTS_ALL

5455: OI1.ORGANIZATION_ID = p_org_id;
5456:
5457: CURSOR l_ensure_unique_csr (p_contract_number IN VARCHAR2) IS
5458: SELECT CONTRACT_NUMBER
5459: FROM OKC_REP_CONTRACTS_ALL
5460: WHERE CONTRACT_NUMBER = p_contract_number
5461: AND ROWNUM < 2;
5462:
5463: BEGIN