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.OKL_CS_WF dependencies on OKL_TRX_CONTRACTS

Line 535: FROM OKL_TRX_CONTRACTS

531:
532: CURSOR c_check_tfr_req(p_trx_id IN NUMBER)
533: IS
534: SELECT count(*)
535: FROM OKL_TRX_CONTRACTS
536: WHERE ID=p_trx_id;
537:
538: BEGIN
539: if (funcmode = 'RUN') then

Line 597: FROM OKL_TRX_CONTRACTS

593: AS
594:
595: CURSOR c_req_record(p_id IN NUMBER) IS
596: SELECT *
597: FROM OKL_TRX_CONTRACTS
598: WHERE ID = p_id;
599:
600: CURSOR c_ctr_no(p_ctr_id IN NUMBER)
601: IS

Line 628: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

624: l_vendor_role VARCHAR2(100);
625: l_collections_role VARCHAR2(100);
626: l_contact_email VARCHAR2(2000);
627: l_trx_id NUMBER;
628: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
629: l_req_no NUMBER;
630: l_type VARCHAR2(30);
631: l_party_name VARCHAR2(360);
632: l_ctr_no VARCHAR2(120);

Line 1316: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;

1312: l_msg_count NUMBER;
1313: l_msg_data VARCHAR2(2000);
1314: l_error VARCHAR2(2000);
1315:
1316: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1317: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1318:
1319: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1320: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

Line 1317: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;

1313: l_msg_data VARCHAR2(2000);
1314: l_error VARCHAR2(2000);
1315:
1316: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1317: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1318:
1319: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1320: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1321:

Line 1319: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;

1315:
1316: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1317: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1318:
1319: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1320: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1321:
1322: l_tcnv_rec tcnv_rec_type;
1323: l_tclv_tbl tclv_tbl_type;

Line 1320: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

1316: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1317: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1318:
1319: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1320: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1321:
1322: l_tcnv_rec tcnv_rec_type;
1323: l_tclv_tbl tclv_tbl_type;
1324: lx_tcnv_rec tcnv_rec_type;

Line 1337: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,

1333:
1334: l_tcnv_rec.id := l_trx_id;
1335: l_tcnv_rec.tsu_code := l_status;
1336:
1337: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
1338: p_init_msg_list => fnd_api.g_false,
1339: x_return_status => l_return_status,
1340: x_msg_count => l_msg_count,
1341: x_msg_data => l_msg_data,

Line 1404: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;

1400: l_api_version NUMBER := 1.0;
1401: l_msg_count NUMBER;
1402: l_msg_data VARCHAR2(2000);
1403:
1404: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1405: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1406:
1407: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1408: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

Line 1405: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;

1401: l_msg_count NUMBER;
1402: l_msg_data VARCHAR2(2000);
1403:
1404: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1405: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1406:
1407: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1408: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1409:

Line 1407: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;

1403:
1404: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1405: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1406:
1407: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1408: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1409:
1410: l_tcnv_rec tcnv_rec_type;
1411: l_tclv_tbl tclv_tbl_type;

Line 1408: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

1404: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1405: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1406:
1407: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1408: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1409:
1410: l_tcnv_rec tcnv_rec_type;
1411: l_tclv_tbl tclv_tbl_type;
1412: lx_tcnv_rec tcnv_rec_type;

Line 1436: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,

1432: l_tcnv_rec.id := l_trx_id;
1433: l_tcnv_rec.tsu_code := l_status;
1434: l_tcnv_rec.rjn_code := l_rjn_code;
1435:
1436: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
1437: p_init_msg_list => fnd_api.g_false,
1438: x_return_status => l_return_status,
1439: x_msg_count => l_msg_count,
1440: x_msg_data => l_msg_data,

Line 1513: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

1509: l_api_version NUMBER := 1.0;
1510: l_msg_count NUMBER;
1511: l_msg_data VARCHAR2(2000);
1512:
1513: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1514: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1515: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1516: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1517: l_error VARCHAR2(2000);

Line 1514: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

1510: l_msg_count NUMBER;
1511: l_msg_data VARCHAR2(2000);
1512:
1513: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1514: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1515: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1516: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1517: l_error VARCHAR2(2000);
1518:

Line 1515: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

1511: l_msg_data VARCHAR2(2000);
1512:
1513: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1514: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1515: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1516: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1517: l_error VARCHAR2(2000);
1518:
1519: BEGIN

Line 1516: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

1512:
1513: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1514: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1515: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1516: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1517: l_error VARCHAR2(2000);
1518:
1519: BEGIN
1520: IF (funcmode = 'RESPOND') THEN

Line 1547: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,

1543: l_tcnv_rec.tsu_code := l_sts_code;
1544: l_tcnv_rec.rjn_code := l_rjn_code;
1545:
1546:
1547: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
1548: p_init_msg_list => fnd_api.g_false,
1549: x_return_status => l_return_status,
1550: x_msg_count => l_msg_count,
1551: x_msg_data => l_msg_data,

Line 1649: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

1645: l_api_version NUMBER := 1.0;
1646: l_msg_count NUMBER;
1647: l_msg_data VARCHAR2(2000);
1648:
1649: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1650: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1651: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1652: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1653: l_error VARCHAR2(2000);

Line 1650: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

1646: l_msg_count NUMBER;
1647: l_msg_data VARCHAR2(2000);
1648:
1649: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1650: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1651: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1652: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1653: l_error VARCHAR2(2000);
1654:

Line 1651: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

1647: l_msg_data VARCHAR2(2000);
1648:
1649: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1650: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1651: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1652: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1653: l_error VARCHAR2(2000);
1654:
1655: BEGIN

Line 1652: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

1648:
1649: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1650: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1651: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1652: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1653: l_error VARCHAR2(2000);
1654:
1655: BEGIN
1656: IF (funcmode = 'RESPOND') THEN

Line 1684: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,

1680: l_tcnv_rec.tsu_code := l_sts_code;
1681: l_tcnv_rec.rjn_code := l_rjn_code;
1682:
1683:
1684: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
1685: p_init_msg_list => fnd_api.g_false,
1686: x_return_status => l_return_status,
1687: x_msg_count => l_msg_count,
1688: x_msg_data => l_msg_data,

Line 2104: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;

2100:
2101: l_trx_id NUMBER;
2102: l_contract_id NUMBER;
2103:
2104: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2105: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2106:
2107: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2108: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

Line 2105: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;

2101: l_trx_id NUMBER;
2102: l_contract_id NUMBER;
2103:
2104: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2105: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2106:
2107: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2108: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2109:

Line 2107: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;

2103:
2104: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2105: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2106:
2107: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2108: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2109:
2110: l_tcnv_rec tcnv_rec_type;
2111: l_tclv_tbl tclv_tbl_type;

Line 2108: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

2104: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2105: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2106:
2107: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2108: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2109:
2110: l_tcnv_rec tcnv_rec_type;
2111: l_tclv_tbl tclv_tbl_type;
2112: lx_tcnv_rec tcnv_rec_type;

Line 2155: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,

2151: l_tcnv_rec.description := l_ntf_comments;
2152: l_tcnv_rec.tsu_code := l_sts_code;
2153: l_tcnv_rec.rjn_code := l_rjn_code;
2154:
2155: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
2156: p_init_msg_list => fnd_api.g_false,
2157: x_return_status => l_return_status,
2158: x_msg_count => l_msg_count,
2159: x_msg_data => l_msg_data,

Line 2284: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;

2280:
2281: l_trx_id NUMBER;
2282: l_contract_id NUMBER;
2283:
2284: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2285: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2286:
2287: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2288: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

Line 2285: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;

2281: l_trx_id NUMBER;
2282: l_contract_id NUMBER;
2283:
2284: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2285: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2286:
2287: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2288: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2289:

Line 2287: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;

2283:
2284: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2285: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2286:
2287: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2288: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2289:
2290: l_tcnv_rec tcnv_rec_type;
2291: l_tclv_tbl tclv_tbl_type;

Line 2288: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

2284: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2285: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2286:
2287: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2288: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2289:
2290: l_tcnv_rec tcnv_rec_type;
2291: l_tclv_tbl tclv_tbl_type;
2292: lx_tcnv_rec tcnv_rec_type;

Line 2328: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,

2324: l_tcnv_rec.description := l_ntf_comments;
2325: l_tcnv_rec.tsu_code := l_sts_code;
2326: l_tcnv_rec.rjn_code := l_rjn_code;
2327:
2328: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
2329: p_init_msg_list => fnd_api.g_false,
2330: x_return_status => l_return_status,
2331: x_msg_count => l_msg_count,
2332: x_msg_data => l_msg_data,