APPS.POA_EDW_VARIABLES_PKG dependencies on POA_EDW_SPEND_PKG

Line 86: l_check_cut_out := POA_EDW_SPEND_PKG.get_check_cut_date(p_po_distribution_id);

82: */
83:
84: if (p_po_distribution_id <> l_dist_id_check_cut) then
85: l_dist_id_check_cut := p_po_distribution_id;
86: l_check_cut_out := POA_EDW_SPEND_PKG.get_check_cut_date(p_po_distribution_id);
87: end if;
88:
89: return l_check_cut_out;
90:

Line 107: l_goods_rcv_out := POA_EDW_SPEND_PKG.get_goods_received_date(p_po_line_location_id);

103: */
104:
105: if (p_po_line_location_id <> l_line_loc_goods_rcv) then
106: l_line_loc_goods_rcv := p_po_line_location_id;
107: l_goods_rcv_out := POA_EDW_SPEND_PKG.get_goods_received_date(p_po_line_location_id);
108: end if;
109: return l_goods_rcv_out;
110:
111: END GET_GOODS_RECEIVED_DATE;

Line 127: l_inv_create_out := POA_EDW_SPEND_PKG.get_invoice_creation_date(p_po_distribution_id);

123: */
124:
125: if (p_po_distribution_id <> l_dist_id_inv_create) then
126: l_dist_id_inv_create := p_po_distribution_id;
127: l_inv_create_out := POA_EDW_SPEND_PKG.get_invoice_creation_date(p_po_distribution_id);
128: end if;
129: return l_inv_create_out;
130:
131: END get_invoice_creation_date;

Line 147: l_inv_rcv_out := POA_EDW_SPEND_PKG.get_invoice_received_date(p_po_distribution_id);

143: */
144:
145: if (p_po_distribution_id <> l_dist_id_inv_rcv) then
146: l_dist_id_inv_rcv := p_po_distribution_id;
147: l_inv_rcv_out := POA_EDW_SPEND_PKG.get_invoice_received_date(p_po_distribution_id);
148: end if;
149:
150: return l_inv_rcv_out;
151:

Line 166: l_req_app_out := POA_EDW_SPEND_PKG.get_req_approval_date(p_po_req_dist_id);

162: end if;
163:
164: if (p_po_req_dist_id <> l_req_id_req_app OR l_req_id_req_app is NULL) then
165: l_req_id_req_app := p_po_req_dist_id;
166: l_req_app_out := POA_EDW_SPEND_PKG.get_req_approval_date(p_po_req_dist_id);
167: end if;
168:
169: return l_req_app_out;
170:

Line 188: l_ipv_out := POA_EDW_SPEND_PKG.get_ipv(p_po_distribution_id);

184: */
185:
186: if (p_po_distribution_id <> l_dist_id_ipv) then
187: l_dist_id_ipv := p_po_distribution_id;
188: l_ipv_out := POA_EDW_SPEND_PKG.get_ipv(p_po_distribution_id);
189: end if;
190: return l_ipv_out;
191:
192: END get_ipv;

Line 208: l_supp_app_out := POA_EDW_SPEND_PKG.get_supplier_approved(p_po_distribution_id);

204: */
205:
206: if (p_po_distribution_id <> l_dist_id_supp_app) then
207: l_dist_id_supp_app := p_po_distribution_id;
208: l_supp_app_out := POA_EDW_SPEND_PKG.get_supplier_approved(p_po_distribution_id);
209: end if;
210: return l_supp_app_out;
211:
212: END get_supplier_approved;

Line 233: l_supp_app_out := POA_EDW_SPEND_PKG.get_supplier_approved(p_po_distribution_id, p_vendor_id, p_vendor_site_id, p_ship_to_org_id, p_item_id, p_category_id);

229: */
230:
231: if (p_po_distribution_id <> l_dist_id_supp_app) then
232: l_dist_id_supp_app := p_po_distribution_id;
233: l_supp_app_out := POA_EDW_SPEND_PKG.get_supplier_approved(p_po_distribution_id, p_vendor_id, p_vendor_site_id, p_ship_to_org_id, p_item_id, p_category_id);
234: end if;
235: return l_supp_app_out;
236:
237: END get_supplier_approved;

Line 253: l_app_by_out := POA_EDW_SPEND_PKG.approved_by(p_po_header_id);

249: */
250:
251: if (p_po_header_id <> l_header_id_app_by) then
252: l_header_id_app_by := p_po_header_id;
253: l_app_by_out := POA_EDW_SPEND_PKG.approved_by(p_po_header_id);
254: end if;
255: return l_app_by_out;
256:
257: END approved_by;

Line 274: l_acc_date_out := POA_EDW_SPEND_PKG.get_acceptance_date(p_po_doc_id, p_type);

270: if (p_po_doc_id <> l_doc_id_acc_date OR p_type <> l_p_type_acc_date OR
271: l_doc_id_acc_date is NULL OR l_p_type_acc_date is NULL) then
272: l_doc_id_acc_date := p_po_doc_id;
273: l_p_type_acc_date := p_type;
274: l_acc_date_out := POA_EDW_SPEND_PKG.get_acceptance_date(p_po_doc_id, p_type);
275: end if;
276: return l_acc_date_out;
277:
278: END get_acceptance_date;