APPS.PN_TENANCIES_PKG dependencies on PN_SPACE_ASSIGN_CUST_PKG

Line 1644: -- 28-Apr-04 vmmehta o BUG#3197182. Changed call to pn_space_assign_cust_pkg.insert_row

1640: -- table to x_fin_oblig_end_date.
1641: -- 08-NOV-03 STripathi o Fixed for BUG# 3242651. Call chk_dup_cust_assign to check
1642: -- duplicate assignment before insert_row pass DUP_ASSIGN in p_action.
1643: -- 05-MAR-04 ftanudja o Replaced call to chk_dup_cust_assign w/ exception handling.
1644: -- 28-Apr-04 vmmehta o BUG#3197182. Changed call to pn_space_assign_cust_pkg.insert_row
1645: -- Added parameter x_return_status and checking
1646: -- return_status rather than duplicate_exception.
1647: -------------------------------------------------------------------------------
1648: PROCEDURE insert_space_assign_row(

Line 1672: pn_space_assign_cust_pkg.insert_row(

1668: i := 0;
1669: FOR i IN 0 .. p_space_assign_info_tbl.count-1
1670: LOOP
1671:
1672: pn_space_assign_cust_pkg.insert_row(
1673: x_rowid => l_rowId,
1674: x_cust_space_assign_id => l_cust_space_assign_id,
1675: x_location_id => p_location_id,
1676: x_cust_account_id => p_customer_id,

Line 2136: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(

2132: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N') = 'Y' AND
2133: l_loc_type_code IN ('OFFICE', 'SECTION')
2134: THEN
2135:
2136: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(
2137: p_location_id => p_location_id,
2138: p_start_date => p_cust_assign_start_dt,
2139: p_end_date => p_cust_assign_end_dt);
2140:

Line 2159: -- PN_SPACE_ASSIGN_CUST_PKG.assignment_split

2155: --
2156: -- 10-JUN-03 PSidhu o Created for Recovery (CAM) impact on Leases and Space Assignments.
2157: -- 25-Nov-03 DThota o Added 2 parameters p_location_id and p_loc_type_code to
2158: -- delete_auto_space_assign. Added call to
2159: -- PN_SPACE_ASSIGN_CUST_PKG.assignment_split
2160: -- Fix for bug # 3282064
2161: -- 23-FEB-04 STripathi o Fixed for BUG# 3425167. Removed code for IF p_cust_assign_start_date
2162: -- IS NOT NULL AND p_cust_assign_end_date IS NOT NULL THEN.
2163: -- For a tenancy id, delete all space assgn records.

Line 2218: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(

2214: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N') = 'Y' AND
2215: p_loc_type_code IN ('OFFICE', 'SECTION')
2216: THEN
2217:
2218: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(
2219: p_location_id => p_location_id,
2220: p_start_date => p_cust_assign_start_date,
2221: p_end_date => p_cust_assign_end_date);
2222:

Line 2864: pn_space_assign_cust_pkg.chk_dup_cust_assign(

2860: ||'space_std/recovery_type is changed.');
2861:
2862: /*IF (NVL(p_customer_id, -99) <> NVL(p_customer_id_old, -99)) THEN
2863:
2864: pn_space_assign_cust_pkg.chk_dup_cust_assign(
2865: p_cust_acnt_id => p_customer_id
2866: ,p_loc_id => p_location_id
2867: ,p_assgn_str_dt => p_cust_assign_start_dt
2868: ,p_assgn_end_dt => p_cust_assign_end_dt

Line 2932: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(

2928: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N') = 'Y' AND
2929: l_loc_type_code IN ('OFFICE', 'SECTION')
2930: THEN
2931:
2932: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(
2933: p_location_id => p_location_id,
2934: p_start_date => p_cust_assign_start_dt,
2935: p_end_date => p_cust_assign_end_dt);
2936: