DBA Data[Home] [Help]

APPS.PN_SPACE_ASSIGN_CUST_PKG dependencies on PNT_LOCATIONS_PKG

Line 90: pnt_locations_pkg.Check_Location_Gaps(

86: ||', EndDt: '||TO_CHAR(x_cust_assign_end_date, 'MM/DD/YYYY')
87: ||', CustId: '||x_cust_account_id);
88:
89: -- Check if location is contigious Customer Assignable betn assign start and end dates.
90: pnt_locations_pkg.Check_Location_Gaps(
91: p_loc_id => x_location_id
92: ,p_str_dt => x_cust_assign_start_date
93: ,p_end_dt => NVL(x_cust_assign_end_date, TO_DATE('12/31/4712','MM/DD/YYYY'))
94: ,p_asgn_mode => 'CUST'

Line 546: pnt_locations_pkg.Check_Location_Gaps(

542: (x_cust_assign_start_date <> tlcustinfo.cust_assign_start_date) OR
543: (NVL(x_cust_assign_end_date, TO_DATE('12/31/4712','MM/DD/YYYY')) <>
544: NVL(tlcustinfo.cust_assign_end_date, TO_DATE('12/31/4712','MM/DD/YYYY')))
545: THEN
546: pnt_locations_pkg.Check_Location_Gaps(
547: p_loc_id => x_location_id
548: ,p_str_dt => x_cust_assign_start_date
549: ,p_end_dt => NVL(x_cust_assign_end_date, TO_DATE('12/31/4712','MM/DD/YYYY'))
550: ,p_asgn_mode => 'CUST'