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.OKE_CONTRACT_APPROVAL_PVT dependencies on OKC_CONTRACT_PUB

Line 71: L1_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;

67: L_PAR_VALUE VARCHAR2(2000);
68: --
69: L_NLS_VALUE VARCHAR2(30);
70: --
71: L1_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
72: L2_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
73: l_msg_count NUMBER;
74: l_msg_data varchar2(2000);
75: cursor k_pid is

Line 72: L2_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;

68: --
69: L_NLS_VALUE VARCHAR2(30);
70: --
71: L1_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
72: L2_CPSV_REC OKC_CONTRACT_PUB.cpsv_rec_type;
73: l_msg_count NUMBER;
74: l_msg_data varchar2(2000);
75: cursor k_pid is
76: select ID

Line 225: /* OKC_CONTRACT_PUB.lock_contract_process(

221: end;
222: end;
223: end if;
224: --
225: /* OKC_CONTRACT_PUB.lock_contract_process(
226: p_api_version => l_api_version,
227: x_return_status => l_return_status,
228: x_msg_count => l_msg_count,
229: x_msg_data => l_msg_data,

Line 249: OKC_CONTRACT_PUB.update_contract_process(

245: OKE_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
246: RAISE OKE_API.G_EXCEPTION_ERROR;
247: end;
248: L1_CPSV_REC.PROCESS_ID := L_KEY;
249: OKC_CONTRACT_PUB.update_contract_process(
250: p_api_version => l_api_version,
251: x_return_status => l_return_status,
252: x_msg_count => l_msg_count,
253: x_msg_data => l_msg_data,

Line 1237: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1233: p_contract_id IN number,
1234: p_date_approved IN date default sysdate,
1235: x_return_status OUT NOCOPY varchar2
1236: ) is
1237: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1238: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1239: cursor lock_csr(p number) is
1240: select object_version_number
1241: from okc_k_headers_b

Line 1238: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1234: p_date_approved IN date default sysdate,
1235: x_return_status OUT NOCOPY varchar2
1236: ) is
1237: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1238: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1239: cursor lock_csr(p number) is
1240: select object_version_number
1241: from okc_k_headers_b
1242: where ID = p

Line 1269: OKC_CONTRACT_PUB.lock_contract_header(

1265: L1_header_rec.id := p_contract_id;
1266: open lock_csr(p_contract_id);
1267: fetch lock_csr into L1_header_rec.object_version_number;
1268: close lock_csr;
1269: OKC_CONTRACT_PUB.lock_contract_header(
1270: p_api_version => l_api_version,
1271: x_return_status => x_return_status,
1272: x_msg_count => l_msg_count,
1273: x_msg_data => l_msg_data,

Line 1283: OKC_CONTRACT_PUB.update_contract_header(

1279: END IF;
1280:
1281: --update
1282: L1_header_rec.date_approved := p_date_approved;
1283: OKC_CONTRACT_PUB.update_contract_header(
1284: p_api_version => l_api_version,
1285: x_return_status => x_return_status,
1286: p_init_msg_list => OKE_API.G_TRUE,
1287: x_msg_count => l_msg_count,

Line 1343: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1339: procedure k_erase_approved(
1340: p_contract_id IN number,
1341: x_return_status OUT NOCOPY VARCHAR2
1342: ) is
1343: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1344: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1345: dummy varchar2(1) := '?';
1346: cursor c1 is
1347: select '!'

Line 1344: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1340: p_contract_id IN number,
1341: x_return_status OUT NOCOPY VARCHAR2
1342: ) is
1343: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1344: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1345: dummy varchar2(1) := '?';
1346: cursor c1 is
1347: select '!'
1348: from OKC_K_HEADERS_B

Line 1390: OKC_CONTRACT_PUB.lock_contract_header(

1386: L1_header_rec.id := p_contract_id;
1387: open lock_csr(p_contract_id);
1388: fetch lock_csr into L1_header_rec.object_version_number;
1389: close lock_csr;
1390: OKC_CONTRACT_PUB.lock_contract_header(
1391: p_api_version => l_api_version,
1392: x_return_status => x_return_status,
1393: x_msg_count => l_msg_count,
1394: x_msg_data => l_msg_data,

Line 1404: OKC_CONTRACT_PUB.update_contract_header(

1400: END IF;
1401:
1402: --update
1403: L1_header_rec.date_approved := NULL;
1404: OKC_CONTRACT_PUB.update_contract_header(
1405: p_api_version => l_api_version,
1406: x_return_status => x_return_status,
1407: x_msg_count => l_msg_count,
1408: x_msg_data => l_msg_data,

Line 1469: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1465: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1466: l_msg_count NUMBER;
1467: l_msg_data varchar2(2000);
1468:
1469: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1470: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1471: cursor lock_csr(p number) is
1472: select object_version_number, START_DATE, END_DATE
1473: from okc_k_headers_b

Line 1470: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

1466: l_msg_count NUMBER;
1467: l_msg_data varchar2(2000);
1468:
1469: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1470: L2_header_rec OKC_CONTRACT_PUB.chrv_rec_type;
1471: cursor lock_csr(p number) is
1472: select object_version_number, START_DATE, END_DATE
1473: from okc_k_headers_b
1474: where ID = p

Line 1510: l1_lines okc_contract_pub.clev_tbl_type;

1506: --
1507: loc1_rec lock1_csr%ROWTYPE;
1508: i number :=0;
1509: --
1510: l1_lines okc_contract_pub.clev_tbl_type;
1511: l2_lines okc_contract_pub.clev_tbl_type;
1512: l3_lines okc_contract_pub.clev_tbl_type;
1513: --
1514: call_time varchar2(1);

Line 1511: l2_lines okc_contract_pub.clev_tbl_type;

1507: loc1_rec lock1_csr%ROWTYPE;
1508: i number :=0;
1509: --
1510: l1_lines okc_contract_pub.clev_tbl_type;
1511: l2_lines okc_contract_pub.clev_tbl_type;
1512: l3_lines okc_contract_pub.clev_tbl_type;
1513: --
1514: call_time varchar2(1);
1515:

Line 1512: l3_lines okc_contract_pub.clev_tbl_type;

1508: i number :=0;
1509: --
1510: l1_lines okc_contract_pub.clev_tbl_type;
1511: l2_lines okc_contract_pub.clev_tbl_type;
1512: l3_lines okc_contract_pub.clev_tbl_type;
1513: --
1514: call_time varchar2(1);
1515:
1516: begin

Line 1538: OKC_CONTRACT_PUB.lock_contract_header(

1534: open lock_csr(p_contract_id);
1535: fetch lock_csr into
1536: L1_header_rec.object_version_number,L1_header_rec.START_DATE,L1_header_rec.END_DATE;
1537: close lock_csr;
1538: OKC_CONTRACT_PUB.lock_contract_header(
1539: p_api_version => l_api_version,
1540: x_return_status => x_return_status,
1541: x_msg_count => l_msg_count,
1542: x_msg_data => l_msg_data,

Line 1576: OKC_CONTRACT_PUB.update_contract_header(

1572: l_new_status := l_expired_status; call_time := 'N';
1573: end if;
1574: L1_header_rec.STS_CODE := l_new_status;
1575:
1576: OKC_CONTRACT_PUB.update_contract_header(
1577: p_api_version => l_api_version,
1578: x_return_status => x_return_status,
1579: x_msg_count => l_msg_count,
1580: x_msg_data => l_msg_data,

Line 1600: OKC_CONTRACT_PUB.lock_contract_line(

1596: l2_lines(i).id := lock1_rec.id;
1597: l2_lines(i).object_version_number := lock1_rec.object_version_number;
1598: l2_lines(i).sts_code := lock1_rec.sts_code;
1599: end LOOP;
1600: OKC_CONTRACT_PUB.lock_contract_line(
1601: p_api_version => l_api_version,
1602: x_return_status => x_return_status,
1603: x_msg_count => l_msg_count,
1604: x_msg_data => l_msg_data,

Line 1613: OKC_CONTRACT_PUB.update_contract_line(

1609: RAISE OKC_API.G_EXCEPTION_ERROR;
1610: END IF;
1611:
1612: -- update lines
1613: OKC_CONTRACT_PUB.update_contract_line(
1614: p_api_version => l_api_version,
1615: x_return_status => x_return_status,
1616: x_msg_count => l_msg_count,
1617: x_msg_data => l_msg_data,