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_IMP_PVT dependencies on OKC_IMP_RECORD_TYPES

Line 8: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

4: /*
5: Updates the okc_contract_usages table with the relationships provided
6: */
7: PROCEDURE Update_contract_usages(p_api_version IN NUMBER,
8: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
9: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
10: p_commit IN VARCHAR2 := fnd_api.g_false,
11: x_msg_data OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,

Line 9: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

5: Updates the okc_contract_usages table with the relationships provided
6: */
7: PROCEDURE Update_contract_usages(p_api_version IN NUMBER,
8: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
9: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
10: p_commit IN VARCHAR2 := fnd_api.g_false,
11: x_msg_data OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_return_status OUT NOCOPY VARCHAR2

Line 98: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

94: /*
95: Updates the okc_contract_usages table with the relationships provided
96: */
97: PROCEDURE delete_contract_usages(p_api_version IN NUMBER,
98: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
99: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
100: p_commit IN VARCHAR2 := fnd_api.g_false,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,

Line 99: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

95: Updates the okc_contract_usages table with the relationships provided
96: */
97: PROCEDURE delete_contract_usages(p_api_version IN NUMBER,
98: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
99: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
100: p_commit IN VARCHAR2 := fnd_api.g_false,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_return_status OUT NOCOPY VARCHAR2

Line 162: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

158: END delete_contract_usages;
159:
160:
161: Procedure create_contract(p_api_version IN NUMBER,
162: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
163: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
164: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
165: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
166: p_create_contract IN VARCHAR2 := fnd_api.g_true,

Line 163: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

159:
160:
161: Procedure create_contract(p_api_version IN NUMBER,
162: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
163: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
164: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
165: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
166: p_create_contract IN VARCHAR2 := fnd_api.g_true,
167: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 164: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

160:
161: Procedure create_contract(p_api_version IN NUMBER,
162: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
163: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
164: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
165: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
166: p_create_contract IN VARCHAR2 := fnd_api.g_true,
167: p_commit IN VARCHAR2 := fnd_api.g_false,
168: x_msg_data OUT NOCOPY VARCHAR2,

Line 165: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

161: Procedure create_contract(p_api_version IN NUMBER,
162: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
163: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
164: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
165: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
166: p_create_contract IN VARCHAR2 := fnd_api.g_true,
167: p_commit IN VARCHAR2 := fnd_api.g_false,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,

Line 281: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

277:
278: END create_contract;
279:
280: Procedure populate_contract_hdr(p_api_version IN NUMBER,
281: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
282: p_run_id IN NUMBER ,
283: x_imp_contract_id OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,

Line 422: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

418: END populate_contract_hdr;
419:
420: PROCEDURE populate_contract_parties (p_api_version IN NUMBER,
421: p_run_id IN NUMBER ,
422: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
423: p_imp_contract_id IN NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
425: x_msg_count OUT NOCOPY NUMBER,
426: x_return_status OUT NOCOPY VARCHAR2)

Line 480: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

476: END populate_contract_parties;
477:
478: PROCEDURE populate_party_contacts(p_api_version IN NUMBER,
479: p_run_id IN NUMBER,
480: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
481: p_imp_contract_id IN NUMBER,
482: x_msg_data OUT NOCOPY VARCHAR2,
483: x_msg_count OUT NOCOPY NUMBER,
484: x_return_status OUT NOCOPY VARCHAR2)

Line 559: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

555: END populate_party_contacts;
556:
557: PROCEDURE populate_contract_risks(p_api_version IN NUMBER,
558: p_run_id IN NUMBER DEFAULT NULL,
559: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
560: p_imp_contract_id IN NUMBER,
561: x_msg_data OUT NOCOPY VARCHAR2,
562: x_msg_count OUT NOCOPY NUMBER,
563: x_return_status OUT NOCOPY VARCHAR2)

Line 946: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

942: /*
943:
944: PROCEDURE delete_contract_risks(p_api_version IN NUMBER,
945: p_run_id IN NUMBER DEFAULT NULL,
946: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
947: p_imp_contract_id IN NUMBER,
948: x_msg_data OUT NOCOPY VARCHAR2,
949: x_msg_count OUT NOCOPY NUMBER,
950: x_return_status OUT NOCOPY VARCHAR2)

Line 1114: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

1110:
1111:
1112: PROCEDURE delete_party_contacts(p_api_version IN NUMBER,
1113: p_run_id IN NUMBER,
1114: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1115: p_imp_contract_id IN NUMBER,
1116: x_msg_data OUT NOCOPY VARCHAR2,
1117: x_msg_count OUT NOCOPY NUMBER,
1118: x_return_status OUT NOCOPY VARCHAR2)

Line 1155: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

1151: END delete_party_contacts;
1152: */
1153:
1154: Procedure create_contract(p_api_version IN NUMBER,
1155: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1156: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1157: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1158: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1159: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

Line 1156: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

1152: */
1153:
1154: Procedure create_contract(p_api_version IN NUMBER,
1155: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1156: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1157: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1158: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1159: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
1160: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 1157: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

1153:
1154: Procedure create_contract(p_api_version IN NUMBER,
1155: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1156: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1157: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1158: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1159: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
1160: p_commit IN VARCHAR2 := fnd_api.g_false,
1161: x_msg_data OUT NOCOPY VARCHAR2,

Line 1158: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

1154: Procedure create_contract(p_api_version IN NUMBER,
1155: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1156: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1157: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1158: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1159: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
1160: p_commit IN VARCHAR2 := fnd_api.g_false,
1161: x_msg_data OUT NOCOPY VARCHAR2,
1162: x_msg_count OUT NOCOPY NUMBER,

Line 1159: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

1155: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1156: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1157: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1158: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1159: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
1160: p_commit IN VARCHAR2 := fnd_api.g_false,
1161: x_msg_data OUT NOCOPY VARCHAR2,
1162: x_msg_count OUT NOCOPY NUMBER,
1163: x_return_status OUT NOCOPY VARCHAR2

Line 1242: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

1238: */
1239:
1240: Procedure delete_contract(p_api_version IN NUMBER,
1241: p_commit IN VARCHAR2 := fnd_api.g_false,
1242: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1243: p_contract_type IN VARCHAR2 DEFAULT NULL,
1244: p_contract_id IN NUMBER DEFAULT NULL,
1245: x_msg_data OUT NOCOPY VARCHAR2,
1246: x_msg_count OUT NOCOPY NUMBER,

Line 1257: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;

1253:
1254: l_query VARCHAR2(4000);
1255: l_where_clause VARCHAR2(4000);
1256:
1257: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
1258: l_contract_id NUMBER;
1259:
1260: TYPE contract_id_cur IS REF CURSOR;
1261: c_contract_id_cur contract_id_cur;

Line 1635: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

1631: The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
1632: */
1633:
1634: Procedure create_new_contract_version(p_api_version IN NUMBER,
1635: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1636: p_contract_type IN VARCHAR2 DEFAULT NULL,
1637: p_contract_id IN NUMBER DEFAULT NULL,
1638: p_run_id IN NUMBER,
1639: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 1655: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;

1651: l_query VARCHAR2(4000);
1652: l_where_clause VARCHAR2(4000);
1653:
1654: l_contract_id NUMBER;
1655: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
1656:
1657: TYPE contract_id_cur IS REF CURSOR;
1658: c_contract_id_cur contract_id_cur;
1659:

Line 1782: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

1778: END create_new_contract_version;
1779:
1780: /*Scenario where only one contract will be associated for this business Document*/
1781: PROCEDURE check_contract_exists(p_api_version IN NUMBER,
1782: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1783: x_contract_type IN OUT NOCOPY VARCHAR2,
1784: x_contract_id IN OUT NOCOPY NUMBER ,
1785: x_contract_version_num IN OUT NOCOPY NUMBER ,
1786: x_msg_data OUT NOCOPY VARCHAR2,

Line 1843: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

1839:
1840: END check_contract_exists;
1841:
1842: PROCEDURE Activate_tasks_closeout(p_api_version IN NUMBER,
1843: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1844: p_physical_completion_date IN DATE ,
1845: p_init_msg_list IN VARCHAR2,
1846: p_commit IN VARCHAR2,
1847: x_msg_data OUT NOCOPY VARCHAR2,

Line 2246: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

2242: END Activate_tasks_closeout;
2243:
2244: /*Scenario where only one contract will be associated for this business Document*/
2245: PROCEDURE check_contract_exists(p_api_version IN NUMBER,
2246: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2247: x_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
2248: x_msg_data OUT NOCOPY VARCHAR2,
2249: x_msg_count OUT NOCOPY NUMBER,
2250: x_return_status OUT NOCOPY VARCHAR2

Line 2247: x_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

2243:
2244: /*Scenario where only one contract will be associated for this business Document*/
2245: PROCEDURE check_contract_exists(p_api_version IN NUMBER,
2246: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2247: x_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
2248: x_msg_data OUT NOCOPY VARCHAR2,
2249: x_msg_count OUT NOCOPY NUMBER,
2250: x_return_status OUT NOCOPY VARCHAR2
2251: )

Line 2314: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

2310: */
2311:
2312: Procedure delete_cancel_contract(p_api_version IN NUMBER,
2313: p_commit IN VARCHAR2 := fnd_api.g_false,
2314: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2315: p_contract_type IN VARCHAR2 DEFAULT NULL,
2316: p_contract_id IN NUMBER DEFAULT NULL,
2317: x_msg_data OUT NOCOPY VARCHAR2,
2318: x_msg_count OUT NOCOPY NUMBER,

Line 2330: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;

2326:
2327: l_query VARCHAR2(4000);
2328: l_where_clause VARCHAR2(4000);
2329:
2330: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
2331: l_contract_id NUMBER;
2332: l_contract_status_code VARCHAR2(30);
2333: l_contract_version_num NUMBER;
2334:

Line 2664: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

2660: Cancels the Contract for the given document type.
2661: */
2662:
2663: Procedure cancel_contract(p_api_version IN NUMBER,
2664: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2665: p_contract_type IN VARCHAR2 DEFAULT NULL,
2666: p_contract_id IN NUMBER DEFAULT NULL,
2667: p_commit IN VARCHAR2 := fnd_api.g_false,
2668: x_msg_data OUT NOCOPY VARCHAR2,

Line 2684: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;

2680:
2681: l_query VARCHAR2(4000);
2682: l_where_clause VARCHAR2(4000);
2683:
2684: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
2685:
2686:
2687: TYPE contract_id_cur IS REF CURSOR;
2688: c_contract_id_cur contract_id_cur;