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

82: funcmode IN varchar2,
83: resultout OUT nocopy varchar2
84: ) IS
85:
86: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
87: l_api_name VARCHAR2(30);
88:
89: CURSOR contract_csr(l_contract_id NUMBER) IS
90: SELECT contract_type, contract_number, contract_name, contract_version_num

Line 91: FROM okc_rep_contracts_all

87: l_api_name VARCHAR2(30);
88:
89: CURSOR contract_csr(l_contract_id NUMBER) IS
90: SELECT contract_type, contract_number, contract_name, contract_version_num
91: FROM okc_rep_contracts_all
92: WHERE contract_id = l_contract_id;
93:
94: contract_rec contract_csr%ROWTYPE;
95:

Line 263: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

259: funcmode IN varchar2,
260: resultout OUT nocopy varchar2
261: ) IS
262: l_api_name VARCHAR2(30);
263: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
264: l_process_complete_yn varchar2(1);
265: l_next_approvers ame_util.approversTable2;
266: l_item_indexes ame_util.idList;
267: l_item_classes ame_util.stringList;

Line 463: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

459: funcmode IN varchar2,
460: resultout OUT nocopy varchar2
461: ) IS
462: l_api_name varchar2(30);
463: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
464: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
465: l_requester varchar2(4000);
466: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
467: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

Line 464: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;

460: resultout OUT nocopy varchar2
461: ) IS
462: l_api_name varchar2(30);
463: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
464: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
465: l_requester varchar2(4000);
466: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
467: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
468: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;

Line 466: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;

462: l_api_name varchar2(30);
463: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
464: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
465: l_requester varchar2(4000);
466: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
467: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
468: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
469: l_contract_attachments varchar2(4000);
470: l_process_complete_yn varchar2(1);

Line 467: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

463: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
464: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
465: l_requester varchar2(4000);
466: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
467: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
468: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
469: l_contract_attachments varchar2(4000);
470: l_process_complete_yn varchar2(1);
471: l_next_approvers ame_util.approversTable2;

Line 468: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;

464: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;
465: l_requester varchar2(4000);
466: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%type;
467: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
468: l_contract_name OKC_REP_CONTRACTS_ALL.contract_name%type;
469: l_contract_attachments varchar2(4000);
470: l_process_complete_yn varchar2(1);
471: l_next_approvers ame_util.approversTable2;
472: l_item_indexes ame_util.idList;

Line 1430: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

1426: funcmode IN varchar2,
1427: resultout OUT nocopy varchar2
1428: ) IS
1429:
1430: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1431: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
1432: l_api_name VARCHAR2(30);
1433: l_return_status VARCHAR2(1);
1434: l_msg_count NUMBER;

Line 1431: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

1427: resultout OUT nocopy varchar2
1428: ) IS
1429:
1430: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1431: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
1432: l_api_name VARCHAR2(30);
1433: l_return_status VARCHAR2(1);
1434: l_msg_count NUMBER;
1435: l_msg_data VARCHAR2(2000);

Line 1551: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

1547: funcmode IN varchar2,
1548: resultout OUT nocopy varchar2
1549: ) IS
1550:
1551: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1552: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
1553: l_api_name VARCHAR2(30);
1554: l_return_status VARCHAR2(1);
1555: l_msg_count NUMBER;

Line 1552: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

1548: resultout OUT nocopy varchar2
1549: ) IS
1550:
1551: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1552: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
1553: l_api_name VARCHAR2(30);
1554: l_return_status VARCHAR2(1);
1555: l_msg_count NUMBER;
1556: l_msg_data VARCHAR2(2000);

Line 1671: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

1667: funcmode in varchar2,
1668: resultout out nocopy varchar2) IS
1669:
1670: l_api_name VARCHAR2(30);
1671: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1672: l_process_complete_yn varchar2(1);
1673: l_next_approvers ame_util.approversTable2;
1674: l_item_indexes ame_util.idList;
1675: l_item_classes ame_util.stringList;

Line 1821: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

1817: funcmode in varchar2,
1818: resultout out nocopy varchar2) IS
1819:
1820: l_api_name VARCHAR2(30);
1821: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
1822: l_process_complete_yn varchar2(1);
1823: l_next_approvers ame_util.approversTable2;
1824: l_item_indexes ame_util.idList;
1825: l_item_classes ame_util.stringList;

Line 1999: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

1995: funcmode IN varchar2,
1996: resultout OUT nocopy varchar2
1997: ) IS
1998:
1999: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2000: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
2001: l_api_name VARCHAR2(30);
2002: l_return_status VARCHAR2(1);
2003: l_msg_count NUMBER;

Line 2000: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;

1996: resultout OUT nocopy varchar2
1997: ) IS
1998:
1999: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2000: l_contract_version OKC_REP_CONTRACTS_ALL.contract_version_num%type;
2001: l_api_name VARCHAR2(30);
2002: l_return_status VARCHAR2(1);
2003: l_msg_count NUMBER;
2004: l_msg_data VARCHAR2(2000);

Line 2093: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

2089: funcmode IN varchar2,
2090: resultout OUT nocopy varchar2
2091: ) IS
2092:
2093: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2094: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2095: l_api_name VARCHAR2(30);
2096: l_return_status VARCHAR2(1);
2097: l_msg_count NUMBER;

Line 2094: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;

2090: resultout OUT nocopy varchar2
2091: ) IS
2092:
2093: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2094: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2095: l_api_name VARCHAR2(30);
2096: l_return_status VARCHAR2(1);
2097: l_msg_count NUMBER;
2098: l_msg_data VARCHAR2(2000);

Line 2184: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;

2180: funcmode IN varchar2,
2181: resultout OUT nocopy varchar2
2182: ) IS
2183:
2184: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2185: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2186: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2187: l_api_name VARCHAR2(30);
2188: l_return_status VARCHAR2(1);

Line 2185: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;

2181: resultout OUT nocopy varchar2
2182: ) IS
2183:
2184: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
2185: l_contract_type OKC_REP_CONTRACTS_ALL.contract_type%TYPE;
2186: l_con_req_id OKC_CONTRACT_DOCS.request_id%TYPE;
2187: l_api_name VARCHAR2(30);
2188: l_return_status VARCHAR2(1);
2189: l_msg_count NUMBER;