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 526: FROM OKL_TRX_CONTRACTS

522:
523: CURSOR c_check_tfr_req(p_trx_id IN NUMBER)
524: IS
525: SELECT count(*)
526: FROM OKL_TRX_CONTRACTS
527: WHERE ID=p_trx_id;
528:
529: BEGIN
530: if (funcmode = 'RUN') then

Line 588: FROM OKL_TRX_CONTRACTS

584: AS
585:
586: CURSOR c_req_record(p_id IN NUMBER) IS
587: SELECT *
588: FROM OKL_TRX_CONTRACTS
589: WHERE ID = p_id;
590:
591: CURSOR c_ctr_no(p_ctr_id IN NUMBER)
592: IS

Line 619: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

615: l_vendor_role VARCHAR2(100);
616: l_collections_role VARCHAR2(100);
617: l_contact_email VARCHAR2(2000);
618: l_trx_id NUMBER;
619: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
620: l_req_no NUMBER;
621: l_type VARCHAR2(30);
622: l_party_name VARCHAR2(360);
623: l_ctr_no VARCHAR2(120);

Line 1307: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;

1303: l_msg_count NUMBER;
1304: l_msg_data VARCHAR2(2000);
1305: l_error VARCHAR2(2000);
1306:
1307: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1308: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1309:
1310: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1311: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

Line 1308: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;

1304: l_msg_data VARCHAR2(2000);
1305: l_error VARCHAR2(2000);
1306:
1307: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1308: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1309:
1310: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1311: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1312:

Line 1310: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;

1306:
1307: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1308: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1309:
1310: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1311: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1312:
1313: l_tcnv_rec tcnv_rec_type;
1314: l_tclv_tbl tclv_tbl_type;

Line 1311: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

1307: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1308: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1309:
1310: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1311: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1312:
1313: l_tcnv_rec tcnv_rec_type;
1314: l_tclv_tbl tclv_tbl_type;
1315: lx_tcnv_rec tcnv_rec_type;

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

1324:
1325: l_tcnv_rec.id := l_trx_id;
1326: l_tcnv_rec.tsu_code := l_status;
1327:
1328: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
1329: p_init_msg_list => fnd_api.g_false,
1330: x_return_status => l_return_status,
1331: x_msg_count => l_msg_count,
1332: x_msg_data => l_msg_data,

Line 1395: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;

1391: l_api_version NUMBER := 1.0;
1392: l_msg_count NUMBER;
1393: l_msg_data VARCHAR2(2000);
1394:
1395: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1396: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1397:
1398: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1399: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

Line 1396: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;

1392: l_msg_count NUMBER;
1393: l_msg_data VARCHAR2(2000);
1394:
1395: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1396: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1397:
1398: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1399: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1400:

Line 1398: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;

1394:
1395: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1396: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1397:
1398: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1399: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1400:
1401: l_tcnv_rec tcnv_rec_type;
1402: l_tclv_tbl tclv_tbl_type;

Line 1399: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

1395: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
1396: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
1397:
1398: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
1399: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
1400:
1401: l_tcnv_rec tcnv_rec_type;
1402: l_tclv_tbl tclv_tbl_type;
1403: lx_tcnv_rec tcnv_rec_type;

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

1423: l_tcnv_rec.id := l_trx_id;
1424: l_tcnv_rec.tsu_code := l_status;
1425: l_tcnv_rec.rjn_code := l_rjn_code;
1426:
1427: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
1428: p_init_msg_list => fnd_api.g_false,
1429: x_return_status => l_return_status,
1430: x_msg_count => l_msg_count,
1431: x_msg_data => l_msg_data,

Line 1504: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

1500: l_api_version NUMBER := 1.0;
1501: l_msg_count NUMBER;
1502: l_msg_data VARCHAR2(2000);
1503:
1504: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1505: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1506: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1507: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1508: l_error VARCHAR2(2000);

Line 1505: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

1501: l_msg_count NUMBER;
1502: l_msg_data VARCHAR2(2000);
1503:
1504: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1505: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1506: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1507: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1508: l_error VARCHAR2(2000);
1509:

Line 1506: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

1502: l_msg_data VARCHAR2(2000);
1503:
1504: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1505: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1506: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1507: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1508: l_error VARCHAR2(2000);
1509:
1510: BEGIN

Line 1507: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

1503:
1504: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1505: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1506: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1507: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1508: l_error VARCHAR2(2000);
1509:
1510: BEGIN
1511: IF (funcmode = 'RESPOND') THEN

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

1534: l_tcnv_rec.tsu_code := l_sts_code;
1535: l_tcnv_rec.rjn_code := l_rjn_code;
1536:
1537:
1538: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
1539: p_init_msg_list => fnd_api.g_false,
1540: x_return_status => l_return_status,
1541: x_msg_count => l_msg_count,
1542: x_msg_data => l_msg_data,

Line 1640: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

1636: l_api_version NUMBER := 1.0;
1637: l_msg_count NUMBER;
1638: l_msg_data VARCHAR2(2000);
1639:
1640: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1641: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1642: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1643: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1644: l_error VARCHAR2(2000);

Line 1641: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

1637: l_msg_count NUMBER;
1638: l_msg_data VARCHAR2(2000);
1639:
1640: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1641: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1642: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1643: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1644: l_error VARCHAR2(2000);
1645:

Line 1642: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

1638: l_msg_data VARCHAR2(2000);
1639:
1640: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1641: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1642: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1643: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1644: l_error VARCHAR2(2000);
1645:
1646: BEGIN

Line 1643: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;

1639:
1640: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1641: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1642: lx_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
1643: lx_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
1644: l_error VARCHAR2(2000);
1645:
1646: BEGIN
1647: IF (funcmode = 'RESPOND') THEN

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

1671: l_tcnv_rec.tsu_code := l_sts_code;
1672: l_tcnv_rec.rjn_code := l_rjn_code;
1673:
1674:
1675: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
1676: p_init_msg_list => fnd_api.g_false,
1677: x_return_status => l_return_status,
1678: x_msg_count => l_msg_count,
1679: x_msg_data => l_msg_data,

Line 2095: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;

2091:
2092: l_trx_id NUMBER;
2093: l_contract_id NUMBER;
2094:
2095: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2096: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2097:
2098: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2099: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

Line 2096: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;

2092: l_trx_id NUMBER;
2093: l_contract_id NUMBER;
2094:
2095: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2096: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2097:
2098: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2099: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2100:

Line 2098: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;

2094:
2095: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2096: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2097:
2098: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2099: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2100:
2101: l_tcnv_rec tcnv_rec_type;
2102: l_tclv_tbl tclv_tbl_type;

Line 2099: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

2095: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2096: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2097:
2098: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2099: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2100:
2101: l_tcnv_rec tcnv_rec_type;
2102: l_tclv_tbl tclv_tbl_type;
2103: lx_tcnv_rec tcnv_rec_type;

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

2142: l_tcnv_rec.description := l_ntf_comments;
2143: l_tcnv_rec.tsu_code := l_sts_code;
2144: l_tcnv_rec.rjn_code := l_rjn_code;
2145:
2146: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
2147: p_init_msg_list => fnd_api.g_false,
2148: x_return_status => l_return_status,
2149: x_msg_count => l_msg_count,
2150: x_msg_data => l_msg_data,

Line 2275: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;

2271:
2272: l_trx_id NUMBER;
2273: l_contract_id NUMBER;
2274:
2275: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2276: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2277:
2278: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2279: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

Line 2276: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;

2272: l_trx_id NUMBER;
2273: l_contract_id NUMBER;
2274:
2275: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2276: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2277:
2278: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2279: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2280:

Line 2278: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;

2274:
2275: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2276: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2277:
2278: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2279: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2280:
2281: l_tcnv_rec tcnv_rec_type;
2282: l_tclv_tbl tclv_tbl_type;

Line 2279: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;

2275: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
2276: SUBTYPE tcnv_tbl_type IS okl_trx_contracts_pvt.tcnv_tbl_type;
2277:
2278: SUBTYPE tclv_rec_type IS okl_trx_contracts_pvt.tclv_rec_type;
2279: SUBTYPE tclv_tbl_type IS okl_trx_contracts_pvt.tclv_tbl_type;
2280:
2281: l_tcnv_rec tcnv_rec_type;
2282: l_tclv_tbl tclv_tbl_type;
2283: lx_tcnv_rec tcnv_rec_type;

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

2315: l_tcnv_rec.description := l_ntf_comments;
2316: l_tcnv_rec.tsu_code := l_sts_code;
2317: l_tcnv_rec.rjn_code := l_rjn_code;
2318:
2319: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
2320: p_init_msg_list => fnd_api.g_false,
2321: x_return_status => l_return_status,
2322: x_msg_count => l_msg_count,
2323: x_msg_data => l_msg_data,