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 47: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%TYPE;

43: l_api_name VARCHAR2(30);
44: l_api_version NUMBER;
45: l_user_key wf_items.user_key%TYPE;
46: l_wf_sequence wf_items.item_key%TYPE;
47: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%TYPE;
48: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
49: l_org_id OKC_REP_CONTRACTS_ALL.org_id%TYPE;
50: l_contract_version okc_rep_contracts_all.contract_version_num%TYPE;
51: l_wf_name wf_items.item_type%TYPE;

Line 48: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;

44: l_api_version NUMBER;
45: l_user_key wf_items.user_key%TYPE;
46: l_wf_sequence wf_items.item_key%TYPE;
47: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%TYPE;
48: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
49: l_org_id OKC_REP_CONTRACTS_ALL.org_id%TYPE;
50: l_contract_version okc_rep_contracts_all.contract_version_num%TYPE;
51: l_wf_name wf_items.item_type%TYPE;
52:

Line 49: l_org_id OKC_REP_CONTRACTS_ALL.org_id%TYPE;

45: l_user_key wf_items.user_key%TYPE;
46: l_wf_sequence wf_items.item_key%TYPE;
47: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%TYPE;
48: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
49: l_org_id OKC_REP_CONTRACTS_ALL.org_id%TYPE;
50: l_contract_version okc_rep_contracts_all.contract_version_num%TYPE;
51: l_wf_name wf_items.item_type%TYPE;
52:
53: CURSOR contract_csr IS

Line 50: l_contract_version okc_rep_contracts_all.contract_version_num%TYPE;

46: l_wf_sequence wf_items.item_key%TYPE;
47: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%TYPE;
48: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
49: l_org_id OKC_REP_CONTRACTS_ALL.org_id%TYPE;
50: l_contract_version okc_rep_contracts_all.contract_version_num%TYPE;
51: l_wf_name wf_items.item_type%TYPE;
52:
53: CURSOR contract_csr IS
54: SELECT contract_number,CONTRACT_TYPE,ORG_ID,contract_version_num

Line 55: FROM okc_rep_contracts_all

51: l_wf_name wf_items.item_type%TYPE;
52:
53: CURSOR contract_csr IS
54: SELECT contract_number,CONTRACT_TYPE,ORG_ID,contract_version_num
55: FROM okc_rep_contracts_all
56: WHERE contract_id = p_contract_id;
57:
58: CURSOR fetch_wf_name(p_contract_type varchar2) IS
59: SELECT approval_workflow_name FROM okc_bus_doc_types_b WHERE document_type= p_contract_type;

Line 281: -- Update WF columns in OKC_REP_CONTRACTS_ALL

277: itemkey => l_wf_sequence);
278:
279:
280:
281: -- Update WF columns in OKC_REP_CONTRACTS_ALL
282: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
283: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
284: 'Updating workflow columns in OKC_REP_CONTRACTS_ALL');
285: END IF;

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

280:
281: -- Update WF columns in OKC_REP_CONTRACTS_ALL
282: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
283: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
284: 'Updating workflow columns in OKC_REP_CONTRACTS_ALL');
285: END IF;
286: UPDATE OKC_REP_CONTRACTS_ALL
287: SET wf_item_type = l_wf_name, wf_item_key = l_wf_sequence
288: WHERE contract_id=p_contract_id;

Line 286: UPDATE OKC_REP_CONTRACTS_ALL

282: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
283: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
284: 'Updating workflow columns in OKC_REP_CONTRACTS_ALL');
285: END IF;
286: UPDATE OKC_REP_CONTRACTS_ALL
287: SET wf_item_type = l_wf_name, wf_item_key = l_wf_sequence
288: WHERE contract_id=p_contract_id;
289:
290: COMMIT WORK;

Line 669: FROM OKC_REP_CONTRACTS_ALL

665: l_api_version NUMBER;
666:
667: CURSOR contract_csr IS
668: SELECT contract_type, contract_version_num
669: FROM OKC_REP_CONTRACTS_ALL
670: WHERE contract_id = p_contract_id;
671:
672: contract_rec contract_csr%ROWTYPE;
673:

Line 827: FROM OKC_REP_CONTRACTS_ALL

823:
824:
825: CURSOR contract_csr IS
826: SELECT contract_type, contract_version_num
827: FROM OKC_REP_CONTRACTS_ALL
828: WHERE contract_id = p_contract_id;
829:
830: contract_rec contract_csr%ROWTYPE;
831:

Line 1507: -- Lock_Row for:OKC_REP_CONTRACTS_ALL --

1503: ---------------------------------------------------------------------------
1504: -- PROCEDURE Lock_Row
1505: ---------------------------------------------------------------------------
1506: -----------------------------------
1507: -- Lock_Row for:OKC_REP_CONTRACTS_ALL --
1508: -----------------------------------
1509: FUNCTION Lock_Contract_Header(
1510: p_contract_id IN NUMBER,
1511: p_object_version_number IN NUMBER

Line 1515: l_object_version_number OKC_REP_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE;

1511: p_object_version_number IN NUMBER
1512: ) RETURN VARCHAR2 IS
1513:
1514: l_return_status VARCHAR2(1);
1515: l_object_version_number OKC_REP_CONTRACTS_ALL.OBJECT_VERSION_NUMBER%TYPE;
1516: l_row_notfound BOOLEAN := FALSE;
1517: l_api_name VARCHAR2(30);
1518:
1519: CURSOR lock_csr (cp_contract_id NUMBER, cp_object_version_number NUMBER) IS

Line 1521: FROM OKC_REP_CONTRACTS_ALL

1517: l_api_name VARCHAR2(30);
1518:
1519: CURSOR lock_csr (cp_contract_id NUMBER, cp_object_version_number NUMBER) IS
1520: SELECT object_version_number
1521: FROM OKC_REP_CONTRACTS_ALL
1522: WHERE CONTRACT_ID = cp_contract_id
1523: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1524: FOR UPDATE OF object_version_number NOWAIT;
1525:

Line 1528: FROM OKC_REP_CONTRACTS_ALL

1524: FOR UPDATE OF object_version_number NOWAIT;
1525:
1526: CURSOR lchk_csr (cp_contract_id NUMBER) IS
1527: SELECT object_version_number
1528: FROM OKC_REP_CONTRACTS_ALL
1529: WHERE CONTRACT_ID = cp_contract_id;
1530: BEGIN
1531:
1532: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1619:
1620: -- Start of comments
1621: --API name : lock_contract_header
1622: --Type : Private.
1623: --Function : Locks a row in OKC_REP_CONTRACTS_ALL table
1624: --Pre-reqs : None.
1625: --Parameters :
1626: --IN : p_contract_id IN NUMBER Required
1627: -- Contract ID of the contract to be locked.

Line 1736: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;

1732: x_return_status OUT NOCOPY VARCHAR2) IS
1733:
1734: l_api_name VARCHAR2(30);
1735: l_api_version NUMBER;
1736: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
1737: l_prev_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
1738: l_prev_con_vers_status OKC_REP_CONTRACTS_ALL.contract_status_code%TYPE;
1739: l_prev_con_vers_sign_type OKC_REP_CONTRACTS_ALL.esignature_required%TYPE;
1740: l_is_activated VARCHAR2(1);

Line 1737: l_prev_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;

1733:
1734: l_api_name VARCHAR2(30);
1735: l_api_version NUMBER;
1736: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
1737: l_prev_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
1738: l_prev_con_vers_status OKC_REP_CONTRACTS_ALL.contract_status_code%TYPE;
1739: l_prev_con_vers_sign_type OKC_REP_CONTRACTS_ALL.esignature_required%TYPE;
1740: l_is_activated VARCHAR2(1);
1741:

Line 1738: l_prev_con_vers_status OKC_REP_CONTRACTS_ALL.contract_status_code%TYPE;

1734: l_api_name VARCHAR2(30);
1735: l_api_version NUMBER;
1736: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
1737: l_prev_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
1738: l_prev_con_vers_status OKC_REP_CONTRACTS_ALL.contract_status_code%TYPE;
1739: l_prev_con_vers_sign_type OKC_REP_CONTRACTS_ALL.esignature_required%TYPE;
1740: l_is_activated VARCHAR2(1);
1741:
1742:

Line 1739: l_prev_con_vers_sign_type OKC_REP_CONTRACTS_ALL.esignature_required%TYPE;

1735: l_api_version NUMBER;
1736: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
1737: l_prev_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
1738: l_prev_con_vers_status OKC_REP_CONTRACTS_ALL.contract_status_code%TYPE;
1739: l_prev_con_vers_sign_type OKC_REP_CONTRACTS_ALL.esignature_required%TYPE;
1740: l_is_activated VARCHAR2(1);
1741:
1742:
1743: CURSOR contract_csr IS

Line 1745: FROM OKC_REP_CONTRACTS_ALL

1741:
1742:
1743: CURSOR contract_csr IS
1744: SELECT contract_type, contract_version_num
1745: FROM OKC_REP_CONTRACTS_ALL
1746: WHERE contract_id = p_contract_id;
1747:
1748: CURSOR prev_con_vers_status (p_contract_id IN NUMBER, p_con_version IN NUMBER) IS
1749: SELECT contract_status_code, esignature_required

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

2244: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2245: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2246: 'Deleting Contract header record');
2247: END IF;
2248: -- Delete contract header from the main header table OKC_REP_CONTRACTS_ALL
2249: DELETE FROM OKC_REP_CONTRACTS_ALL
2250: WHERE contract_id = p_contract_id;
2251:
2252: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2249: DELETE FROM OKC_REP_CONTRACTS_ALL

2245: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2246: 'Deleting Contract header record');
2247: END IF;
2248: -- Delete contract header from the main header table OKC_REP_CONTRACTS_ALL
2249: DELETE FROM OKC_REP_CONTRACTS_ALL
2250: WHERE contract_id = p_contract_id;
2251:
2252: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2253: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2259: INSERT INTO OKC_REP_CONTRACTS_ALL(

2255: END IF;
2256: -- If Version > 1, copy the latest version from the archive table.
2257: if (contract_rec.contract_version_num > 1) THEN
2258: l_prev_version := contract_rec.contract_version_num - 1;
2259: INSERT INTO OKC_REP_CONTRACTS_ALL(
2260: CONTRACT_ID,
2261: CONTRACT_VERSION_NUM,
2262: CONTRACT_NUMBER,
2263: CONTRACT_TYPE,

Line 2874: FROM OKC_REP_CONTRACTS_ALL

2870:
2871: -- Contract cursor to get contract_type and version
2872: CURSOR contract_csr IS
2873: SELECT contract_type, contract_version_num
2874: FROM OKC_REP_CONTRACTS_ALL
2875: WHERE contract_id = p_source_contract_id;
2876:
2877: contract_rec contract_csr%ROWTYPE;
2878: BEGIN

Line 3290: x_target_contract_id OKC_REP_CONTRACTS_ALL.CONTRACT_ID%TYPE;

3286: l_api_version NUMBER;
3287: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
3288:
3289: -- Repository Enhancement 12.1 (For Duplicate Action)
3290: x_target_contract_id OKC_REP_CONTRACTS_ALL.CONTRACT_ID%TYPE;
3291: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;
3292: -- Repository Enhancement 12.1 ends
3293:
3294:

Line 3297: FROM OKC_REP_CONTRACTS_ALL

3293:
3294:
3295: CURSOR source_contract_csr IS
3296: SELECT contract_type, owner_id
3297: FROM OKC_REP_CONTRACTS_ALL
3298: WHERE contract_id = p_source_contract_id;
3299:
3300: source_contract_rec source_contract_csr%ROWTYPE;
3301:

Line 3737: FROM OKC_REP_CONTRACTS_ALL

3733:
3734: -- Contract cursor to get contract_type and version
3735: CURSOR contract_csr IS
3736: SELECT contract_type, contract_version_num
3737: FROM OKC_REP_CONTRACTS_ALL
3738: WHERE contract_id = p_contract_id;
3739:
3740: contract_rec contract_csr%ROWTYPE;
3741:

Line 3961: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;

3957: x_msg_count OUT NOCOPY NUMBER,
3958: x_return_status OUT NOCOPY VARCHAR2) IS
3959: l_api_name VARCHAR2(30);
3960: l_api_version NUMBER;
3961: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
3962: l_contract_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
3963: -- Repository Enhancement 12.1 (For Create New Version Action)
3964: l_conterms_exist_flag VARCHAR2(1);
3965:

Line 3962: l_contract_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;

3958: x_return_status OUT NOCOPY VARCHAR2) IS
3959: l_api_name VARCHAR2(30);
3960: l_api_version NUMBER;
3961: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%TYPE;
3962: l_contract_version OKC_REP_CONTRACTS_ALL.CONTRACT_VERSION_NUM%TYPE;
3963: -- Repository Enhancement 12.1 (For Create New Version Action)
3964: l_conterms_exist_flag VARCHAR2(1);
3965:
3966: CURSOR contract_csr IS

Line 3968: FROM OKC_REP_CONTRACTS_ALL

3964: l_conterms_exist_flag VARCHAR2(1);
3965:
3966: CURSOR contract_csr IS
3967: SELECT contract_type, contract_version_num, contract_status_code
3968: FROM OKC_REP_CONTRACTS_ALL
3969: WHERE contract_id = p_contract_id;
3970:
3971: contract_rec contract_csr%ROWTYPE;
3972: -- Repository Enhancement 12.1 (For Create New Version Action)

Line 4170: FROM OKC_REP_CONTRACTS_ALL

4166: ORIG_SYSTEM_REFERENCE_ID2,
4167: ESIGNATURE_REQUIRED,
4168: UDA_TEMPLATE_ID,
4169: SBCR_COORDINATION_TYPE
4170: FROM OKC_REP_CONTRACTS_ALL
4171: WHERE contract_id = p_contract_id;
4172:
4173: -- Get contract_type of the contract, required for deliverables and documents APIs
4174: OPEN contract_csr;

Line 4406: DELETE FROM OKC_REP_CONTRACTS_ALL

4402:
4403: -- If this is called from API versioning, do not delete the header
4404: IF(p_version_from_api = fnd_api.g_false) THEN
4405: -- Delete the header record
4406: DELETE FROM OKC_REP_CONTRACTS_ALL
4407: WHERE contract_id=p_contract_id;
4408: END IF;
4409:
4410: -- Standard check of p_commit

Line 4520: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;

4516: l_update_event_tbl EVENT_TBL_TYPE;
4517: l_sync_flag VARCHAR2(1);
4518: l_expiration_date_matches_flag VARCHAR2(1);
4519: l_effective_date_matches_flag VARCHAR2(1);
4520: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4521: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4522:
4523: CURSOR contract_csr IS
4524: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date

Line 4521: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;

4517: l_sync_flag VARCHAR2(1);
4518: l_expiration_date_matches_flag VARCHAR2(1);
4519: l_effective_date_matches_flag VARCHAR2(1);
4520: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4521: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4522:
4523: CURSOR contract_csr IS
4524: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date
4525: FROM OKC_REP_CONTRACTS_ALL

Line 4525: FROM OKC_REP_CONTRACTS_ALL

4521: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4522:
4523: CURSOR contract_csr IS
4524: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date
4525: FROM OKC_REP_CONTRACTS_ALL
4526: WHERE contract_id = p_contract_id;
4527:
4528: CURSOR arch_contract_csr (l_contract_version NUMBER) IS
4529: SELECT contract_effective_date, contract_expiration_date

Line 4823: UPDATE okc_rep_contracts_all

4819: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4820: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4821: 'Updating latest_signed_ver_number column');
4822: END IF;
4823: UPDATE okc_rep_contracts_all
4824: SET latest_signed_ver_number = contract_rec.contract_version_num
4825: WHERE contract_id = p_contract_id;
4826: CLOSE contract_csr;
4827: -- Standard check of p_commit

Line 4944: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;

4940: l_update_event_tbl EVENT_TBL_TYPE;
4941: l_sync_flag VARCHAR2(1);
4942: l_expiration_date_matches_flag VARCHAR2(1);
4943: l_effective_date_matches_flag VARCHAR2(1);
4944: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4945: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4946:
4947: CURSOR contract_csr IS
4948: SELECT contract_type,contract_name, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date

Line 4945: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;

4941: l_sync_flag VARCHAR2(1);
4942: l_expiration_date_matches_flag VARCHAR2(1);
4943: l_effective_date_matches_flag VARCHAR2(1);
4944: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4945: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4946:
4947: CURSOR contract_csr IS
4948: SELECT contract_type,contract_name, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date
4949: FROM OKC_REP_CONTRACTS_ALL

Line 4949: FROM OKC_REP_CONTRACTS_ALL

4945: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
4946:
4947: CURSOR contract_csr IS
4948: SELECT contract_type,contract_name, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date
4949: FROM OKC_REP_CONTRACTS_ALL
4950: WHERE contract_id = p_contract_id;
4951:
4952: CURSOR arch_contract_csr (l_contract_version NUMBER) IS
4953: SELECT contract_effective_date, contract_expiration_date

Line 4966: l_contract_status okc_rep_contracts_all.contract_status_code%TYPE;

4962:
4963: contract_rec contract_csr%ROWTYPE;
4964: arch_contract_rec arch_contract_csr%ROWTYPE;
4965:
4966: l_contract_status okc_rep_contracts_all.contract_status_code%TYPE;
4967: l_contract_number okc_rep_contracts_all.contract_number%TYPE;
4968: l_contract_version okc_rep_contracts_all.contract_version_num%TYPE;
4969: l_user_key wf_items.user_key%TYPE;
4970: l_wf_sequence wf_items.item_key%TYPE;

Line 4967: l_contract_number okc_rep_contracts_all.contract_number%TYPE;

4963: contract_rec contract_csr%ROWTYPE;
4964: arch_contract_rec arch_contract_csr%ROWTYPE;
4965:
4966: l_contract_status okc_rep_contracts_all.contract_status_code%TYPE;
4967: l_contract_number okc_rep_contracts_all.contract_number%TYPE;
4968: l_contract_version okc_rep_contracts_all.contract_version_num%TYPE;
4969: l_user_key wf_items.user_key%TYPE;
4970: l_wf_sequence wf_items.item_key%TYPE;
4971: l_wf_name wf_items.item_type%TYPE;

Line 4968: l_contract_version okc_rep_contracts_all.contract_version_num%TYPE;

4964: arch_contract_rec arch_contract_csr%ROWTYPE;
4965:
4966: l_contract_status okc_rep_contracts_all.contract_status_code%TYPE;
4967: l_contract_number okc_rep_contracts_all.contract_number%TYPE;
4968: l_contract_version okc_rep_contracts_all.contract_version_num%TYPE;
4969: l_user_key wf_items.user_key%TYPE;
4970: l_wf_sequence wf_items.item_key%TYPE;
4971: l_wf_name wf_items.item_type%TYPE;
4972:

Line 5206: -- Update WF columns in OKC_REP_CONTRACTS_ALL

5202: itemkey => l_wf_sequence);
5203:
5204:
5205:
5206: -- Update WF columns in OKC_REP_CONTRACTS_ALL
5207: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5208: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5209: 'Updating workflow columns in OKC_REP_CONTRACTS_ALL');
5210: END IF;

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

5205:
5206: -- Update WF columns in OKC_REP_CONTRACTS_ALL
5207: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5208: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5209: 'Updating workflow columns in OKC_REP_CONTRACTS_ALL');
5210: END IF;
5211:
5212: /*UPDATE OKC_REP_CONTRACTS_ALL
5213: SET wf_item_type = G_APPROVAL_ITEM_TYPE, wf_item_key = l_wf_sequence

Line 5212: /*UPDATE OKC_REP_CONTRACTS_ALL

5208: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5209: 'Updating workflow columns in OKC_REP_CONTRACTS_ALL');
5210: END IF;
5211:
5212: /*UPDATE OKC_REP_CONTRACTS_ALL
5213: SET wf_item_type = G_APPROVAL_ITEM_TYPE, wf_item_key = l_wf_sequence
5214: WHERE contract_id=p_contract_id;
5215: */
5216: COMMIT WORK;

Line 5347: FROM OKC_REP_CONTRACTS_ALL

5343:
5344: CURSOR contract_csr IS
5345: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date,
5346: contract_expiration_date, termination_date
5347: FROM OKC_REP_CONTRACTS_ALL
5348: WHERE contract_id = p_contract_id;
5349:
5350: contract_rec contract_csr%ROWTYPE;
5351: BEGIN

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

5970: itemkey => l_item_key);
5971:
5972: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5973: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5974: 'Updating okc_rep_contracts_all and okc_rep_contract_vers with wf_exp_ntf_item_key ' || l_item_key);
5975: END IF;
5976:
5977: --update contracts with sent notifications
5978: UPDATE okc_rep_contracts_all c

Line 5978: UPDATE okc_rep_contracts_all c

5974: 'Updating okc_rep_contracts_all and okc_rep_contract_vers with wf_exp_ntf_item_key ' || l_item_key);
5975: END IF;
5976:
5977: --update contracts with sent notifications
5978: UPDATE okc_rep_contracts_all c
5979: SET c.wf_exp_ntf_item_key = l_item_key
5980: WHERE c.contract_id = p_contract_id
5981: AND c.contract_version_num = p_contract_version;
5982:

Line 6121: l_contract_status okc_rep_contracts_all.contract_status_code%TYPE;

6117: l_api_name VARCHAR2(30);
6118: l_api_version NUMBER;
6119: l_wf_type wf_item_activity_statuses.item_type%TYPE;
6120: l_wf_key wf_item_activity_statuses.item_key%TYPE;
6121: l_contract_status okc_rep_contracts_all.contract_status_code%TYPE;
6122: l_contract_number okc_rep_contracts_all.contract_number%TYPE;
6123:
6124: CURSOR contract_csr IS
6125: SELECT wf_item_type, wf_item_key, contract_status_code, contract_number

Line 6122: l_contract_number okc_rep_contracts_all.contract_number%TYPE;

6118: l_api_version NUMBER;
6119: l_wf_type wf_item_activity_statuses.item_type%TYPE;
6120: l_wf_key wf_item_activity_statuses.item_key%TYPE;
6121: l_contract_status okc_rep_contracts_all.contract_status_code%TYPE;
6122: l_contract_number okc_rep_contracts_all.contract_number%TYPE;
6123:
6124: CURSOR contract_csr IS
6125: SELECT wf_item_type, wf_item_key, contract_status_code, contract_number
6126: FROM okc_rep_contracts_all

Line 6126: FROM okc_rep_contracts_all

6122: l_contract_number okc_rep_contracts_all.contract_number%TYPE;
6123:
6124: CURSOR contract_csr IS
6125: SELECT wf_item_type, wf_item_key, contract_status_code, contract_number
6126: FROM okc_rep_contracts_all
6127: WHERE contract_id = p_contract_id;
6128:
6129: CURSOR csr_child_notification(chld_item_key VARCHAR2) IS
6130: SELECT ITEM_KEY FROM wf_notifications WHERE ITEM_KEY LIKE Concat(chld_item_key,'\_%') ESCAPE '\'

Line 6425: l_contract_number OKC_REP_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE;

6421: l_doc_sequence_id NUMBER;
6422: l_profile_doc_seq VARCHAR2(1);
6423: l_result NUMBER;
6424: l_row_notfound BOOLEAN := FALSE;
6425: l_contract_number OKC_REP_CONTRACTS_ALL.CONTRACT_NUMBER%TYPE;
6426:
6427:
6428: CURSOR l_get_sob_csr IS
6429: SELECT OI2.ORG_INFORMATION3 SET_OF_BOOKS_ID

Line 6442: FROM OKC_REP_CONTRACTS_ALL

6438: OI1.ORGANIZATION_ID = p_org_id;
6439:
6440: CURSOR l_ensure_unique_csr (p_contract_number IN VARCHAR2) IS
6441: SELECT CONTRACT_NUMBER
6442: FROM OKC_REP_CONTRACTS_ALL
6443: WHERE CONTRACT_NUMBER = p_contract_number
6444: AND ROWNUM < 2;
6445:
6446: BEGIN

Line 6709: from okc_rep_contracts_all

6705: -- Initialize API return status to success
6706: x_return_status := FND_API.G_RET_STS_SUCCESS;
6707:
6708: select contract_version_num into l_con_version
6709: from okc_rep_contracts_all
6710: where CONTRACT_ID = p_contract_id ;
6711:
6712: -- Delete the records. The records are locked in the delete_contract API.
6713: DELETE FROM OKC_REP_CONTRACTS_ALL_EXT_B

Line 6713: DELETE FROM OKC_REP_CONTRACTS_ALL_EXT_B

6709: from okc_rep_contracts_all
6710: where CONTRACT_ID = p_contract_id ;
6711:
6712: -- Delete the records. The records are locked in the delete_contract API.
6713: DELETE FROM OKC_REP_CONTRACTS_ALL_EXT_B
6714: WHERE CONTRACT_ID = p_contract_id
6715: AND contract_version_num = l_con_version;
6716:
6717: DELETE FROM OKC_REP_CONTRACTS_ALL_EXT_TL

Line 6717: DELETE FROM OKC_REP_CONTRACTS_ALL_EXT_TL

6713: DELETE FROM OKC_REP_CONTRACTS_ALL_EXT_B
6714: WHERE CONTRACT_ID = p_contract_id
6715: AND contract_version_num = l_con_version;
6716:
6717: DELETE FROM OKC_REP_CONTRACTS_ALL_EXT_TL
6718: WHERE CONTRACT_ID = p_contract_id
6719: AND contract_version_num = l_con_version;
6720: /*
6721: -- Insert the previous version record.

Line 6722: INSERT INTO OKC_REP_CONTRACTS_ALL_EXT_B(extension_id,

6718: WHERE CONTRACT_ID = p_contract_id
6719: AND contract_version_num = l_con_version;
6720: /*
6721: -- Insert the previous version record.
6722: INSERT INTO OKC_REP_CONTRACTS_ALL_EXT_B(extension_id,
6723: ATTR_GROUP_ID,
6724: contract_id,
6725:
6726: DATA_LEVEL_ID,

Line 6940: INSERT INTO OKC_REP_CONTRACTS_ALL_EXT_TL(EXTENSION_ID

6936: WHERE contract_id = p_contract_id
6937: AND contract_version_num = l_con_version - 1 ;
6938:
6939:
6940: INSERT INTO OKC_REP_CONTRACTS_ALL_EXT_TL(EXTENSION_ID
6941: ,ATTR_GROUP_ID
6942: ,CONTRACT_ID
6943:
6944: ,DATA_LEVEL_ID

Line 7172: FROM okc_rep_contracts_all

7168: l_contract_type VARCHAR2(30);
7169:
7170: CURSOR c_get_contract_vers_num(p_contract_id NUMBER) IS
7171: SELECT contract_type, contract_version_num
7172: FROM okc_rep_contracts_all
7173: WHERE contract_id = p_contract_id;
7174:
7175: BEGIN
7176:

Line 7408: SELECT extension_id FROM okc_rep_contracts_all_ext_b

7404: l_index NUMBER;
7405: l_extension_id_vers NUMBER;
7406:
7407: CURSOR c_get_uda_attr_for_con IS
7408: SELECT extension_id FROM okc_rep_contracts_all_ext_b
7409: WHERE contract_id = p_contract_id;
7410:
7411:
7412: BEGIN

Line 7437: --insert data from okc_rep_contracts_all_ext_b table to okc_rep_contract_vers_ext_b

7433: -- Initialize API return status to success
7434: x_return_status := FND_API.G_RET_STS_SUCCESS;
7435:
7436: --No API's in EGO to copy data from one object to another.
7437: --insert data from okc_rep_contracts_all_ext_b table to okc_rep_contract_vers_ext_b
7438:
7439: FOR c_get_uda_attr_for_con_rec IN c_get_uda_attr_for_con LOOP
7440: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_extension_id_vers FROM dual;
7441:

Line 7442: INSERT INTO okc_rep_contracts_all_ext_b(EXTENSION_ID,

7438:
7439: FOR c_get_uda_attr_for_con_rec IN c_get_uda_attr_for_con LOOP
7440: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_extension_id_vers FROM dual;
7441:
7442: INSERT INTO okc_rep_contracts_all_ext_b(EXTENSION_ID,
7443: ATTR_GROUP_ID,
7444: CONTRACT_TYPE,
7445: CONTRACT_ID,
7446: CONTRACT_VERSION_NUM,

Line 7656: FROM okc_rep_contracts_all_ext_b

7652: D_EXT_ATTR7,
7653: D_EXT_ATTR8,
7654: D_EXT_ATTR9,
7655: D_EXT_ATTR10
7656: FROM okc_rep_contracts_all_ext_b
7657: WHERE contract_id = p_contract_id
7658: AND extension_id = c_get_uda_attr_for_con_rec.extension_id;
7659:
7660: --insert data from okc_rep_contracts_all_ext_tl table to okc_rep_contract_vers_ext_tl

Line 7660: --insert data from okc_rep_contracts_all_ext_tl table to okc_rep_contract_vers_ext_tl

7656: FROM okc_rep_contracts_all_ext_b
7657: WHERE contract_id = p_contract_id
7658: AND extension_id = c_get_uda_attr_for_con_rec.extension_id;
7659:
7660: --insert data from okc_rep_contracts_all_ext_tl table to okc_rep_contract_vers_ext_tl
7661: INSERT INTO okc_rep_contracts_all_ext_tl(EXTENSION_ID
7662: ,ATTR_GROUP_ID
7663: ,CONTRACT_TYPE
7664: ,CONTRACT_ID

Line 7661: INSERT INTO okc_rep_contracts_all_ext_tl(EXTENSION_ID

7657: WHERE contract_id = p_contract_id
7658: AND extension_id = c_get_uda_attr_for_con_rec.extension_id;
7659:
7660: --insert data from okc_rep_contracts_all_ext_tl table to okc_rep_contract_vers_ext_tl
7661: INSERT INTO okc_rep_contracts_all_ext_tl(EXTENSION_ID
7662: ,ATTR_GROUP_ID
7663: ,CONTRACT_TYPE
7664: ,CONTRACT_ID
7665: ,CONTRACT_VERSION_NUM

Line 7769: FROM okc_rep_contracts_all_ext_tl

7765: ,TL_EXT_ATTR37
7766: ,TL_EXT_ATTR38
7767: ,TL_EXT_ATTR39
7768: ,TL_EXT_ATTR40
7769: FROM okc_rep_contracts_all_ext_tl
7770: WHERE contract_id = p_contract_id
7771: AND extension_id = c_get_uda_attr_for_con_rec.extension_id;
7772:
7773: END LOOP;