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_WF_PVT dependencies on OKC_REP_CONTRACTS_ALL

Line 103: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

99: funcmode IN varchar2,
100: resultout OUT nocopy varchar2
101: ) IS
102:
103: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
104: l_api_name VARCHAR2(30);
105:
106: CURSOR contract_csr(l_contract_id NUMBER) IS
107: SELECT contract_type, contract_number, contract_name, contract_version_num

Line 108: FROM okc_rep_contracts_all

104: l_api_name VARCHAR2(30);
105:
106: CURSOR contract_csr(l_contract_id NUMBER) IS
107: SELECT contract_type, contract_number, contract_name, contract_version_num
108: FROM okc_rep_contracts_all
109: WHERE contract_id = l_contract_id;
110:
111: contract_rec contract_csr%ROWTYPE;
112:

Line 281: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

277: funcmode IN varchar2,
278: resultout OUT nocopy varchar2
279: ) IS
280: l_api_name VARCHAR2(30);
281: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
282: l_process_complete_yn varchar2(1);
283: l_next_approvers ame_util.approversTable2;
284: l_item_indexes ame_util.idList;
285: l_item_classes ame_util.stringList;

Line 481: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

477: funcmode IN varchar2,
478: resultout OUT nocopy varchar2
479: ) IS
480: l_api_name varchar2(30);
481: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
482: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
483: l_requester varchar2(4000);
484: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
485: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

Line 482: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;

478: resultout OUT nocopy varchar2
479: ) IS
480: l_api_name varchar2(30);
481: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
482: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
483: l_requester varchar2(4000);
484: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
485: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
486: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;

Line 484: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;

480: l_api_name varchar2(30);
481: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
482: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
483: l_requester varchar2(4000);
484: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
485: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
486: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
487: l_contract_attachments varchar2(4000);
488: l_process_complete_yn varchar2(1);

Line 485: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

481: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
482: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
483: l_requester varchar2(4000);
484: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
485: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
486: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
487: l_contract_attachments varchar2(4000);
488: l_process_complete_yn varchar2(1);
489: l_next_approvers ame_util.approversTable2;

Line 486: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;

482: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
483: l_requester varchar2(4000);
484: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
485: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
486: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
487: l_contract_attachments varchar2(4000);
488: l_process_complete_yn varchar2(1);
489: l_next_approvers ame_util.approversTable2;
490: l_item_indexes ame_util.idList;

Line 1804: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

1800: funcmode IN varchar2,
1801: resultout OUT nocopy varchar2
1802: ) IS
1803:
1804: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1805: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
1806: l_api_name VARCHAR2(30);
1807: l_return_status VARCHAR2(1);
1808: l_msg_count NUMBER;

Line 1805: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

1801: resultout OUT nocopy varchar2
1802: ) IS
1803:
1804: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1805: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
1806: l_api_name VARCHAR2(30);
1807: l_return_status VARCHAR2(1);
1808: l_msg_count NUMBER;
1809: l_msg_data VARCHAR2(2000);

Line 1816: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;

1812: l_update_event_tbl EVENT_TBL_TYPE;
1813: l_sync_flag VARCHAR2(1);
1814: l_expiration_date_matches_flag VARCHAR2(1);
1815: l_effective_date_matches_flag VARCHAR2(1);
1816: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
1817: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
1818:
1819:
1820:

Line 1817: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;

1813: l_sync_flag VARCHAR2(1);
1814: l_expiration_date_matches_flag VARCHAR2(1);
1815: l_effective_date_matches_flag VARCHAR2(1);
1816: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
1817: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
1818:
1819:
1820:
1821: CURSOR contract_csr(p_contract_id NUMBER) IS

Line 1823: FROM OKC_REP_CONTRACTS_ALL

1819:
1820:
1821: CURSOR contract_csr(p_contract_id NUMBER) IS
1822: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date,esignature_required
1823: FROM OKC_REP_CONTRACTS_ALL
1824: WHERE contract_id = p_contract_id;
1825:
1826: CURSOR arch_contract_csr (l_contract_version NUMBER,p_contract_id number) IS
1827: SELECT contract_effective_date, contract_expiration_date

Line 2094: UPDATE okc_rep_contracts_all

2090: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2091: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2092: 'Updating latest_signed_ver_number column');
2093: END IF;
2094: UPDATE okc_rep_contracts_all
2095: SET latest_signed_ver_number = contract_rec.contract_version_num
2096: WHERE contract_id = l_contract_id;
2097: CLOSE contract_csr;
2098:

Line 2155: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

2151: funcmode IN varchar2,
2152: resultout OUT nocopy varchar2
2153: ) IS
2154:
2155: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2156: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
2157: l_api_name VARCHAR2(30);
2158: l_return_status VARCHAR2(1);
2159: l_msg_count NUMBER;

Line 2156: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

2152: resultout OUT nocopy varchar2
2153: ) IS
2154:
2155: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2156: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
2157: l_api_name VARCHAR2(30);
2158: l_return_status VARCHAR2(1);
2159: l_msg_count NUMBER;
2160: l_msg_data VARCHAR2(2000);

Line 2275: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

2271: funcmode in varchar2,
2272: resultout out nocopy varchar2) IS
2273:
2274: l_api_name VARCHAR2(30);
2275: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2276: l_process_complete_yn varchar2(1);
2277: l_next_approvers ame_util.approversTable2;
2278: l_item_indexes ame_util.idList;
2279: l_item_classes ame_util.stringList;

Line 2425: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

2421: funcmode in varchar2,
2422: resultout out nocopy varchar2) IS
2423:
2424: l_api_name VARCHAR2(30);
2425: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2426: l_process_complete_yn varchar2(1);
2427: l_next_approvers ame_util.approversTable2;
2428: l_item_indexes ame_util.idList;
2429: l_item_classes ame_util.stringList;

Line 2620: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

2616: funcmode IN varchar2,
2617: resultout OUT nocopy varchar2
2618: ) IS
2619:
2620: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2621: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
2622: l_api_name VARCHAR2(30);
2623: l_return_status VARCHAR2(1);
2624: l_msg_count NUMBER;

Line 2621: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

2617: resultout OUT nocopy varchar2
2618: ) IS
2619:
2620: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2621: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
2622: l_api_name VARCHAR2(30);
2623: l_return_status VARCHAR2(1);
2624: l_msg_count NUMBER;
2625: l_msg_data VARCHAR2(2000);

Line 2714: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

2710: funcmode IN varchar2,
2711: resultout OUT nocopy varchar2
2712: ) IS
2713:
2714: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2715: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2716: l_api_name VARCHAR2(30);
2717: l_return_status VARCHAR2(1);
2718: l_msg_count NUMBER;

Line 2715: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;

2711: resultout OUT nocopy varchar2
2712: ) IS
2713:
2714: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2715: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2716: l_api_name VARCHAR2(30);
2717: l_return_status VARCHAR2(1);
2718: l_msg_count NUMBER;
2719: l_msg_data VARCHAR2(2000);

Line 2805: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

2801: funcmode IN varchar2,
2802: resultout OUT nocopy varchar2
2803: ) IS
2804:
2805: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2806: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2807: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2808: l_api_name VARCHAR2(30);
2809: l_return_status VARCHAR2(1);

Line 2806: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;

2802: resultout OUT nocopy varchar2
2803: ) IS
2804:
2805: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2806: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2807: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2808: l_api_name VARCHAR2(30);
2809: l_return_status VARCHAR2(1);
2810: l_msg_count NUMBER;

Line 2971: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

2967: funcmode IN varchar2,
2968: resultout OUT nocopy varchar2
2969: ) IS
2970:
2971: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2972: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2973: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2974: l_api_name VARCHAR2(30);
2975: l_return_status VARCHAR2(1);

Line 2972: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;

2968: resultout OUT nocopy varchar2
2969: ) IS
2970:
2971: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2972: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2973: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2974: l_api_name VARCHAR2(30);
2975: l_return_status VARCHAR2(1);
2976: l_msg_count NUMBER;

Line 3055: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

3051: funcmode IN varchar2,
3052: resultout OUT nocopy varchar2
3053: ) IS
3054:
3055: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
3056: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
3057: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
3058: l_api_name VARCHAR2(30);
3059: l_return_status VARCHAR2(1);

Line 3056: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;

3052: resultout OUT nocopy varchar2
3053: ) IS
3054:
3055: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
3056: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
3057: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
3058: l_api_name VARCHAR2(30);
3059: l_return_status VARCHAR2(1);
3060: l_msg_count NUMBER;

Line 3188: FROM okc_rep_contracts_all

3184: ,resp_appl_id => l_resp_appl_id
3185: );
3186:
3187: SELECT org_id INTO l_org_id
3188: FROM okc_rep_contracts_all
3189: WHERE contract_id = l_contract_id;
3190:
3191: -- MO init
3192: mo_global.init('OKC');