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_SIGN_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 309: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

305: CURSOR get_owner is
306: SELECT owner_role from wf_items wf WHERE wf.item_type=itemtype AND wf.item_key=itemkey;
307:
308: l_api_name varchar2(30);
309: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
310: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
311: l_requester varchar2(4000);
312: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
313: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

Line 310: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;

306: SELECT owner_role from wf_items wf WHERE wf.item_type=itemtype AND wf.item_key=itemkey;
307:
308: l_api_name varchar2(30);
309: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
310: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
311: l_requester varchar2(4000);
312: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
313: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
314: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;

Line 312: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;

308: l_api_name varchar2(30);
309: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
310: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
311: l_requester varchar2(4000);
312: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
313: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
314: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
315: l_contract_attachments varchar2(4000);
316: l_process_complete_yn varchar2(1);

Line 313: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

309: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
310: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
311: l_requester varchar2(4000);
312: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
313: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
314: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
315: l_contract_attachments varchar2(4000);
316: l_process_complete_yn varchar2(1);
317: l_user_name varchar2(4000);

Line 314: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;

310: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
311: l_requester varchar2(4000);
312: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
313: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
314: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
315: l_contract_attachments varchar2(4000);
316: l_process_complete_yn varchar2(1);
317: l_user_name varchar2(4000);
318: l_role_name varchar2(4000);

Line 337: (SELECT 1 FROM okc_rep_signature_details orsd, okc_rep_contracts_all orca

333: SELECT Min(SIGNATURE_SEQUENCE)
334: FROM okc_rep_party_contacts opc
335: WHERE opc.contract_id=p_contract_id
336: AND NOT EXISTS
337: (SELECT 1 FROM okc_rep_signature_details orsd, okc_rep_contracts_all orca
338: WHERE orsd.contract_id=opc.contract_id AND sequence_level=opc.SIGNATURE_SEQUENCE
339: AND orca.contract_id = orsd.contract_id
340: AND orca.contract_version_num = orsd.contract_version_num);
341:

Line 384: OKC_REP_CONTRACTS_ALL okr ,

380: p.person_id=p_contact_id;
381:
382: CURSOR cur_contract_admin IS
383: SELECT f.user_name FROM
384: OKC_REP_CONTRACTS_ALL okr ,
385: fnd_user f
386: WHERE okr.contract_id=p_contract_id
387: AND okr.owner_id=f.user_id;
388:

Line 951: FROM OKC_REP_CONTRACTS_ALL

947: l_cnt_prc NUMBER;
948:
949: CURSOR c_get_contract_details_csr (p_contract_id NUMBER) IS
950: SELECT CONTRACT_TYPE, org_id
951: FROM OKC_REP_CONTRACTS_ALL
952: WHERE contract_id = p_contract_id;
953:
954: BEGIN
955:

Line 1021: SELECT contract_id INTO l_exist_id FROM okc_rep_contracts_all orca

1017:
1018: IF (l_control_number IS NOT NULL) THEN
1019:
1020: BEGIN
1021: SELECT contract_id INTO l_exist_id FROM okc_rep_contracts_all orca
1022: WHERE orca.contract_type = l_contract_type
1023: AND org_id = l_org_id
1024: AND contract_number = l_control_number
1025: AND contract_id <> l_contract_id;

Line 1031: UPDATE okc_rep_contracts_all SET contract_number = l_control_number

1027: l_control_number := NULL;
1028:
1029: EXCEPTION
1030: WHEN No_Data_Found THEN
1031: UPDATE okc_rep_contracts_all SET contract_number = l_control_number
1032: WHERE contract_id = l_contract_id
1033: AND contract_version_num = 1;
1034:
1035: END;

Line 1362: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

1358: funcmode IN varchar2,
1359: resultout OUT nocopy varchar2
1360: ) IS
1361:
1362: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1363: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
1364: l_api_name VARCHAR2(30);
1365: l_return_status VARCHAR2(1);
1366: l_msg_count NUMBER;

Line 1363: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

1359: resultout OUT nocopy varchar2
1360: ) IS
1361:
1362: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1363: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
1364: l_api_name VARCHAR2(30);
1365: l_return_status VARCHAR2(1);
1366: l_msg_count NUMBER;
1367: l_msg_data VARCHAR2(2000);

Line 1373: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;

1369: l_update_event_tbl EVENT_TBL_TYPE;
1370: l_sync_flag VARCHAR2(1);
1371: l_expiration_date_matches_flag VARCHAR2(1);
1372: l_effective_date_matches_flag VARCHAR2(1);
1373: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
1374: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
1375:
1376:
1377:

Line 1374: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;

1370: l_sync_flag VARCHAR2(1);
1371: l_expiration_date_matches_flag VARCHAR2(1);
1372: l_effective_date_matches_flag VARCHAR2(1);
1373: l_prev_signed_expiration_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
1374: l_prev_signed_effective_date OKC_REP_CONTRACTS_ALL.CONTRACT_EXPIRATION_DATE%TYPE;
1375:
1376:
1377:
1378: CURSOR contract_csr(p_contract_id NUMBER) IS

Line 1380: FROM OKC_REP_CONTRACTS_ALL

1376:
1377:
1378: CURSOR contract_csr(p_contract_id NUMBER) IS
1379: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date
1380: FROM OKC_REP_CONTRACTS_ALL
1381: WHERE contract_id = p_contract_id;
1382:
1383: CURSOR arch_contract_csr (l_contract_version NUMBER,p_contract_id number) IS
1384: SELECT contract_effective_date, contract_expiration_date

Line 1648: UPDATE okc_rep_contracts_all

1644: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1645: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1646: 'Updating latest_signed_ver_number column');
1647: END IF;
1648: UPDATE okc_rep_contracts_all
1649: SET latest_signed_ver_number = contract_rec.contract_version_num
1650: WHERE contract_id = l_contract_id;
1651: CLOSE contract_csr;
1652:

Line 1706: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

1702: funcmode IN varchar2,
1703: resultout OUT nocopy varchar2
1704: ) IS
1705:
1706: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1707: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
1708: l_api_name VARCHAR2(30);
1709: l_return_status VARCHAR2(1);
1710: l_msg_count NUMBER;

Line 1707: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

1703: resultout OUT nocopy varchar2
1704: ) IS
1705:
1706: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1707: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
1708: l_api_name VARCHAR2(30);
1709: l_return_status VARCHAR2(1);
1710: l_msg_count NUMBER;
1711: l_msg_data VARCHAR2(2000);

Line 1827: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

1823: funcmode IN varchar2,
1824: resultout OUT nocopy varchar2
1825: ) IS
1826:
1827: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1828: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
1829: l_api_name VARCHAR2(30);
1830: l_return_status VARCHAR2(1);
1831: l_msg_count NUMBER;

Line 1828: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;

1824: resultout OUT nocopy varchar2
1825: ) IS
1826:
1827: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1828: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
1829: l_api_name VARCHAR2(30);
1830: l_return_status VARCHAR2(1);
1831: l_msg_count NUMBER;
1832: l_msg_data VARCHAR2(2000);

Line 1919: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

1915: funcmode IN varchar2,
1916: resultout OUT nocopy varchar2
1917: ) IS
1918:
1919: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1920: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
1921: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
1922: l_api_name VARCHAR2(30);
1923: l_return_status VARCHAR2(1);

Line 1920: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;

1916: resultout OUT nocopy varchar2
1917: ) IS
1918:
1919: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1920: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
1921: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
1922: l_api_name VARCHAR2(30);
1923: l_return_status VARCHAR2(1);
1924: l_msg_count NUMBER;

Line 2018: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

2014: funcmode IN varchar2,
2015: resultout OUT nocopy varchar2
2016: ) IS
2017:
2018: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2019: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2020: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2021: l_api_name VARCHAR2(30);
2022: l_return_status VARCHAR2(1);

Line 2019: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;

2015: resultout OUT nocopy varchar2
2016: ) IS
2017:
2018: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2019: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2020: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2021: l_api_name VARCHAR2(30);
2022: l_return_status VARCHAR2(1);
2023: l_msg_count NUMBER;

Line 2151: FROM okc_rep_contracts_all

2147: ,resp_appl_id => l_resp_appl_id
2148: );
2149:
2150: SELECT org_id INTO l_org_id
2151: FROM okc_rep_contracts_all
2152: WHERE contract_id = l_contract_id;
2153:
2154: -- MO init
2155: mo_global.init('OKC');