DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on PN_SPACE_ASSIGN_CUST_ALL

Line 91: assignment_id PN_SPACE_ASSIGN_CUST_ALL.cust_space_assign_id%type,

87:
88: TYPE space_assignment_rec IS RECORD (
89:
90: location_id PN_LOCATIONS_ALL.location_id%type,
91: assignment_id PN_SPACE_ASSIGN_CUST_ALL.cust_space_assign_id%type,
92: assign_start_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
93: assign_end_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,
95: allocated_area PN_SPACE_ASSIGN_CUST_ALL.allocated_area%type,

Line 92: assign_start_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,

88: TYPE space_assignment_rec IS RECORD (
89:
90: location_id PN_LOCATIONS_ALL.location_id%type,
91: assignment_id PN_SPACE_ASSIGN_CUST_ALL.cust_space_assign_id%type,
92: assign_start_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
93: assign_end_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,
95: allocated_area PN_SPACE_ASSIGN_CUST_ALL.allocated_area%type,
96: utilized_area PN_SPACE_ASSIGN_CUST_ALL.utilized_area%type,

Line 93: assign_end_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,

89:
90: location_id PN_LOCATIONS_ALL.location_id%type,
91: assignment_id PN_SPACE_ASSIGN_CUST_ALL.cust_space_assign_id%type,
92: assign_start_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
93: assign_end_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,
95: allocated_area PN_SPACE_ASSIGN_CUST_ALL.allocated_area%type,
96: utilized_area PN_SPACE_ASSIGN_CUST_ALL.utilized_area%type,
97: project_id PN_SPACE_ASSIGN_CUST_ALL.project_id%type,

Line 94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,

90: location_id PN_LOCATIONS_ALL.location_id%type,
91: assignment_id PN_SPACE_ASSIGN_CUST_ALL.cust_space_assign_id%type,
92: assign_start_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
93: assign_end_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,
95: allocated_area PN_SPACE_ASSIGN_CUST_ALL.allocated_area%type,
96: utilized_area PN_SPACE_ASSIGN_CUST_ALL.utilized_area%type,
97: project_id PN_SPACE_ASSIGN_CUST_ALL.project_id%type,
98: task_id PN_SPACE_ASSIGN_CUST_ALL.task_id%type,

Line 95: allocated_area PN_SPACE_ASSIGN_CUST_ALL.allocated_area%type,

91: assignment_id PN_SPACE_ASSIGN_CUST_ALL.cust_space_assign_id%type,
92: assign_start_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
93: assign_end_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,
95: allocated_area PN_SPACE_ASSIGN_CUST_ALL.allocated_area%type,
96: utilized_area PN_SPACE_ASSIGN_CUST_ALL.utilized_area%type,
97: project_id PN_SPACE_ASSIGN_CUST_ALL.project_id%type,
98: task_id PN_SPACE_ASSIGN_CUST_ALL.task_id%type,
99: person_id PN_SPACE_ASSIGN_EMP_ALL.person_id%type,

Line 96: utilized_area PN_SPACE_ASSIGN_CUST_ALL.utilized_area%type,

92: assign_start_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
93: assign_end_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,
95: allocated_area PN_SPACE_ASSIGN_CUST_ALL.allocated_area%type,
96: utilized_area PN_SPACE_ASSIGN_CUST_ALL.utilized_area%type,
97: project_id PN_SPACE_ASSIGN_CUST_ALL.project_id%type,
98: task_id PN_SPACE_ASSIGN_CUST_ALL.task_id%type,
99: person_id PN_SPACE_ASSIGN_EMP_ALL.person_id%type,
100: cust_account_id PN_SPACE_ASSIGN_CUST_ALL.cust_account_id%type,

Line 97: project_id PN_SPACE_ASSIGN_CUST_ALL.project_id%type,

93: assign_end_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,
95: allocated_area PN_SPACE_ASSIGN_CUST_ALL.allocated_area%type,
96: utilized_area PN_SPACE_ASSIGN_CUST_ALL.utilized_area%type,
97: project_id PN_SPACE_ASSIGN_CUST_ALL.project_id%type,
98: task_id PN_SPACE_ASSIGN_CUST_ALL.task_id%type,
99: person_id PN_SPACE_ASSIGN_EMP_ALL.person_id%type,
100: cust_account_id PN_SPACE_ASSIGN_CUST_ALL.cust_account_id%type,
101: org_id PN_SPACE_ASSIGN_CUST_ALL.org_id%type,

Line 98: task_id PN_SPACE_ASSIGN_CUST_ALL.task_id%type,

94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,
95: allocated_area PN_SPACE_ASSIGN_CUST_ALL.allocated_area%type,
96: utilized_area PN_SPACE_ASSIGN_CUST_ALL.utilized_area%type,
97: project_id PN_SPACE_ASSIGN_CUST_ALL.project_id%type,
98: task_id PN_SPACE_ASSIGN_CUST_ALL.task_id%type,
99: person_id PN_SPACE_ASSIGN_EMP_ALL.person_id%type,
100: cust_account_id PN_SPACE_ASSIGN_CUST_ALL.cust_account_id%type,
101: org_id PN_SPACE_ASSIGN_CUST_ALL.org_id%type,
102: lease_id PN_SPACE_ASSIGN_CUST_ALL.lease_id%type

Line 100: cust_account_id PN_SPACE_ASSIGN_CUST_ALL.cust_account_id%type,

96: utilized_area PN_SPACE_ASSIGN_CUST_ALL.utilized_area%type,
97: project_id PN_SPACE_ASSIGN_CUST_ALL.project_id%type,
98: task_id PN_SPACE_ASSIGN_CUST_ALL.task_id%type,
99: person_id PN_SPACE_ASSIGN_EMP_ALL.person_id%type,
100: cust_account_id PN_SPACE_ASSIGN_CUST_ALL.cust_account_id%type,
101: org_id PN_SPACE_ASSIGN_CUST_ALL.org_id%type,
102: lease_id PN_SPACE_ASSIGN_CUST_ALL.lease_id%type
103: );
104:

Line 101: org_id PN_SPACE_ASSIGN_CUST_ALL.org_id%type,

97: project_id PN_SPACE_ASSIGN_CUST_ALL.project_id%type,
98: task_id PN_SPACE_ASSIGN_CUST_ALL.task_id%type,
99: person_id PN_SPACE_ASSIGN_EMP_ALL.person_id%type,
100: cust_account_id PN_SPACE_ASSIGN_CUST_ALL.cust_account_id%type,
101: org_id PN_SPACE_ASSIGN_CUST_ALL.org_id%type,
102: lease_id PN_SPACE_ASSIGN_CUST_ALL.lease_id%type
103: );
104:
105:

Line 102: lease_id PN_SPACE_ASSIGN_CUST_ALL.lease_id%type

98: task_id PN_SPACE_ASSIGN_CUST_ALL.task_id%type,
99: person_id PN_SPACE_ASSIGN_EMP_ALL.person_id%type,
100: cust_account_id PN_SPACE_ASSIGN_CUST_ALL.cust_account_id%type,
101: org_id PN_SPACE_ASSIGN_CUST_ALL.org_id%type,
102: lease_id PN_SPACE_ASSIGN_CUST_ALL.lease_id%type
103: );
104:
105:
106: TYPE space_assignment_tbl IS TABLE OF space_assignment_rec INDEX BY BINARY_INTEGER;