APPS.PO_REQIMP_VAL_PVT dependencies on PO_REQUISITIONS_INTERFACE

Line 13: * if PO_REQIMP_VAL_PVT.G_PO_REQUISITIONS_INTERFACE,

9: * Requires: none
10: * Modifies: PO_INTERFACE_ERRORS, concurrent program log
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

Line 14: use PO_REQUISITIONS_INTERFACE

10: * Modifies: PO_INTERFACE_ERRORS, concurrent program log
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

Line 74: PO_REQIMP_VAL_PVT.G_PO_REQUISITIONS_INTERFACE) THEN

70: END IF;
71: x_return_status := FND_API.g_ret_sts_success;
72:
73: IF (p_interface_table_code =
74: PO_REQIMP_VAL_PVT.G_PO_REQUISITIONS_INTERFACE) THEN
75: l_interface_table_name := 'PO_REQUISITIONS_INTERFACE';
76:
77: OPEN project_info_cv FOR
78: --< Bug 3265539 Start >

Line 75: l_interface_table_name := 'PO_REQUISITIONS_INTERFACE';

71: x_return_status := FND_API.g_ret_sts_success;
72:
73: IF (p_interface_table_code =
74: PO_REQIMP_VAL_PVT.G_PO_REQUISITIONS_INTERFACE) THEN
75: l_interface_table_name := 'PO_REQUISITIONS_INTERFACE';
76:
77: OPEN project_info_cv FOR
78: --< Bug 3265539 Start >
79: -- Need to derive the OU of the dest inventory org as well.

Line 82: -- PO_REQUISITIONS_INTERFACE.

78: --< Bug 3265539 Start >
79: -- Need to derive the OU of the dest inventory org as well.
80: --
81: -- SQL What: Retrieve project-related information from
82: -- PO_REQUISITIONS_INTERFACE.
83: -- SQL Why: To validate project information using the PJM API.
84: SELECT pri.project_id,
85: pri.task_id,
86: pri.destination_organization_id,

Line 90: FROM po_requisitions_interface pri,

86: pri.destination_organization_id,
87: pri.need_by_date,
88: pri.transaction_id,
89: TO_NUMBER(hoi.org_information3)
90: FROM po_requisitions_interface pri,
91: hr_organization_information hoi
92: WHERE pri.project_accounting_context = 'Y'
93: AND pri.request_id = p_request_id
94: -- Bug 3043971 We should only perform PJM validation on Inventory and

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 113: -- po_requisitions_interface.req_dist_sequence_id

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,
117: r.need_by_date,

Line 121: po_requisitions_interface r,

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
125: AND d.dist_sequence_id = r.req_dist_sequence_id