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.PN_LEASE_PVT dependencies on PN_CONTACT_ASSIGNMENTS_PKG

Line 1430: pn_contact_assignments_pkg.update_row

1426: , x_return_status OUT NOCOPY VARCHAR2)
1427: IS
1428: BEGIN
1429: pvt_debug(g_pkg_name||'-UPDATE_CONTACTS_ROW:Contact Assignment ID'||p_lease_contacts_rec.contact_assignment_id,3);
1430: pn_contact_assignments_pkg.update_row
1431: (x_contact_assignment_id => p_lease_contacts_rec.contact_assignment_id
1432: , x_last_update_date => SYSDATE
1433: , x_last_updated_by => g_user_id
1434: , x_last_update_login => fnd_global.login_id

Line 3306: pvt_debug(g_pkg_name||'- INSERT_CONTACTS_ROW:Calling PN_CONTACT_ASSIGNMENTS_PKG.INSERT_ROW',3);

3302:
3303: p_lease_contacts_rec.lease_id:=p_lease_rec.lease_id;
3304: p_lease_contacts_rec.lease_change_id:=p_lease_rec.lease_change_id;
3305: ----------------------dbms_output.put_line('In Contacts Assignment Inserrow');--Rupak
3306: pvt_debug(g_pkg_name||'- INSERT_CONTACTS_ROW:Calling PN_CONTACT_ASSIGNMENTS_PKG.INSERT_ROW',3);
3307: pn_contact_assignments_pkg.insert_row
3308: (x_rowid => l_rowid
3309: , x_contact_assignment_id => p_lease_contacts_rec.contact_assignment_id
3310: , x_last_update_date => NVL

Line 3307: pn_contact_assignments_pkg.insert_row

3303: p_lease_contacts_rec.lease_id:=p_lease_rec.lease_id;
3304: p_lease_contacts_rec.lease_change_id:=p_lease_rec.lease_change_id;
3305: ----------------------dbms_output.put_line('In Contacts Assignment Inserrow');--Rupak
3306: pvt_debug(g_pkg_name||'- INSERT_CONTACTS_ROW:Calling PN_CONTACT_ASSIGNMENTS_PKG.INSERT_ROW',3);
3307: pn_contact_assignments_pkg.insert_row
3308: (x_rowid => l_rowid
3309: , x_contact_assignment_id => p_lease_contacts_rec.contact_assignment_id
3310: , x_last_update_date => NVL
3311: (p_lease_contacts_rec.last_update_date

Line 3349: pvt_debug(g_pkg_name||'- INSERT_CONTACTS_ROW:PN_CONTACT_ASSIGNMENTS_PKG.INSERT_ROW Successful',3);

3345: , x_attribute15 => p_lease_contacts_rec.attribute15
3346: , x_org_id => p_lease_contacts_rec.org_id);
3347:
3348: ----------------------dbms_output.put_line('END OF LEASE_INSERT_ROW contact_assignment_id: '|| p_lease_contacts_rec.contact_assignment_id);--Rupak
3349: pvt_debug(g_pkg_name||'- INSERT_CONTACTS_ROW:PN_CONTACT_ASSIGNMENTS_PKG.INSERT_ROW Successful',3);
3350:
3351: EXCEPTION
3352: WHEN OTHERS
3353: THEN

Line 3356: pvt_debug(g_pkg_name||'- INSERT_CONTACTS_ROW:Exception:PN_CONTACT_ASSIGNMENTS_PKG.INSERT_ROW'||SQLERRM,3);

3352: WHEN OTHERS
3353: THEN
3354: NULL;
3355: ----------------------dbms_output.put_line ( 'IN LEASE CONTACTS INSERT EXCEPTION: '|| SQLERRM);--Rupak
3356: pvt_debug(g_pkg_name||'- INSERT_CONTACTS_ROW:Exception:PN_CONTACT_ASSIGNMENTS_PKG.INSERT_ROW'||SQLERRM,3);
3357: END insert_contacts_row;
3358:
3359: PROCEDURE validate_contacts_tbl (
3360: p_lease_contacts_tbl IN OUT NOCOPY lease_contacts_tbl