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_CHANGEORDERWF_PVT dependencies on PO_HEADERS_ALL

Line 210: l_type_lookup_code po_headers_all.type_lookup_code%type;

206:
207: l_supplier_username fnd_user.user_name%type;
208: l_planner_username fnd_user.user_name%type;
209: l_planner_disp_name varchar2(2000);
210: l_type_lookup_code po_headers_all.type_lookup_code%type;
211:
212: n_varname Wf_Engine.NameTabTyp;
213: n_varval Wf_Engine.NumTabTyp;
214: t_varname Wf_Engine.NameTabTyp;

Line 358: from PO_HEADERS_ALL

354: x_progress := '003';
355:
356: select revision_num
357: into l_revision_num
358: from PO_HEADERS_ALL
359: where po_header_id = p_doc_id;
360:
361: ELSIF p_doc_type = 'RELEASE' THEN
362:

Line 494: update po_headers_all

490: update po_releases_all
491: set change_requested_by = null
492: where po_release_id = p_release_id;
493: ELSE
494: update po_headers_all
495: set change_requested_by = null
496: where po_header_id = p_header_id;
497: END IF;
498:

Line 586: update po_headers_all

582:
583:
584: --Commiting Status to "APPOVED".
585: if(p_can_rel_id is null) then
586: update po_headers_all
587: set authorization_status = 'APPROVED'
588: where po_header_id = p_can_hdr_id;
589: else
590: update po_releases_all

Line 623: from po_headers_all

619: --Restoring PO's Authorization status back to "IN PROCESS".
620: if(p_can_rel_id is null) then
621: if(p_can_line_loc_id is null) then
622: select cancel_flag into l_cancel_flag
623: from po_headers_all
624: where po_header_id = p_can_hdr_id;
625: else
626: select cancel_flag into l_cancel_flag
627: from po_line_locations_all

Line 630: update po_headers_all

626: select cancel_flag into l_cancel_flag
627: from po_line_locations_all
628: where line_location_id = p_can_line_loc_id;
629: end if;
630: update po_headers_all
631: set authorization_status = 'IN PROCESS'
632: where po_header_id = p_can_hdr_id;
633: else
634: if(p_can_line_loc_id is null) then

Line 662: update po_headers_all

658: END IF;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: --Restoring PO's Authorization status back to "IN PROCESS".
661: if(p_can_rel_id is null) then
662: update po_headers_all
663: set authorization_status = 'IN PROCESS'
664: where po_header_id = p_can_hdr_id;
665: else
666: update po_releases_all

Line 697: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

693: l_can_reason po_change_requests.request_reason%TYPE;
694: l_cancel_backing_req po_change_requests.cancel_backing_req%TYPE;
695: l_can_doc_type po_document_types_all.document_type_code%TYPE;
696: l_can_doc_subtype po_document_types_all.document_subtype%TYPE;
697: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
698: l_return_status varchar2(1);
699: x_progress varchar2(3);
700: l_ship_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_SHIP_ERR');
701: l_hdr_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_HDR_ERR');

Line 775: from po_headers_all

771: /* Code changes for bug 13114334 - End */
772:
773: select type_lookup_code
774: into l_type_lookup_code
775: from po_headers_all
776: where po_header_id = l_can_hdr_id;
777: if(l_can_rel_id is null) then
778: l_can_doc_type := 'PO';
779: if(l_type_lookup_code = 'STANDARD') then

Line 842: from po_headers_all

838: l_can_doc_type;
839: exit when l_cancel_hdr_csr%NOTFOUND;
840: select type_lookup_code
841: into l_type_lookup_code
842: from po_headers_all
843: where po_header_id = l_can_hdr_id;
844: if(l_can_rel_id is null) then
845: l_can_doc_type := 'PO';
846: if(l_type_lookup_code = 'STANDARD') then

Line 920: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

916: l_Acceptance_id number;
917: -- Bug 2850566
918: l_rowid ROWID;
919: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
920: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
921: -- End of Bug 2850566
922: l_Last_Update_Date date;
923: l_Last_Updated_By number;
924: l_Creation_Date date := TRUNC(SYSDATE);

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

1047: -- End of Bug 2850566 RBAIRRAJ
1048:
1049: -- Reset the Acceptance required Flag
1050: --Bug 6772960 - Start
1051: --Update the last update date when po_headers_all/po_releases_all tables are updated.
1052: if l_po_release_id is not null then
1053: update po_releases
1054: set acceptance_required_flag = 'N',
1055: LAST_UPDATE_DATE = SYSDATE,

Line 1146: po_headers_all poh, --

1142: select pov.vendor_name
1143: into l_vendor
1144: from
1145: po_releases por,
1146: po_headers_all poh, --
1147: po_vendors pov
1148: where por.po_release_id = l_document_id
1149: and por.po_header_id = poh.po_header_id
1150: and poh.vendor_id = pov.vendor_id;

Line 1255: l_document_num po_headers_all.segment1%TYPE;

1251: l_api_name varchar2(50) := 'KickOffPOApproval';
1252: l_org_id number;
1253: l_agent_id number;
1254: l_document_id number;
1255: l_document_num po_headers_all.segment1%TYPE;
1256: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
1257: l_document_subtype po_document_types_all.DOCUMENT_SUBTYPE%TYPE;
1258: l_seq number;
1259: l_item_key po_headers_all.wf_item_key%TYPE;

Line 1259: l_item_key po_headers_all.wf_item_key%TYPE;

1255: l_document_num po_headers_all.segment1%TYPE;
1256: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
1257: l_document_subtype po_document_types_all.DOCUMENT_SUBTYPE%TYPE;
1258: l_seq number;
1259: l_item_key po_headers_all.wf_item_key%TYPE;
1260: l_item_type po_headers_all.wf_item_type%TYPE;
1261: l_workflow_process PO_DOCUMENT_TYPES_V.WF_APPROVAL_PROCESS%TYPE;
1262:
1263: /* Bug 2810156 BEGIN*/

Line 1260: l_item_type po_headers_all.wf_item_type%TYPE;

1256: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
1257: l_document_subtype po_document_types_all.DOCUMENT_SUBTYPE%TYPE;
1258: l_seq number;
1259: l_item_key po_headers_all.wf_item_key%TYPE;
1260: l_item_type po_headers_all.wf_item_type%TYPE;
1261: l_workflow_process PO_DOCUMENT_TYPES_V.WF_APPROVAL_PROCESS%TYPE;
1262:
1263: /* Bug 2810156 BEGIN*/
1264: l_orig_itemtype po_headers.wf_item_type%TYPE;

Line 1282: l_doc_num po_headers_all.segment1%TYPE;

1278: l_faxnum po_vendor_contacts.fax%TYPE;
1279: l_fax_area po_vendor_sites_all.fax_area_code%TYPE;
1280: l_preparer_id NUMBER;
1281: l_default_method po_vendor_sites_all.supplier_notif_method%TYPE;
1282: l_doc_num po_headers_all.segment1%TYPE;
1283: l_print_flag VARCHAR2(1) := 'N';
1284: --
1285:
1286: BEGIN

Line 1300: po_headers_all poh

1296: l_org_id,
1297: l_document_num,
1298: l_agent_id
1299: from po_releases_all por,
1300: po_headers_all poh
1301: where po_release_id = p_release_id
1302: and por.po_header_id=poh.po_header_id;
1303:
1304: l_Document_Type_Code := 'RELEASE';

Line 1318: from po_headers_all poh

1314: l_document_num,
1315: l_agent_id,
1316: l_document_subtype,
1317: l_org_id
1318: from po_headers_all poh
1319: where
1320: poh.po_header_id = p_header_id;
1321:
1322: if l_Document_SubType in ('BLANKET', 'CONTRACT') then

Line 1339: from po_headers_all

1335: BEGIN
1336: if (NVL(l_Document_Type_Code, 'PO') <> 'RELEASE') then
1337: select wf_item_type, wf_item_key
1338: into l_orig_itemtype, l_orig_itemkey
1339: from po_headers_all
1340: where po_header_id = l_document_id;
1341: else
1342: select wf_item_type, wf_item_key
1343: into l_orig_itemtype, l_orig_itemkey

Line 1508: from po_headers_all

1504: x_progress := '001';
1505: if (l_document_type_code <> 'RELEASE') then
1506: select revision_num
1507: into l_revision_num
1508: from po_headers_all
1509: where po_header_id = l_document_id;
1510: IsPOHeaderRejected(
1511: 1.0,
1512: l_return_status,

Line 1618: l_blanket_num po_headers_all.segment1%TYPE;

1614:
1615: l_rel_total number;
1616: l_rel_currency po_headers.currency_code%TYPE;
1617: --l_blanket_num number;
1618: l_blanket_num po_headers_all.segment1%TYPE;
1619: --l_release_num number;
1620: l_release_num po_releases_all.release_num%TYPE;
1621: l_po_doc_id number;
1622: l_rel_doc_id number;

Line 1625: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

1621: l_po_doc_id number;
1622: l_rel_doc_id number;
1623: l_acc_req_flag varchar2(1);
1624: l_document varchar2(32000);
1625: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
1626: l_document_type varchar2(2000);
1627: l_po_num po_headers_all.segment1%TYPE;
1628: l_revision_num number;
1629: l_po_total number;

Line 1627: l_po_num po_headers_all.segment1%TYPE;

1623: l_acc_req_flag varchar2(1);
1624: l_document varchar2(32000);
1625: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
1626: l_document_type varchar2(2000);
1627: l_po_num po_headers_all.segment1%TYPE;
1628: l_revision_num number;
1629: l_po_total number;
1630: l_po_currency po_headers.currency_code%TYPE;
1631: l_vendor_id number;

Line 1641: l_fob po_headers_all.fob_lookup_code%TYPE;

1637: l_sup_city po_vendor_sites_all.city%TYPE;
1638: l_sup_state po_vendor_sites_all.state%TYPE;
1639: l_sup_zip po_vendor_sites_all.zip%TYPE;
1640: l_order_date varchar2(2000);
1641: l_fob po_headers_all.fob_lookup_code%TYPE;
1642: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
1643: l_ship_to_id number;
1644: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1645: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

Line 1642: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

1638: l_sup_state po_vendor_sites_all.state%TYPE;
1639: l_sup_zip po_vendor_sites_all.zip%TYPE;
1640: l_order_date varchar2(2000);
1641: l_fob po_headers_all.fob_lookup_code%TYPE;
1642: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
1643: l_ship_to_id number;
1644: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
1645: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
1646: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

Line 1674: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

1670: lc_ship_to_location hr_locations_all.location_code%TYPE;
1671: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
1672: lc_reason po_change_requests.request_reason%TYPE;
1673: lc_split varchar2(2000);
1674: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
1675: /*Modified as part of bug 7550964 changing date format*/
1676: cursor l_po_chg_req_csr(grp_id number, l_requestor_id number) is
1677: select
1678: to_char(LINE_NUM),

Line 1911: from po_headers_all

1907: l_carrier,
1908: l_ship_to_id,
1909: l_type_lookup_code,
1910: l_global_agreement_flag
1911: from po_headers_all
1912: where po_header_id = l_header_id;
1913:
1914: if(l_type_lookup_code = 'STANDARD') then
1915: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');

Line 1958: po_headers_all ph

1954: l_carrier,
1955: l_ship_to_id,
1956: l_type_lookup_code
1957: from po_releases_all pr,
1958: po_headers_all ph
1959: where pr.po_release_id = l_release_id
1960: and pr.po_header_id = ph.po_header_id;
1961: /*Modified as part of bug 7550964 changing date format*/
1962:

Line 2447: l_blanket_num po_headers_all.segment1%TYPE;

2443:
2444: l_rel_total number;
2445: l_rel_currency po_headers.currency_code%TYPE;
2446: --l_blanket_num number;
2447: l_blanket_num po_headers_all.segment1%TYPE;
2448: --l_release_num number;
2449: l_release_num po_releases_all.release_num%TYPE;
2450: l_po_doc_id number;
2451: l_rel_doc_id number;

Line 2454: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

2450: l_po_doc_id number;
2451: l_rel_doc_id number;
2452: l_acc_req_flag varchar2(1);
2453: l_document varchar2(32000);
2454: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
2455: l_document_type varchar2(2000);
2456: l_po_num po_headers_all.segment1%TYPE;
2457: l_revision_num number;
2458: l_po_total number;

Line 2456: l_po_num po_headers_all.segment1%TYPE;

2452: l_acc_req_flag varchar2(1);
2453: l_document varchar2(32000);
2454: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
2455: l_document_type varchar2(2000);
2456: l_po_num po_headers_all.segment1%TYPE;
2457: l_revision_num number;
2458: l_po_total number;
2459: l_po_currency po_headers.currency_code%TYPE;
2460: l_vendor_id number;

Line 2470: l_fob po_headers_all.fob_lookup_code%TYPE;

2466: l_sup_city po_vendor_sites_all.city%TYPE;
2467: l_sup_state po_vendor_sites_all.state%TYPE;
2468: l_sup_zip po_vendor_sites_all.zip%TYPE;
2469: l_order_date varchar2(2000);
2470: l_fob po_headers_all.fob_lookup_code%TYPE;
2471: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
2472: l_ship_to_id number;
2473: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2474: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

Line 2471: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

2467: l_sup_state po_vendor_sites_all.state%TYPE;
2468: l_sup_zip po_vendor_sites_all.zip%TYPE;
2469: l_order_date varchar2(2000);
2470: l_fob po_headers_all.fob_lookup_code%TYPE;
2471: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
2472: l_ship_to_id number;
2473: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
2474: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
2475: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

Line 2504: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

2500: lc_ship_to_location hr_locations_all.location_code%TYPE;
2501: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
2502: lc_reason po_change_requests.request_reason%TYPE;
2503: lc_split varchar2(2000);
2504: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
2505: /*Modified as part of bug 7550964 changing date format*/
2506: cursor l_po_chg_req_csr(grp_id number, l_planner_id number) is
2507: select
2508: distinct

Line 2749: from po_headers_all

2745: l_carrier,
2746: l_ship_to_id,
2747: l_type_lookup_code,
2748: l_global_agreement_flag
2749: from po_headers_all
2750: where po_header_id = l_header_id;
2751:
2752: if(l_type_lookup_code = 'STANDARD') then
2753: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');

Line 2796: po_headers_all ph

2792: l_carrier,
2793: l_ship_to_id,
2794: l_type_lookup_code
2795: from po_releases_all pr,
2796: po_headers_all ph
2797: where pr.po_release_id = l_release_id
2798: and pr.po_header_id = ph.po_header_id;
2799:
2800: if(l_type_lookup_code = 'BLANKET') then

Line 3274: l_blanket_num po_headers_all.segment1%TYPE;

3270: l_grp_id number;
3271: l_rel_total number;
3272: l_rel_currency po_headers.currency_code%TYPE;
3273: --l_blanket_num number;
3274: l_blanket_num po_headers_all.segment1%TYPE;
3275: --l_release_num number;
3276: l_release_num po_releases_all.release_num%TYPE;
3277: l_po_doc_id number;
3278: l_rel_doc_id number;

Line 3281: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

3277: l_po_doc_id number;
3278: l_rel_doc_id number;
3279: l_acc_req_flag varchar2(1);
3280: l_document varchar2(32000);
3281: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
3282: l_document_type varchar2(2000);
3283: l_po_num po_headers_all.segment1%TYPE;
3284: l_revision_num number;
3285: l_po_total number;

Line 3283: l_po_num po_headers_all.segment1%TYPE;

3279: l_acc_req_flag varchar2(1);
3280: l_document varchar2(32000);
3281: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
3282: l_document_type varchar2(2000);
3283: l_po_num po_headers_all.segment1%TYPE;
3284: l_revision_num number;
3285: l_po_total number;
3286: l_po_currency po_headers.currency_code%TYPE;
3287: l_vendor_id number;

Line 3297: l_fob po_headers_all.fob_lookup_code%TYPE;

3293: l_sup_city po_vendor_sites_all.city%TYPE;
3294: l_sup_state po_vendor_sites_all.state%TYPE;
3295: l_sup_zip po_vendor_sites_all.zip%TYPE;
3296: l_order_date varchar2(2000);
3297: l_fob po_headers_all.fob_lookup_code%TYPE;
3298: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3299: l_ship_to_id number;
3300: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3301: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

Line 3298: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

3294: l_sup_state po_vendor_sites_all.state%TYPE;
3295: l_sup_zip po_vendor_sites_all.zip%TYPE;
3296: l_order_date varchar2(2000);
3297: l_fob po_headers_all.fob_lookup_code%TYPE;
3298: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3299: l_ship_to_id number;
3300: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
3301: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
3302: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

Line 3332: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE;

3328: lc_ship_to_location hr_locations_all.location_code%TYPE;
3329: lc_action_code po_change_requests.ACTION_TYPE%TYPE;
3330: lc_reason po_change_requests.request_reason%TYPE;
3331: lc_split varchar2(2000);
3332: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE;
3333: l_po_rev number;
3334: l_rel_rev number;
3335:
3336: cursor l_po_chg_req_csr(grp_id number) is

Line 3667: from po_headers_all

3663: l_carrier,
3664: l_ship_to_id,
3665: l_type_lookup_code,
3666: l_global_agreement_flag
3667: from po_headers_all
3668: where po_header_id = l_header_id;
3669:
3670: if(l_type_lookup_code = 'STANDARD') then
3671: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');

Line 3719: po_headers_all ph

3715: l_carrier,
3716: l_ship_to_id,
3717: l_type_lookup_code
3718: from po_releases_all pr,
3719: po_headers_all ph
3720: where pr.po_release_id = l_release_id
3721: and pr.po_header_id = ph.po_header_id;
3722:
3723: if(l_type_lookup_code = 'BLANKET') then

Line 4349: l_blanket_num po_headers_all.segment1%TYPE;

4345: l_po_release_id number;
4346: l_rel_total number;
4347: l_rel_currency po_headers.currency_code%TYPE;
4348: --l_blanket_num number;
4349: l_blanket_num po_headers_all.segment1%TYPE;
4350: --l_release_num number;
4351: l_release_num po_releases_all.release_num%TYPE;
4352: l_document varchar2(32000);
4353: l_document_header_id number;

Line 4355: l_po_num po_headers_all.segment1%TYPE;

4351: l_release_num po_releases_all.release_num%TYPE;
4352: l_document varchar2(32000);
4353: l_document_header_id number;
4354: l_document_type varchar2(2000);
4355: l_po_num po_headers_all.segment1%TYPE;
4356: l_revision_num number;
4357: l_po_total number;
4358: l_po_currency po_headers.currency_code%TYPE;
4359: l_vendor_id number;

Line 4369: l_fob po_headers_all.fob_lookup_code%TYPE;

4365: l_sup_city po_vendor_sites_all.city%TYPE;
4366: l_sup_state po_vendor_sites_all.state%TYPE;
4367: l_sup_zip po_vendor_sites_all.zip%TYPE;
4368: l_order_date varchar2(2000);
4369: l_fob po_headers_all.fob_lookup_code%TYPE;
4370: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
4371: l_ship_to_id number;
4372: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4373: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;

Line 4370: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

4366: l_sup_state po_vendor_sites_all.state%TYPE;
4367: l_sup_zip po_vendor_sites_all.zip%TYPE;
4368: l_order_date varchar2(2000);
4369: l_fob po_headers_all.fob_lookup_code%TYPE;
4370: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
4371: l_ship_to_id number;
4372: l_ship_addr_l1 hr_locations_all.address_line_1%TYPE;
4373: l_ship_addr_l2 hr_locations_all.address_line_2%TYPE;
4374: l_ship_addr_l3 hr_locations_all.address_line_3%TYPE;

Line 4383: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

4379: l_base_url varchar2(2000);
4380: l_base_url_tag varchar2(2000);
4381:
4382: l_document1 VARCHAR2(32000) := '';
4383: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
4384: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
4385:
4386: l_old_prom_date varchar2(2000);
4387: l_new_prom_date varchar2(2000);

Line 4384: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

4380: l_base_url_tag varchar2(2000);
4381:
4382: l_document1 VARCHAR2(32000) := '';
4383: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
4384: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
4385:
4386: l_old_prom_date varchar2(2000);
4387: l_new_prom_date varchar2(2000);
4388:

Line 4605: from po_headers_all

4601: l_carrier,
4602: l_ship_to_id,
4603: l_type_lookup_code,
4604: l_global_agreement_flag
4605: from po_headers_all
4606: where po_header_id = l_document_header_id;
4607: else
4608: select ph.segment1,
4609: pr.release_num,

Line 4636: po_headers_all ph

4632: l_ship_to_id,
4633: l_type_lookup_code,
4634: l_global_agreement_flag
4635: from po_releases_all pr,
4636: po_headers_all ph
4637: where pr.po_release_id = l_po_release_id
4638: and pr.po_header_id = ph.po_header_id;
4639: end if;
4640: l_progress := '002';

Line 5117: l_po_num po_headers_all.segment1%TYPE;

5113: document IN OUT nocopy VARCHAR2,
5114: document_type IN OUT nocopy VARCHAR2)
5115: IS
5116:
5117: l_po_num po_headers_all.segment1%TYPE;
5118: l_supplier_name po_vendors.vendor_name%TYPE;
5119: l_blanket_num po_headers_all.segment1%TYPE;
5120: --l_release_num number;
5121: l_release_num po_releases_all.release_num%TYPE;

Line 5119: l_blanket_num po_headers_all.segment1%TYPE;

5115: IS
5116:
5117: l_po_num po_headers_all.segment1%TYPE;
5118: l_supplier_name po_vendors.vendor_name%TYPE;
5119: l_blanket_num po_headers_all.segment1%TYPE;
5120: --l_release_num number;
5121: l_release_num po_releases_all.release_num%TYPE;
5122: l_document_header_info varchar2(2000);
5123: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

Line 5123: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

5119: l_blanket_num po_headers_all.segment1%TYPE;
5120: --l_release_num number;
5121: l_release_num po_releases_all.release_num%TYPE;
5122: l_document_header_info varchar2(2000);
5123: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5124: l_global_agreement_flag varchar2(3);
5125: l_header_cancel varchar2(1);
5126: l_id NUMBER;
5127: l_revision_num NUMBER; -- RDP changes

Line 5217: po_headers_all pha,

5213: l_po_total,
5214: l_currency_code,
5215: l_display_name
5216: from
5217: po_headers_all pha,
5218: po_vendors pv,
5219: PO_ALL_DOC_STYLE_LINES PDSL
5220: where pha.po_header_id = l_header_id
5221: and pha.vendor_id = pv.vendor_id

Line 5283: po_headers_all pha,

5279: l_rel_total,
5280: l_rel_currency_code
5281: from
5282: po_releases_all pra,
5283: po_headers_all pha,
5284: po_vendors pv
5285: where pra.po_release_id = l_release_id
5286: and pra.po_header_id = pha.po_header_id
5287: and pha.vendor_id = pv.vendor_id;

Line 5343: l_po_num po_headers_all.segment1%TYPE;

5339: document IN OUT nocopy VARCHAR2,
5340: document_type IN OUT nocopy VARCHAR2)
5341: IS
5342:
5343: l_po_num po_headers_all.segment1%TYPE;
5344: l_blanket_num po_headers_all.segment1%TYPE;
5345: --l_release_num number;
5346: l_release_num po_releases_all.release_num%TYPE;
5347: l_buyer_name hr_all_organization_units_tl.name%TYPE;

Line 5344: l_blanket_num po_headers_all.segment1%TYPE;

5340: document_type IN OUT nocopy VARCHAR2)
5341: IS
5342:
5343: l_po_num po_headers_all.segment1%TYPE;
5344: l_blanket_num po_headers_all.segment1%TYPE;
5345: --l_release_num number;
5346: l_release_num po_releases_all.release_num%TYPE;
5347: l_buyer_name hr_all_organization_units_tl.name%TYPE;
5348: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

Line 5348: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

5344: l_blanket_num po_headers_all.segment1%TYPE;
5345: --l_release_num number;
5346: l_release_num po_releases_all.release_num%TYPE;
5347: l_buyer_name hr_all_organization_units_tl.name%TYPE;
5348: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5349: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
5350: l_doc_hdr_info varchar2(2000);
5351:
5352: l_id number;

Line 5349: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

5345: --l_release_num number;
5346: l_release_num po_releases_all.release_num%TYPE;
5347: l_buyer_name hr_all_organization_units_tl.name%TYPE;
5348: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5349: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
5350: l_doc_hdr_info varchar2(2000);
5351:
5352: l_id number;
5353: l_header_cancel varchar2(1);

Line 5421: from po_headers_all pha,

5417: l_buyer_name,
5418: l_type_lookup_code,
5419: l_global_agreement_flag,
5420: l_display_name
5421: from po_headers_all pha,
5422: hr_all_organization_units_tl hou,
5423: PO_ALL_DOC_STYLE_LINES PDSL
5424: where pha.po_header_id = l_header_id
5425: and pha.org_id = hou.organization_id(+)

Line 5464: from po_headers_all pha,

5460: into l_blanket_num,
5461: l_release_num,
5462: l_buyer_name,
5463: l_type_lookup_code
5464: from po_headers_all pha,
5465: po_releases_all pra,
5466: hr_all_organization_units_tl hou
5467: where pra.po_release_id = l_release_id
5468: and pha.po_header_id = pra.po_header_id

Line 5529: l_po_num po_headers_all.segment1%TYPE;

5525: document IN OUT nocopy VARCHAR2,
5526: document_type IN OUT nocopy VARCHAR2)
5527: IS
5528:
5529: l_po_num po_headers_all.segment1%TYPE;
5530: l_blanket_num po_headers_all.segment1%TYPE;
5531: --l_release_num number;
5532: l_release_num po_releases_all.release_num%TYPE;
5533: l_supplier_name po_vendors.vendor_name%TYPE;

Line 5530: l_blanket_num po_headers_all.segment1%TYPE;

5526: document_type IN OUT nocopy VARCHAR2)
5527: IS
5528:
5529: l_po_num po_headers_all.segment1%TYPE;
5530: l_blanket_num po_headers_all.segment1%TYPE;
5531: --l_release_num number;
5532: l_release_num po_releases_all.release_num%TYPE;
5533: l_supplier_name po_vendors.vendor_name%TYPE;
5534: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

Line 5534: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

5530: l_blanket_num po_headers_all.segment1%TYPE;
5531: --l_release_num number;
5532: l_release_num po_releases_all.release_num%TYPE;
5533: l_supplier_name po_vendors.vendor_name%TYPE;
5534: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5535: l_document_header_info varchar2(2000);
5536:
5537: l_id number;
5538: l_header_cancel varchar2(1);

Line 5553: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

5549: l_release_id NUMBER;
5550: l_chg_req_grp_id NUMBER;
5551:
5552: l_message_name fnd_new_messages.message_name%TYPE;
5553: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
5554: l_display_name varchar2(1000);
5555: l_msg_header varchar2(1000);
5556:
5557:

Line 5589: from po_headers_all pha,

5585: l_po_num,
5586: l_supplier_name,
5587: l_global_agreement_flag,
5588: l_display_name
5589: from po_headers_all pha,
5590: po_vendors pv,
5591: PO_ALL_DOC_STYLE_LINES PDSL
5592: where pha.po_header_id = l_header_id
5593: and pv.vendor_id = pha.vendor_id

Line 5629: from po_headers_all pha,

5625: into l_type_lookup_code,
5626: l_blanket_num,
5627: l_release_num,
5628: l_supplier_name
5629: from po_headers_all pha,
5630: po_releases_all pra,
5631: po_vendors pv
5632: where pra.po_release_id = l_release_id
5633: and pra.po_header_id = pha.po_header_id

Line 5686: l_po_num po_headers_all.segment1%TYPE;

5682: document IN OUT nocopy VARCHAR2,
5683: document_type IN OUT nocopy VARCHAR2)
5684: IS
5685:
5686: l_po_num po_headers_all.segment1%TYPE;
5687: l_blanket_num po_headers_all.segment1%TYPE;
5688: --l_release_num number;
5689: l_release_num po_releases_all.release_num%TYPE;
5690: l_supplier_name po_vendors.vendor_name%TYPE;

Line 5687: l_blanket_num po_headers_all.segment1%TYPE;

5683: document_type IN OUT nocopy VARCHAR2)
5684: IS
5685:
5686: l_po_num po_headers_all.segment1%TYPE;
5687: l_blanket_num po_headers_all.segment1%TYPE;
5688: --l_release_num number;
5689: l_release_num po_releases_all.release_num%TYPE;
5690: l_supplier_name po_vendors.vendor_name%TYPE;
5691: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

Line 5691: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

5687: l_blanket_num po_headers_all.segment1%TYPE;
5688: --l_release_num number;
5689: l_release_num po_releases_all.release_num%TYPE;
5690: l_supplier_name po_vendors.vendor_name%TYPE;
5691: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5692: l_document_header_info varchar2(2000);
5693:
5694: l_id number;
5695: l_header_cancel varchar2(1);

Line 5710: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

5706: l_release_id NUMBER;
5707: l_chg_req_grp_id NUMBER;
5708:
5709: l_message_name fnd_new_messages.message_name%TYPE;
5710: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
5711: l_display_name varchar2(1000);
5712: l_msg_header varchar2(1000);
5713:
5714: BEGIN

Line 5745: from po_headers_all pha,

5741: l_po_num,
5742: l_supplier_name,
5743: l_global_agreement_flag,
5744: l_display_name
5745: from po_headers_all pha,
5746: po_vendors pv,
5747: PO_ALL_DOC_STYLE_LINES PDSL
5748: where pha.po_header_id = l_header_id
5749: and pv.vendor_id = pha.vendor_id

Line 5785: from po_headers_all pha,

5781: into l_type_lookup_code,
5782: l_blanket_num,
5783: l_release_num,
5784: l_supplier_name
5785: from po_headers_all pha,
5786: po_releases_all pra,
5787: po_vendors pv
5788: where pra.po_release_id = l_release_id
5789: and pra.po_header_id = pha.po_header_id

Line 5864: from po_change_requests pcr, po_headers_all poh

5860: itemkey => itemkey,
5861: aname => 'PO_HEADER_ID');
5862:
5863: select count(*) into l_retro_count
5864: from po_change_requests pcr, po_headers_all poh
5865: where poh.po_header_id = pcr.document_header_id
5866: and poh.po_header_id = l_po_header_id
5867: and poh.type_lookup_code = 'BLANKET'
5868: and pcr.change_request_group_id = l_chg_req_grp_id

Line 5934: l_authorization_status po_headers_all.authorization_status%TYPE;

5930: l_revision_num number;
5931: l_chg_req_grp_id number;
5932: l_add_changes_accepted number;
5933: l_responded_by number;
5934: l_authorization_status po_headers_all.authorization_status%TYPE;
5935: l_check_result varchar2(1);
5936:
5937: x_progress varchar2(3) := '000';
5938: BEGIN

Line 5997: update po_headers_all set

5993: where po_release_id = l_release_id;
5994:
5995: else
5996:
5997: update po_headers_all set
5998: authorization_status = 'REQUIRES REAPPROVAL',
5999: revision_num = revision_num + 1,
6000: revised_date = sysdate,
6001: last_update_date = sysdate,

Line 6022: update po_headers_all

6018: set authorization_status = l_authorization_status,
6019: change_requested_by = null
6020: where po_release_id = l_release_id;
6021: else
6022: update po_headers_all
6023: set authorization_status = l_authorization_status,
6024: change_requested_by = null
6025: where po_header_id = l_header_id;
6026: end if;

Line 6093: from po_headers_all

6089: l_header_id := l_document_id;
6090: l_release_id := null;
6091: select revision_num
6092: into l_revision_num
6093: from po_headers_all
6094: where po_header_id = l_document_id;
6095: end if;
6096: x_progress := '002';
6097: /*PO_ACKNOWLEDGE_PO_GRP.carry_over_acknowledgement(1.0,

Line 6145: from po_headers_all

6141: where po_release_id = l_document_id;
6142: else
6143: select acceptance_required_flag
6144: into l_acc_flag
6145: from po_headers_all
6146: where po_header_id = l_document_id;
6147: end if;
6148: if(l_acc_flag= 'Y') then
6149: resultout := 'Y';

Line 6175: l_authorization_status po_headers_all.authorization_status%TYPE;

6171: IS
6172: l_document_id number;
6173: p_header_id number;
6174: l_document_type po_document_types_all.document_type_code%TYPE;
6175: l_authorization_status po_headers_all.authorization_status%TYPE;
6176: l_acceptance_required_flag po_headers_all.acceptance_required_flag%TYPE; -- fix for bug 4946410
6177: l_supplier_user_id number;
6178: l_change_request_group_id number;
6179: l_supplier_username fnd_user.user_name%TYPE;

Line 6176: l_acceptance_required_flag po_headers_all.acceptance_required_flag%TYPE; -- fix for bug 4946410

6172: l_document_id number;
6173: p_header_id number;
6174: l_document_type po_document_types_all.document_type_code%TYPE;
6175: l_authorization_status po_headers_all.authorization_status%TYPE;
6176: l_acceptance_required_flag po_headers_all.acceptance_required_flag%TYPE; -- fix for bug 4946410
6177: l_supplier_user_id number;
6178: l_change_request_group_id number;
6179: l_supplier_username fnd_user.user_name%TYPE;
6180: l_blanket_num po_headers_all.segment1%TYPE;

Line 6180: l_blanket_num po_headers_all.segment1%TYPE;

6176: l_acceptance_required_flag po_headers_all.acceptance_required_flag%TYPE; -- fix for bug 4946410
6177: l_supplier_user_id number;
6178: l_change_request_group_id number;
6179: l_supplier_username fnd_user.user_name%TYPE;
6180: l_blanket_num po_headers_all.segment1%TYPE;
6181: --l_release_num number;
6182: l_release_num po_releases_all.release_num%TYPE;
6183: l_buyer_name hr_all_organization_units_tl.name%TYPE;
6184: l_po_num po_headers_all.segment1%TYPE;

Line 6184: l_po_num po_headers_all.segment1%TYPE;

6180: l_blanket_num po_headers_all.segment1%TYPE;
6181: --l_release_num number;
6182: l_release_num po_releases_all.release_num%TYPE;
6183: l_buyer_name hr_all_organization_units_tl.name%TYPE;
6184: l_po_num po_headers_all.segment1%TYPE;
6185: l_revision_num number;
6186: l_revision_num2 number;
6187: l_notification_subject varchar2(2000);
6188: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

Line 6188: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

6184: l_po_num po_headers_all.segment1%TYPE;
6185: l_revision_num number;
6186: l_revision_num2 number;
6187: l_notification_subject varchar2(2000);
6188: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
6189: l_doc_hdr_info varchar2(1000);
6190: l_buyer_agent_id number;
6191: l_responded_by_id number;
6192: l_buyer_username fnd_user.user_name%TYPE;

Line 6226: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';

6222:
6223: x_progress varchar2(100) := '000';
6224: t_varname Wf_Engine.NameTabTyp;
6225: t_varval Wf_Engine.TextTabTyp;
6226: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
6227: l_po_header_id po_headers_all.po_header_id%TYPE;
6228: l_id number;
6229: l_header_cancel varchar2(1);
6230:

Line 6227: l_po_header_id po_headers_all.po_header_id%TYPE;

6223: x_progress varchar2(100) := '000';
6224: t_varname Wf_Engine.NameTabTyp;
6225: t_varval Wf_Engine.TextTabTyp;
6226: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
6227: l_po_header_id po_headers_all.po_header_id%TYPE;
6228: l_id number;
6229: l_header_cancel varchar2(1);
6230:
6231: cursor l_header_cancel_csr(grp_id number) is

Line 6322: from po_headers_all pha,

6318: l_type_lookup_code,
6319: l_buyer_agent_id,
6320: l_vendor_id,
6321: l_acceptance_required_flag
6322: from po_headers_all pha,
6323: po_releases_all pra,
6324: hr_all_organization_units_tl hou
6325: where pra.po_release_id = l_document_id
6326: and pha.po_header_id = pra.po_header_id

Line 6422: from po_headers_all pha,

6418: l_buyer_agent_id,
6419: l_global_agreement_flag,
6420: l_vendor_id,
6421: l_acceptance_required_flag
6422: from po_headers_all pha,
6423: hr_all_organization_units_tl hou
6424: where pha.po_header_id = l_document_id
6425: and pha.org_id = hou.organization_id(+)
6426: and hou.language(+) = userenv('LANG');

Line 6470: update po_headers_all

6466: l_notification_subject := fnd_message.get;
6467: end if;
6468:
6469: /*
6470: update po_headers_all
6471: set change_requested_by = null
6472: where po_header_id = l_document_id;
6473: */
6474:

Line 6809: from po_headers_all

6805: agent_id
6806: into
6807: l_doc_subtype,
6808: l_employee_id
6809: from po_headers_all
6810: where po_header_id = l_header_id;
6811:
6812: if(l_doc_subtype = 'BLANKET' or l_doc_subtype = 'CONTRACT') then
6813: l_doc_type := 'PA';

Line 6826: from po_headers_all pha, po_releases_all pra

6822: pra.agent_id
6823: into
6824: l_doc_subtype,
6825: l_employee_id
6826: from po_headers_all pha, po_releases_all pra
6827: where pra.po_release_id = l_release_id
6828: and pra.po_header_id = pha.po_header_id;
6829: end if;
6830: x_progress := '001';

Line 7003: --l_po_num po_headers_all.segment1%TYPE;

6999: l_seq number;
7000: l_supplier_username fnd_user.user_name%TYPE;
7001: l_notification_subject varchar2(2000);
7002:
7003: --l_po_num po_headers_all.segment1%TYPE;
7004: --l_blanket_num po_headers_all.segment1%TYPE;
7005: --l_release_num number;
7006: --l_buyer_name hr_all_organization_units_tl.name%TYPE;
7007: --l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

Line 7004: --l_blanket_num po_headers_all.segment1%TYPE;

7000: l_supplier_username fnd_user.user_name%TYPE;
7001: l_notification_subject varchar2(2000);
7002:
7003: --l_po_num po_headers_all.segment1%TYPE;
7004: --l_blanket_num po_headers_all.segment1%TYPE;
7005: --l_release_num number;
7006: --l_buyer_name hr_all_organization_units_tl.name%TYPE;
7007: --l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
7008: --l_document_type varchar2(2000);

Line 7007: --l_type_lookup_code po_headers_all.type_lookup_code%TYPE;

7003: --l_po_num po_headers_all.segment1%TYPE;
7004: --l_blanket_num po_headers_all.segment1%TYPE;
7005: --l_release_num number;
7006: --l_buyer_name hr_all_organization_units_tl.name%TYPE;
7007: --l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
7008: --l_document_type varchar2(2000);
7009: l_buyer_agent_id number;
7010: l_responded_by_id number;
7011: l_buyer_username fnd_user.user_name%TYPE;

Line 7063: from po_headers_all pha

7059: l_progress := '001';
7060: if(p_release_id is null) then
7061: select pha.agent_id
7062: into l_buyer_agent_id
7063: from po_headers_all pha
7064: where pha.po_header_id = p_header_id;
7065: else
7066: select pra.agent_id
7067: into l_buyer_agent_id

Line 7315: l_authorization_status po_headers_all.authorization_status%TYPE;

7311: l_kickoff_msg varchar2(2000);
7312: l_doc_id number;
7313: l_employee_id number;
7314:
7315: l_authorization_status po_headers_all.authorization_status%TYPE;
7316: l_add_changes_accepted NUMBER;
7317:
7318: l_doc_type po_document_types_all.document_type_code%TYPE;
7319: l_doc_subtype po_document_types_all.document_subtype%TYPE;

Line 7324: l_closed_code po_headers_all.closed_code%type;

7320: l_id number;
7321: l_action po_lookup_codes.lookup_code%TYPE;
7322: l_acc_id number;
7323: l_rej_id number;
7324: l_closed_code po_headers_all.closed_code%type;
7325:
7326: cursor l_accept_csr(grp_id number) is
7327: select change_request_id
7328: from po_change_requests

Line 7364: po_headers_all pha

7360: l_agent_id,
7361: l_doc_subtype,
7362: l_closed_code
7363: from po_releases_all por,
7364: po_headers_all pha
7365: where po_release_id = p_release_id
7366: and por.po_header_id= pha.po_header_id;
7367:
7368:

Line 7381: from po_headers_all poh

7377: l_agent_id,
7378: l_org_id,
7379: l_doc_subtype,
7380: l_closed_code
7381: from po_headers_all poh
7382: where poh.po_header_id = p_header_id ;
7383:
7384: if(l_doc_subtype = 'BLANKET' or l_doc_subtype = 'CONTRACT') then
7385: l_doc_type := 'PA';

Line 7655: from po_headers_all

7651: aname => 'CHANGE_REQUEST_GROUP_ID');
7652: if(l_release_id is null) then
7653: select agent_id
7654: into l_agent_id
7655: from po_headers_all
7656: where po_header_id = l_header_id;
7657: else
7658: select agent_id
7659: into l_agent_id

Line 7795: po_headers_all poh,

7791: cursor c_getReqHdrId(p_po_header_id_csr IN NUMBER) is
7792: select distinct porh.requisition_header_id
7793: from po_requisition_headers_all porh,
7794: po_requisition_lines_all porl,
7795: po_headers_all poh,
7796: po_line_locations_all poll
7797: where porh.requisition_header_id = porl.requisition_header_id AND
7798: porl.line_location_id = poll.line_location_id AND
7799: poh.po_header_id = poll.po_header_id AND

Line 7931: from po_headers_all

7927:
7928: if(p_release_id is null) then
7929: select agent_id
7930: into l_buyer_agent_id
7931: from po_headers_all
7932: where po_headers_all.po_header_id = p_header_id;
7933: else
7934: select pra.agent_id
7935: into l_buyer_agent_id

Line 7932: where po_headers_all.po_header_id = p_header_id;

7928: if(p_release_id is null) then
7929: select agent_id
7930: into l_buyer_agent_id
7931: from po_headers_all
7932: where po_headers_all.po_header_id = p_header_id;
7933: else
7934: select pra.agent_id
7935: into l_buyer_agent_id
7936: from po_releases_all pra,

Line 7937: po_headers_all pha

7933: else
7934: select pra.agent_id
7935: into l_buyer_agent_id
7936: from po_releases_all pra,
7937: po_headers_all pha
7938: where pra.po_release_id = p_release_id
7939: and pra.po_header_id = pha.po_header_id;
7940: end if;
7941:

Line 8540: PO_HEADERS_ALL poh

8536: pcr.request_status,
8537: poh.type_lookup_code,
8538: pcr.document_num
8539: FROM PO_CHANGE_REQUESTS pcr,
8540: PO_HEADERS_ALL poh
8541: WHERE pcr.CHANGE_REQUEST_GROUP_ID = p_chg_req_grp_id_csr
8542: AND pcr.REQUEST_LEVEL = 'HEADER'
8543: AND pcr.ACTION_TYPE = 'CANCELLATION'
8544: AND pcr.document_header_id = poh.po_header_id;

Line 8553: FROM po_headers_all

8549: WHERE pcr.CHANGE_REQUEST_GROUP_ID = p_chg_req_grp_id_csr;
8550:
8551: CURSOR getRevisionNumAck(po_header_id_csr IN NUMBER) IS
8552: SELECT revision_num
8553: FROM po_headers_all
8554: WHERE po_header_id = po_header_id_csr;
8555:
8556: CURSOR getRevisionNumAckRel(po_header_id_csr IN NUMBER,po_release_id_csr IN NUMBER) IS
8557: SELECT pora.revision_num