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_OPI_PVT dependencies on OKL_OPEN_INT

Line 56: FROM okl_open_int

52: l_contract_found BOOLEAN := FALSE;
53:
54: CURSOR l_oin_csr(cp_contract_id IN NUMBER) IS
55: SELECT id
56: FROM okl_open_int
57: WHERE khr_id = cp_contract_id;
58: BEGIN
59: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
60: G_PKG_NAME,

Line 134: okl_open_int_pub.update_open_int(p_api_version => l_api_version

130: EXIT;
131: END LOOP;
132:
133: IF l_contract_found THEN
134: okl_open_int_pub.update_open_int(p_api_version => l_api_version
135: ,p_init_msg_list => p_init_msg_list
136: ,x_return_status => l_return_status
137: ,x_msg_count => x_msg_count
138: ,x_msg_data => x_msg_data

Line 142: okl_open_int_pub.insert_open_int(p_api_version => l_api_version

138: ,x_msg_data => x_msg_data
139: ,p_oinv_rec => l_oinv_rec
140: ,x_oinv_rec => lx_oinv_rec);
141: ELSE
142: okl_open_int_pub.insert_open_int(p_api_version => l_api_version
143: ,p_init_msg_list => p_init_msg_list
144: ,x_return_status => l_return_status
145: ,x_msg_count => x_msg_count
146: ,x_msg_data => x_msg_data

Line 243: FROM okl_open_int_prty

239:
240: CURSOR l_guarantor_csr(cp_khr_id IN NUMBER
241: ,cp_party_id IN NUMBER) IS
242: SELECT id
243: FROM okl_open_int_prty
244: WHERE khr_id = cp_khr_id
245: AND party_id = cp_party_id;
246: BEGIN
247: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 332: okl_open_int_pub.update_open_int(p_api_version => l_api_version

328: ,x_return_status => l_return_status);
329:
330:
331: --Update open interface row with new data
332: okl_open_int_pub.update_open_int(p_api_version => l_api_version
333: ,p_init_msg_list => p_init_msg_list
334: ,x_return_status => l_return_status
335: ,x_msg_count => x_msg_count
336: ,x_msg_data => x_msg_data

Line 354: --insert/update guarantors into okl_open_int_prty_v

350: get_guarantor(p_contract_id => lx_oinv_rec.khr_id
351: ,x_party_tbl => l_guarantor_tbl
352: ,x_return_status => l_return_status);
353:
354: --insert/update guarantors into okl_open_int_prty_v
355: --DBMS_OUTPUT.PUT_LINE('GUARANTOR count - ' || l_guarantor_tbl.count);
356: FOR i IN 1..l_guarantor_tbl.COUNT LOOP
357: l_oipv_rec.khr_id := lx_oinv_rec.khr_id;
358: l_oipv_rec.party_id := l_guarantor_tbl(i).party_id;

Line 398: okl_open_int_prty_pub.update_open_int_prty( p_api_version => l_api_version

394: EXIT;
395: END LOOP;
396:
397: IF (l_guarantor_found) THEN
398: okl_open_int_prty_pub.update_open_int_prty( p_api_version => l_api_version
399: ,p_init_msg_list => p_init_msg_list
400: ,x_return_status => l_return_status
401: ,x_msg_count => x_msg_count
402: ,x_msg_data => x_msg_data

Line 417: okl_open_int_prty_pub.insert_open_int_prty( p_api_version => l_api_version

413: --dbms_output.put_line('khr_id : ' || l_oipv_rec.khr_id);
414: --dbms_output.put_line('party_id : ' || l_oipv_rec.party_id);
415: --dbms_output.put_line('party_name : ' || l_oipv_rec.party_name);
416:
417: okl_open_int_prty_pub.insert_open_int_prty( p_api_version => l_api_version
418: ,p_init_msg_list => p_init_msg_list
419: ,x_return_status => l_return_status
420: ,x_msg_count => x_msg_count
421: ,x_msg_data => x_msg_data

Line 512: FROM okl_open_int_asst

508:
509: CURSOR l_asset_csr(cp_khr_id IN VARCHAR2
510: ,cp_instance_number IN VARCHAR2) IS
511: SELECT id
512: FROM okl_open_int_asst
513: WHERE khr_id = cp_khr_id
514: AND instance_number = cp_instance_number;
515: BEGIN
516: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 562: okl_open_int_asst_pub.update_open_int_asst (

558: END LOOP;
559:
560: IF (l_asset_found) THEN
561: --dbms_OUTPUT.PUT_LINE('updating asset');
562: okl_open_int_asst_pub.update_open_int_asst (
563: p_api_version => p_api_version,
564: p_init_msg_list => OKC_API.G_FALSE,
565: x_return_status => l_return_status,
566: x_msg_count => x_msg_count,

Line 579: okl_open_int_asst_pub.insert_open_int_asst (

575: END IF;
576: ELSE
577: --dbms_OUTPUT.PUT_LINE('inserting asset');
578: l_oiav_rec.org_id := p_iohv_rec.org_id;
579: okl_open_int_asst_pub.insert_open_int_asst (
580: p_api_version => p_api_version,
581: p_init_msg_list => OKC_API.G_FALSE,
582: x_return_status => l_return_status,
583: x_msg_count => x_msg_count,

Line 1448: PROCEDURE OKL_OPEN_INT_PARTY_MERGE (

1444: ----------- API BODY-----------------------------
1445: ----------------------------------------------------
1446: ---- Party Merge
1447:
1448: PROCEDURE OKL_OPEN_INT_PARTY_MERGE (
1449: p_entity_name IN VARCHAR2,
1450: p_from_id IN NUMBER,
1451: x_to_id OUT NOCOPY NUMBER,
1452: p_from_fk_id IN NUMBER,

Line 1461: l_api_name VARCHAR2(30) := 'OKL_OPEN_INT_PARTY_MERGE';

1457: x_return_status OUT NOCOPY VARCHAR2)
1458: IS
1459: --
1460: l_merge_reason_code VARCHAR2(30);
1461: l_api_name VARCHAR2(30) := 'OKL_OPEN_INT_PARTY_MERGE';
1462: l_count NUMBER(10) := 0;
1463: --
1464: BEGIN
1465: --

Line 1466: fnd_file.put_line(fnd_file.log, 'OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE');

1462: l_count NUMBER(10) := 0;
1463: --
1464: BEGIN
1465: --
1466: fnd_file.put_line(fnd_file.log, 'OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE');
1467: --
1468: arp_message.set_line('OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE()+');
1469:
1470: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1468: arp_message.set_line('OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE()+');

1464: BEGIN
1465: --
1466: fnd_file.put_line(fnd_file.log, 'OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE');
1467: --
1468: arp_message.set_line('OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE()+');
1469:
1470: x_return_status := FND_API.G_RET_STS_SUCCESS;
1471:
1472:

Line 1504: arp_message.set_token('TABLE_NAME','OKL_OPEN_INT',FALSE);

1500:
1501: if p_from_fk_id <> p_to_fk_id then
1502: begin
1503: arp_message.set_name('AR','AR_UPDATING_TABLE');
1504: arp_message.set_token('TABLE_NAME','OKL_OPEN_INT',FALSE);
1505: --
1506: --
1507: UPDATE OKL_OPEN_INT opi
1508: SET opi.party_ID = p_to_fk_id

Line 1507: UPDATE OKL_OPEN_INT opi

1503: arp_message.set_name('AR','AR_UPDATING_TABLE');
1504: arp_message.set_token('TABLE_NAME','OKL_OPEN_INT',FALSE);
1505: --
1506: --
1507: UPDATE OKL_OPEN_INT opi
1508: SET opi.party_ID = p_to_fk_id
1509: ,opi.object_version_number = opi.object_version_number + 1
1510: ,opi.last_update_date = SYSDATE
1511: ,opi.last_updated_by = arp_standard.profile.user_id

Line 1524: 'OKL_OPEN_INT for = '|| p_from_id));

1520: when others then
1521: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1522: --
1523: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1524: 'OKL_OPEN_INT for = '|| p_from_id));
1525: --
1526: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: end;

Line 1530: END OKL_OPEN_INT_PARTY_MERGE ;

1526: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: end;
1529: end if;
1530: END OKL_OPEN_INT_PARTY_MERGE ;
1531:
1532: END OKL_OPI_PVT;