APPS.PNP_UTIL_FUNC dependencies on PN_SPACE_ASSIGN_CUST_PKG

Line 6472: | pn_space_assign_cust_pkg.update_row

6468: | 14-Nov-03 Satish o Fix for BUG# 3260023 (Issue 4). Made emp_rec, cust_rec
6469: | as _ALL%ROWTYPE. Modified all 4 cursors to select from
6470: | _ALL tables.
6471: | 28-Apr-04 vmmehta o Fix for BUG# 3197182. Changed call to
6472: | pn_space_assign_cust_pkg.update_row
6473: | Added parameter x_return_status
6474: | 18-JUN-04 Mrinal o Fixed for BUG# 3297892, calculate allocated_area
6475: | based on alloc_area_pct.
6476: | 13-AUG-04 Anand o Added NVL for emp/cust_end_date attributes.

Line 6622: PN_SPACE_ASSIGN_CUST_PKG.tlcustinfo := cust_rec;

6618: FETCH get_cust_assgn INTO cust_rec;
6619: EXIT WHEN get_cust_assgn%NOTFOUND;
6620: END IF;
6621:
6622: PN_SPACE_ASSIGN_CUST_PKG.tlcustinfo := cust_rec;
6623: l_new_cust_alloc_area := ROUND(((NVL(cust_rec.allocated_area_pct,0)*p_assgn_area)/100),4);
6624:
6625: IF cust_rec.cust_assign_start_date >= p_str_dt AND
6626: NVL(cust_rec.cust_assign_end_date,g_end_of_time) <= p_end_dt THEN

Line 6639: PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW(

6635: l_assgn_str_dt := p_str_dt;
6636: END IF;
6637: END IF;
6638:
6639: PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW(
6640: X_CUST_SPACE_ASSIGN_ID => cust_rec.CUST_SPACE_ASSIGN_ID,
6641: X_LOCATION_ID => cust_rec.LOCATION_ID,
6642: X_CUST_ACCOUNT_ID => cust_rec.CUST_ACCOUNT_ID,
6643: X_SITE_USE_ID => cust_rec.SITE_USE_ID,