DBA Data[Home] [Help]

APPS.PN_REC_ARCL_DTL_PKG dependencies on PN_REC_ARCL_DTL_S

Line 20: x_status pn_rec_arcl_dtl.status%TYPE,

16: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
17: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
18: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
19: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
20: x_status pn_rec_arcl_dtl.status%TYPE,
21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,

Line 85: pn_rec_arcl_dtl_s.nextval,

81: last_update_login)
82: VALUES(
83: l_org_id,
84: x_area_class_id,
85: pn_rec_arcl_dtl_s.nextval,
86: x_as_of_date,
87: x_from_date,
88: x_to_date,
89: x_status,

Line 129: x_status pn_rec_arcl_dtl.status%TYPE,

125: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
126: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
127: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
128: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
129: x_status pn_rec_arcl_dtl.status%TYPE,
130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,