APPS.PO_HEADERS_PKG_S2 dependencies on PO_HEADERS

Line 1: PACKAGE BODY PO_HEADERS_PKG_S2 as

1: PACKAGE BODY PO_HEADERS_PKG_S2 as
2: /* $Header: POXP3PHB.pls 120.11 2011/04/18 06:04:57 lswamina ship $ */
3:
4: /*===========================================================================
5:

Line 131: l_tax_attribute_update_code PO_HEADERS_ALL.tax_attribute_update_code%type; --< eTax Integration R12>

127: ,p_kterms_deliv_upd_date IN DATE --
128: ,p_enable_all_sites IN varchar2 --
129: ) IS
130:
131: l_tax_attribute_update_code PO_HEADERS_ALL.tax_attribute_update_code%type; --< eTax Integration R12>
132:
133: BEGIN
134:
135: --< eTax Integration R12 Start>

Line 156: UPDATE PO_HEADERS

152: --
153:
154:
155:
156: UPDATE PO_HEADERS
157: SET
158: po_header_id = X_Po_Header_Id,
159: agent_id = X_Agent_Id,
160: type_lookup_code = X_Type_Lookup_Code,

Line 293: DELETE FROM PO_HEADERS_ALL /*Bug6632095: using base table instead of view */

289:
290: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
291:
292: BEGIN
293: DELETE FROM PO_HEADERS_ALL /*Bug6632095: using base table instead of view */
294: WHERE rowid = X_Rowid;
295:
296: if (SQL%NOTFOUND) then
297: Raise NO_DATA_FOUND;

Line 334: FROM po_headers ph

330: into X_dummy
331: from sys.dual
332: where not exists
333: (SELECT 'po number is not unique'
334: FROM po_headers ph
335: WHERE ph.segment1 = X_segment1
336: AND ph.type_lookup_code IN
337: ('STANDARD','CONTRACT','BLANKET','PLANNED')
338: AND (X_rowid is null or ph.rowid <> X_rowid) );

Line 391: FROM po_headers ph

387: into X_dummy
388: from sys.dual
389: where not exists
390: (SELECT 'rfq/quote number is not unique'
391: FROM po_headers ph
392: WHERE ph.segment1 = X_segment1
393: AND ph.type_lookup_code = x_type_lookup_code
394: AND (X_rowid is null or ph.rowid <> X_rowid) );
395:

Line 458: END PO_HEADERS_PKG_S2;

454:
455: return(X_po_total);
456: END po_total;
457:
458: END PO_HEADERS_PKG_S2;