APPS.PO_HEADERS_SV5 dependencies on PO_HEADERS

Line 1: PACKAGE BODY PO_HEADERS_SV5 as

1: PACKAGE BODY PO_HEADERS_SV5 as
2: /* $Header: POXPOH5B.pls 120.3 2007/12/18 11:44:47 ggandhi ship $*/
3:
4:
5: /*===========================================================================

Line 143: FROM PO_RELEASES PORH, PO_HEADERS POH

139:
140: CURSOR unapproved_releases IS
141: SELECT PORH.PO_release_ID,
142: POH.Type_Lookup_Code
143: FROM PO_RELEASES PORH, PO_HEADERS POH
144: WHERE NVL(PORH.authorization_status,'INCOMPLETE') IN
145: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL')
146: AND NVL(PORH.cancel_flag,'N') = 'N'
147: AND NVL(PORH.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 153: l_conterms_exist_flag po_headers_all.conterms_exist_flag%TYPE;

149: AND PORH.PO_HEADER_ID = X_Po_Header_Id;
150:
151: /* FPJ CONTERMS START */
152: l_contracts_document_type VARCHAR2(150);
153: l_conterms_exist_flag po_headers_all.conterms_exist_flag%TYPE;
154: l_vendor_id po_headers_all.vendor_id%TYPE;
155: l_vendor_site_id po_headers_all.vendor_site_id%TYPE;
156: l_vendor_information_updated boolean := FND_API.To_boolean(FND_API.G_FALSE);
157:

Line 154: l_vendor_id po_headers_all.vendor_id%TYPE;

150:
151: /* FPJ CONTERMS START */
152: l_contracts_document_type VARCHAR2(150);
153: l_conterms_exist_flag po_headers_all.conterms_exist_flag%TYPE;
154: l_vendor_id po_headers_all.vendor_id%TYPE;
155: l_vendor_site_id po_headers_all.vendor_site_id%TYPE;
156: l_vendor_information_updated boolean := FND_API.To_boolean(FND_API.G_FALSE);
157:
158: l_msg_data VARCHAR2(2000);

Line 155: l_vendor_site_id po_headers_all.vendor_site_id%TYPE;

151: /* FPJ CONTERMS START */
152: l_contracts_document_type VARCHAR2(150);
153: l_conterms_exist_flag po_headers_all.conterms_exist_flag%TYPE;
154: l_vendor_id po_headers_all.vendor_id%TYPE;
155: l_vendor_site_id po_headers_all.vendor_site_id%TYPE;
156: l_vendor_information_updated boolean := FND_API.To_boolean(FND_API.G_FALSE);
157:
158: l_msg_data VARCHAR2(2000);
159: l_msg_count NUMBER;

Line 184: X_unapprove_doc := po_headers_sv2.val_approval_status(

180:
181: if (X_Approved_Flag = 'Y') OR
182: ( X_Authorization_Status = 'PRE-APPROVED') THEN
183:
184: X_unapprove_doc := po_headers_sv2.val_approval_status(
185: X_po_header_id ,
186: X_agent_id ,
187: X_vendor_site_id ,
188: X_vendor_contact_id ,

Line 246: FROM po_headers_all

242: -- SQL JOIN: rowid
243:
244: SELECT vendor_id, vendor_site_id, conterms_exist_flag
245: INTO l_vendor_id, l_vendor_site_id, l_conterms_exist_flag
246: FROM po_headers_all
247: WHERE rowid = X_Rowid;
248: /* FPJ CONTERMS END*/
249:
250: -- dbms_output.put_line('Before the Table Handler Update');

Line 253: po_headers_pkg_s2.update_row(

249:
250: -- dbms_output.put_line('Before the Table Handler Update');
251: X_progress := '020';
252:
253: po_headers_pkg_s2.update_row(
254: X_Rowid ,
255: X_Po_Header_Id ,
256: X_Agent_Id ,
257: X_Type_Lookup_Code ,

Line 457: X_allow_delete := po_headers_sv1.val_delete (X_po_header_id, X_type_lookup_code);

453: if (x_status_lookup_code = 'C') then
454:
455: /* Validate if the Document can be deleted */
456:
457: X_allow_delete := po_headers_sv1.val_delete (X_po_header_id, X_type_lookup_code);
458:
459: /* If the doc can be deleted, */
460:
461: if (X_allow_delete) then

Line 508: END PO_HEADERS_SV5;

504:
505: END update_header;
506:
507:
508: END PO_HEADERS_SV5;