DBA Data[Home] [Help]

APPS.PN_INDEX_RENT_PVT dependencies on PN_INDEX_LEASE_CONSTRAINTS_PKG

Line 3505: /*pn_index_lease_constraints_pkg.check_unq_constraint_scope (

3501: l_rowid VARCHAR2 (18) := NULL;
3502: BEGIN
3503: g_program_unit := 'UPDATE_CONSTRAINT_ROW';
3504: x_return_status := fnd_api.g_ret_sts_success;
3505: /*pn_index_lease_constraints_pkg.check_unq_constraint_scope (
3506: x_return_status
3507: ,x_index_constraint_id
3508: ,x_index_lease_id
3509: ,x_scope

Line 3514: ' - Calling pn_index_lease_constraints_pkg.update_row for index_lease_id - '|| p_rent_index_rec.index_lease_id

3510: );*/
3511:
3512: pn_index_rent_pvt.DEBUG ( g_pkg_name
3513: || g_program_unit||
3514: ' - Calling pn_index_lease_constraints_pkg.update_row for index_lease_id - '|| p_rent_index_rec.index_lease_id
3515: ,3);
3516:
3517: pn_index_lease_constraints_pkg.update_row
3518: (x_rowid => l_rowid

Line 3517: pn_index_lease_constraints_pkg.update_row

3513: || g_program_unit||
3514: ' - Calling pn_index_lease_constraints_pkg.update_row for index_lease_id - '|| p_rent_index_rec.index_lease_id
3515: ,3);
3516:
3517: pn_index_lease_constraints_pkg.update_row
3518: (x_rowid => l_rowid
3519: --, x_org_id => p_index_constraint_rec.org_id
3520: , x_index_constraint_id => p_index_constraint_rec.index_constraint_id
3521: , x_index_lease_id => p_rent_index_rec.index_lease_id

Line 3558: ' - pn_index_lease_constraints_pkg.update_row successful. index_constraint_id - '||p_index_constraint_rec.index_constraint_id

3554:
3555:
3556: pn_index_rent_pvt.DEBUG ( g_pkg_name
3557: || g_program_unit||
3558: ' - pn_index_lease_constraints_pkg.update_row successful. index_constraint_id - '||p_index_constraint_rec.index_constraint_id
3559: ,3);
3560: EXCEPTION
3561: WHEN fnd_api.g_exc_error
3562: THEN

Line 3614: ' - Calling pn_index_lease_constraints_pkg.insert_row for index_constraint_id '

3610:
3611:
3612: pn_index_rent_pvt.DEBUG ( g_pkg_name
3613: || g_program_unit||
3614: ' - Calling pn_index_lease_constraints_pkg.insert_row for index_constraint_id '
3615: ,3);
3616: pn_index_lease_constraints_pkg.insert_row
3617: (x_rowid => l_rowid
3618: , x_org_id => p_index_constraint_rec.org_id

Line 3616: pn_index_lease_constraints_pkg.insert_row

3612: pn_index_rent_pvt.DEBUG ( g_pkg_name
3613: || g_program_unit||
3614: ' - Calling pn_index_lease_constraints_pkg.insert_row for index_constraint_id '
3615: ,3);
3616: pn_index_lease_constraints_pkg.insert_row
3617: (x_rowid => l_rowid
3618: , x_org_id => p_index_constraint_rec.org_id
3619: , x_index_constraint_id => p_index_constraint_rec.index_constraint_id
3620: , x_index_lease_id => p_rent_index_rec.index_lease_id

Line 3660: ' - pn_index_lease_constraints_pkg.insert_row successful.Index_constraint_id - '||p_index_constraint_rec.index_constraint_id

3656: , fnd_global.user_id));
3657:
3658: pn_index_rent_pvt.DEBUG ( g_pkg_name
3659: || g_program_unit||
3660: ' - pn_index_lease_constraints_pkg.insert_row successful.Index_constraint_id - '||p_index_constraint_rec.index_constraint_id
3661: ,3);
3662: IF p_index_constraint_rec.index_constraint_id >0
3663: THEN
3664: x_return_status := fnd_api.g_ret_sts_success;