eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_HEADERS_ALL

Line 9: g_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not
7: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');
8:
9: g_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
10:
11: --Bug#3497033
12: --g_currency_format_mask declared to pass in as the second parameter
13: --in FND_CURRENCY.GET_FORMAT_MASK

Line 493: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id

489: -- not insert into the action history.
490: --DocumentID
491: -- This value for this parameter depends on the DocumentType:
492: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.requisition_header_id
493: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id
494: -- 'RELEASE': PO_RELEASES_ALL.po_release_id
495: --DocumentNumber
496: -- (Obsolete) This parameter is ignored. This procedure will derive the
497: -- document number from DocumentID and DocumentType. (Bug 3284628)

Line 506: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code

502: -- 'REQUISITION', 'PO', 'PA', 'RELEASE'
503: --DocumentSubType
504: -- The value for this parameter depends on the DocumentType:
505: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.type_lookup_code
506: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code
507: -- 'RELEASE': PO_RELEASES_ALL.release_type
508: --SubmitterAction
509: -- (Unused) This parameter is not currently used.
510: --ForwardToID

Line 566: -- If 'Y' or 'N', this procedure will update the xml_flag in PO_HEADERS_ALL

562: -- value as : 'SUPPLIER' or 'REQUESTER'. Other callers will pass as NULL
563: -- value (default). The corresponding value('REQUESTER'/'SUPPLIER') is used
564: -- to set INITIATOR wf attribute in RCO wf.
565: --p_xml_flag
566: -- If 'Y' or 'N', this procedure will update the xml_flag in PO_HEADERS_ALL
567: -- or PO_RELEASES_ALL accordingly. This is used by HTML Orders. (Bug 5218538)
568: -- If null, no updates will be made.
569: -- p_source_type_code VARCHAR2 DEFAULT null
570: -- For the internal change order for requisitions the value will be INVENTORY

Line 653: l_conterms_exist_flag PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE; --

649:
650: /* RETROACTIVE FPI END */
651:
652: l_drop_ship_flag po_line_locations.drop_ship_flag%type; --
653: l_conterms_exist_flag PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE; --
654: --bug##3682458 replaced legal entity name with operating unit
655: l_operating_unit hr_all_organization_units_tl.name%TYPE; --
656:
657: l_document_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 3284628

Line 657: l_document_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 3284628

653: l_conterms_exist_flag PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE; --
654: --bug##3682458 replaced legal entity name with operating unit
655: l_operating_unit hr_all_organization_units_tl.name%TYPE; --
656:
657: l_document_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 3284628
658:
659: l_consigned_flag PO_HEADERS_ALL.CONSIGNED_CONSUMPTION_FLAG%TYPE;
660: l_autoapprove_retro varchar2(1);
661:

Line 659: l_consigned_flag PO_HEADERS_ALL.CONSIGNED_CONSUMPTION_FLAG%TYPE;

655: l_operating_unit hr_all_organization_units_tl.name%TYPE; --
656:
657: l_document_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 3284628
658:
659: l_consigned_flag PO_HEADERS_ALL.CONSIGNED_CONSUMPTION_FLAG%TYPE;
660: l_autoapprove_retro varchar2(1);
661:
662: l_okc_doc_type varchar2(20); --
663: l_vendor po_vendors.vendor_name%type; --Bug 4254468

Line 766: UPDATE po_headers_all

762: SET xml_flag = 'Y',
763: edi_processed_flag = 'N'
764: WHERE po_release_id = DocumentID;
765: ELSE
766: UPDATE po_headers_all
767: SET xml_flag = 'Y',
768: edi_processed_flag = 'N'
769: WHERE po_header_id = DocumentID;
770: END IF;

Line 779: update po_headers_all

775: UPDATE po_releases_all
776: SET xml_flag = 'N'
777: WHERE po_release_id = DocumentID;
778: ELSE
779: update po_headers_all
780: SET xml_flag = 'N'
781: WHERE po_header_id = DocumentID;
782: END IF;
783:

Line 992: po_headers_all poh --

988: into x_acceptance_required_flag,
989: x_acceptance_due_date,
990: x_agent_id
991: from po_releases por,
992: po_headers_all poh --
993: where por.po_release_id = DocumentID
994: and por.po_header_id = poh.po_header_id;
995:
996:

Line 1027: from po_headers_all

1023: IF DocumentTypeCode = 'PA' THEN
1024:
1025: select global_agreement_flag
1026: into l_ga_flag
1027: from po_headers_all
1028: where po_header_id = DocumentID;
1029:
1030: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,
1031: itemkey => l_itemkey,

Line 1088: po_headers_all POH --

1084: l_release_num,
1085: l_doc_display_name,
1086: l_document_number -- Bug 3284628
1087: from po_releases POR,
1088: po_headers_all POH --
1089: where POR.po_release_id = DocumentID
1090: and POR.po_header_id = POH.po_header_id; -- JOIN
1091:
1092: l_doc_num_rel := l_document_number || '-' || l_release_num;

Line 1327: from po_headers_all

1323: where po_release_id = DocumentId;
1324: ELSIF DocumentTypeCode = 'PO' THEN
1325: select NVL(consigned_consumption_flag, 'N')
1326: into l_consigned_flag
1327: from po_headers_all
1328: where po_header_id = DocumentId;
1329: END IF;
1330:
1331: EXCEPTION

Line 1735: l_style_id po_headers_all.style_id%TYPE;

1731: l_can_modify_flag VARCHAR2(1);
1732:
1733: l_view_po_url varchar2(1000); -- HTML Orders R12
1734: l_edit_po_url varchar2(1000); -- HTML Orders R12
1735: l_style_id po_headers_all.style_id%TYPE;
1736: l_ga_flag po_headers_all.global_agreement_flag%TYPE;
1737:
1738: /* Bug 7535468
1739: Increasing the length of x_progress from 200 to 1200 */

Line 1736: l_ga_flag po_headers_all.global_agreement_flag%TYPE;

1732:
1733: l_view_po_url varchar2(1000); -- HTML Orders R12
1734: l_edit_po_url varchar2(1000); -- HTML Orders R12
1735: l_style_id po_headers_all.style_id%TYPE;
1736: l_ga_flag po_headers_all.global_agreement_flag%TYPE;
1737:
1738: /* Bug 7535468
1739: Increasing the length of x_progress from 200 to 1200 */
1740: x_progress varchar2(1200);

Line 2035: FROM po_headers_all

2031: -- SQL What : Get the style id fromm po_headers
2032: -- SQL Why : To derive the style type
2033: SELECT style_id
2034: INTO l_style_id
2035: FROM po_headers_all
2036: WHERE po_header_id = l_document_id;
2037: Exception
2038: When Others Then
2039: l_style_id := null;

Line 2265: from po_headers_all

2261: ELSIF l_document_type IN ('PO','PA') THEN
2262:
2263: select AUTHORIZATION_STATUS, NVL(REVISION_NUM,0)
2264: into l_authorization_status, l_po_revision
2265: from po_headers_all
2266: where PO_HEADER_ID = l_document_id;
2267:
2268: /* Bug#1810322: kagarwal
2269: ** Desc: If the original authorization status is IN PROCESS or PRE-APPROVED

Line 4142: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE;

4138: l_doc_string varchar2(200);
4139: l_preparer_user_name varchar2(100);
4140:
4141: -- BINDING FPJ
4142: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE;
4143:
4144: BEGIN
4145: x_progress := 'PO_REQAPPROVAL_INIT1.Send_WS_FYI_Notif_Yes_No: 01';
4146: IF (g_po_wf_debug = 'Y') THEN

Line 4179: FROM po_headers_all

4175: IF ((l_document_type <> 'RELEASE') AND
4176: l_document_subtype IN ('STANDARD','BLANKET','CONTRACT')) THEN
4177: SELECT acceptance_required_flag
4178: INTO l_acceptance_flag
4179: FROM po_headers_all
4180: WHERE po_header_Id = l_document_id;
4181:
4182: IF l_acceptance_flag = 'S' THEN
4183: PO_REQAPPROVAL_INIT1.locate_notifier(l_document_id, l_document_type, 'Y', l_notifier, l_notifier_resp);

Line 6175: from po_headers_all

6171: where requisition_header_id = document_id;
6172:
6173: cursor get_po_orgid is
6174: select org_id
6175: from po_headers_all
6176: where po_header_id = document_id;
6177:
6178: cursor get_release_orgid is
6179: select org_id

Line 8124: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --

8120: l_doc_num varchar2(30);
8121: l_sys_error_msg varchar2(2000) :='';
8122: l_release_num_dash varchar2(30);
8123: l_release_num number; --1942901
8124: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --
8125:
8126: /* Bug# 2655410: kagarwal
8127: ** Desc: We will get the document type display value from
8128: ** po document types.

Line 8319: l_acceptance_flag po_headers_all.acceptance_required_flag%TYPE;

8315: actid in number,
8316: funcmode in varchar2,
8317: result out NOCOPY varchar2 )
8318: is
8319: l_acceptance_flag po_headers_all.acceptance_required_flag%TYPE;
8320: x_progress varchar2(3) := '000';
8321: l_document_id number;
8322: l_document_type po_document_types.document_type_code%type;
8323: l_document_subtype po_document_types.document_subtype%type;

Line 8353: from po_headers_all --bug 4764963

8349:
8350: if(l_document_type <> 'RELEASE') then
8351: select acceptance_required_flag
8352: into l_acceptance_flag
8353: from po_headers_all --bug 4764963
8354: where po_header_Id = l_document_id;
8355: else
8356: select acceptance_required_flag
8357: into l_acceptance_flag

Line 8376: from po_headers_all

8372:
8373: if(l_document_type <> 'RELEASE') then
8374: select revision_num
8375: into l_revision_num
8376: from po_headers_all
8377: where po_header_id = l_document_id;
8378:
8379: select count(*)
8380: into l_responded_shipments

Line 8425: x_po_header_id po_headers_all.po_header_id%TYPE;

8421: x_org_id number;
8422: x_user_id number;
8423: x_document_id number;
8424: x_document_type_code varchar2(30);
8425: x_po_header_id po_headers_all.po_header_id%TYPE;
8426: x_vendor po_vendors.vendor_name%TYPE; /* Bug 7172641 Changing the size as equal to the column size of vendor_name in po_vendors table */
8427: x_supp_user_name varchar2(100);
8428: x_supplier_displayname varchar2(100);
8429: x_revision_num number; -- RDP

Line 8470: po_headers_all poh, --

8466: else
8467: select pov.vendor_name, poh.po_header_id, por.revision_num --RDP
8468: into x_vendor,x_po_header_id,x_revision_num
8469: from po_releases por,
8470: po_headers_all poh, --
8471: po_vendors pov
8472: where por.po_release_id = x_document_id
8473: and por.po_header_id = poh.po_header_id
8474: and poh.vendor_id = pov.vendor_id;

Line 8657: po_headers_all poh, --

8653: into
8654: x_vendor,
8655: l_revision_num
8656: from po_releases por,
8657: po_headers_all poh, --
8658: po_vendors pov
8659: where por.po_release_id = x_document_id
8660: and por.po_header_id = poh.po_header_id
8661: and poh.vendor_id = pov.vendor_id;

Line 8811: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

8807: l_rowid ROWID;
8808: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
8809: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
8810: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
8811: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
8812: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
8813: -- End of Bug 2850566
8814: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
8815: l_accepting_party varchar2(1);

Line 8915: --Update the last update date when po_headers_all/po_releases_all tables are updated.

8911:
8912:
8913: -- Reset the Acceptance required Flag
8914: --Bug 6847039 - Start
8915: --Update the last update date when po_headers_all/po_releases_all tables are updated.
8916: if x_po_release_id is not null then
8917: update po_releases
8918: set acceptance_required_flag = 'N',
8919: LAST_UPDATE_DATE = SYSDATE,

Line 9181: l_document_id po_headers_all.po_header_id%type;

9177: itemkey in varchar2,
9178: actid in number,
9179: funcmode in varchar2,
9180: resultout out NOCOPY varchar2 ) is
9181: l_document_id po_headers_all.po_header_id%type;
9182: l_vendor_id po_headers_all.vendor_id%type;
9183: l_vendor_site_id po_headers_all.vendor_site_id%type;
9184: l_progress varchar2(300);
9185: l_update_releases varchar2(1) := 'Y';

Line 9182: l_vendor_id po_headers_all.vendor_id%type;

9178: actid in number,
9179: funcmode in varchar2,
9180: resultout out NOCOPY varchar2 ) is
9181: l_document_id po_headers_all.po_header_id%type;
9182: l_vendor_id po_headers_all.vendor_id%type;
9183: l_vendor_site_id po_headers_all.vendor_site_id%type;
9184: l_progress varchar2(300);
9185: l_update_releases varchar2(1) := 'Y';
9186: l_return_status varchar2(1) ;

Line 9183: l_vendor_site_id po_headers_all.vendor_site_id%type;

9179: funcmode in varchar2,
9180: resultout out NOCOPY varchar2 ) is
9181: l_document_id po_headers_all.po_header_id%type;
9182: l_vendor_id po_headers_all.vendor_id%type;
9183: l_vendor_site_id po_headers_all.vendor_site_id%type;
9184: l_progress varchar2(300);
9185: l_update_releases varchar2(1) := 'Y';
9186: l_return_status varchar2(1) ;
9187: l_communicate_update varchar2(30); -- Bug 3574895. Length same as that on the form field PO_APPROVE.COMMUNICATE_UPDATES

Line 9379: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

9375: resultout OUT NOCOPY VARCHAR2)
9376: IS
9377:
9378: l_retro_change VARCHAR2(1);
9379: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
9380: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
9381: l_progress VARCHAR2(2000);
9382: l_update_releases VARCHAR2(1) := 'Y';
9383: l_return_status VARCHAR2(1) ;

Line 9702: l_doc_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%type;

9698: p_func_mode in varchar2,
9699: x_result_out out NOCOPY varchar2 ) is
9700: l_progress varchar2(200);
9701: l_doc_id number;
9702: l_doc_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%type;
9703: l_cat_admin_user_name FND_USER.USER_NAME%type;
9704: BEGIN
9705: l_progress := '100';
9706: IF (g_po_wf_debug = 'Y') THEN

Line 9754: -- cleared from po_headers_all later. So first capture the item attribute

9750: -- initiator, then set the item attribute CATALOG_ADMIN_USER_NAME so that
9751: -- the catalog admin can be notified later in the workflow process.
9752: -- The reason why we are setting the attribute here instead of checking later
9753: -- in the wf process is because, the lock_owner_role/lock_owner_id will be
9754: -- cleared from po_headers_all later. So first capture the item attribute
9755: -- use it later in the workflow to decide whether a notification has to be
9756: -- sent. See Node "SHOULD_NOTIFY_CAT_ADMIN" function in the PO Approval and
9757: -- PO Approval Top Process(Also see function should_notify_cat_admin() in
9758: -- this file).

Line 9779: l_lock_owner_role PO_HEADERS_ALL.lock_owner_role%type;

9775: p_doc_id in number,
9776: p_doc_type in varchar2) is
9777: l_progress varchar2(255);
9778: l_user_name FND_USER.USER_NAME%type;
9779: l_lock_owner_role PO_HEADERS_ALL.lock_owner_role%type;
9780: l_lock_owner_user_id PO_HEADERS_ALL.lock_owner_user_id%type;
9781: BEGIN
9782: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 100' ||
9783: 'Document Id='|| to_char(p_doc_id) ||

Line 9780: l_lock_owner_user_id PO_HEADERS_ALL.lock_owner_user_id%type;

9776: p_doc_type in varchar2) is
9777: l_progress varchar2(255);
9778: l_user_name FND_USER.USER_NAME%type;
9779: l_lock_owner_role PO_HEADERS_ALL.lock_owner_role%type;
9780: l_lock_owner_user_id PO_HEADERS_ALL.lock_owner_user_id%type;
9781: BEGIN
9782: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 100' ||
9783: 'Document Id='|| to_char(p_doc_id) ||
9784: 'Document Type='|| p_doc_type;

Line 9799: from po_headers_all

9795: IF p_doc_type = 'PA' THEN
9796: -- Get the locking user role and user id information
9797: select lock_owner_user_id, lock_owner_role
9798: into l_lock_owner_user_id, l_lock_owner_role
9799: from po_headers_all
9800: where po_header_id = p_doc_id;
9801:
9802: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 140' ||
9803: 'l_lock_owner_user_id ='|| to_char(l_lock_owner_user_id) ||

Line 10044: UPDATE po_headers_all ph

10040: WHERE pr.po_release_id = p_doc_id ;
10041:
10042: ELSIF (p_doc_type in ('PO','PA')) THEN
10043:
10044: UPDATE po_headers_all ph
10045: SET ph.printed_date = sysdate, ph.print_count = nvl(ph.print_count,0) + 1
10046: WHERE ph.po_header_id = p_doc_id ;
10047: END IF;
10048: COMMIT;