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.10 2007/12/18 16:30:36 ggandhi 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 390: FROM po_headers ph

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

Line 457: END PO_HEADERS_PKG_S2;

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