APPS.PO_REQIMP_VAL_PVT dependencies on PO_REQ_DIST_INTERFACE

Line 15: * if PO_REQIMP_VAL_PVT.G_PO_REQ_DIST_INTERFACE,

11: * Parameters:
12: * p_interface_table_code - the interface table to be validated;
13: * if PO_REQIMP_VAL_PVT.G_PO_REQUISITIONS_INTERFACE,
14: use PO_REQUISITIONS_INTERFACE
15: * if PO_REQIMP_VAL_PVT.G_PO_REQ_DIST_INTERFACE,
16: use PO_REQ_DIST_INTERFACE
17: * Effects: For all records with the given request ID in the specified
18: * interface table, calls the PJM validation API to validate
19: * project and task information. Writes any validation errors to

Line 16: use PO_REQ_DIST_INTERFACE

12: * p_interface_table_code - the interface table to be validated;
13: * if PO_REQIMP_VAL_PVT.G_PO_REQUISITIONS_INTERFACE,
14: use PO_REQUISITIONS_INTERFACE
15: * if PO_REQIMP_VAL_PVT.G_PO_REQ_DIST_INTERFACE,
16: use PO_REQ_DIST_INTERFACE
17: * Effects: For all records with the given request ID in the specified
18: * interface table, calls the PJM validation API to validate
19: * project and task information. Writes any validation errors to
20: * PO_INTERFACE_ERRORS and any validation warnings to the concurrent

Line 102: PO_REQIMP_VAL_PVT.G_PO_REQ_DIST_INTERFACE) THEN

98: AND hoi.org_information_context = 'Accounting Information';
99: --< Bug 3265539 End >
100:
101: ELSIF (p_interface_table_code =
102: PO_REQIMP_VAL_PVT.G_PO_REQ_DIST_INTERFACE) THEN
103: l_interface_table_name := 'PO_REQ_DIST_INTERFACE';
104:
105: OPEN project_info_cv FOR
106: --< Bug 3265539 Start >

Line 103: l_interface_table_name := 'PO_REQ_DIST_INTERFACE';

99: --< Bug 3265539 End >
100:
101: ELSIF (p_interface_table_code =
102: PO_REQIMP_VAL_PVT.G_PO_REQ_DIST_INTERFACE) THEN
103: l_interface_table_name := 'PO_REQ_DIST_INTERFACE';
104:
105: OPEN project_info_cv FOR
106: --< Bug 3265539 Start >
107: -- Need to derive the OU of the dest inventory org as well.

Line 110: -- PO_REQUISITIONS_INTERFACE and PO_REQ_DIST_INTERFACE.

106: --< Bug 3265539 Start >
107: -- Need to derive the OU of the dest inventory org as well.
108: --
109: -- SQL What: Retrieve project-related information from
110: -- PO_REQUISITIONS_INTERFACE and PO_REQ_DIST_INTERFACE.
111: -- SQL Why: To validate project information using the PJM API.
112: -- SQL Join: po_req_dist_interface.dist_sequence_id =
113: -- po_requisitions_interface.req_dist_sequence_id
114: SELECT d.project_id,

Line 112: -- SQL Join: po_req_dist_interface.dist_sequence_id =

108: --
109: -- SQL What: Retrieve project-related information from
110: -- PO_REQUISITIONS_INTERFACE and PO_REQ_DIST_INTERFACE.
111: -- SQL Why: To validate project information using the PJM API.
112: -- SQL Join: po_req_dist_interface.dist_sequence_id =
113: -- po_requisitions_interface.req_dist_sequence_id
114: SELECT d.project_id,
115: d.task_id,
116: d.destination_organization_id,

Line 120: FROM po_req_dist_interface d,

116: d.destination_organization_id,
117: r.need_by_date,
118: d.transaction_id,
119: TO_NUMBER(hoi.org_information3)
120: FROM po_req_dist_interface d,
121: po_requisitions_interface r,
122: hr_organization_information hoi
123: WHERE d.project_accounting_context = 'Y'
124: AND d.request_id = p_request_id