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_RELEASES

Line 367: from PO_RELEASES_ALL

363: x_progress := '004';
364:
365: select revision_num
366: into l_revision_num
367: from PO_RELEASES_ALL
368: where po_release_id = p_doc_id;
369:
370: END IF;
371:

Line 490: update po_releases_all

486: l_api_name varchar2(50) :='Update_Chg_Req_If_Po_Apprvd';
487: Begin
488:
489: IF (p_release_id is not null) THEN
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

Line 590: update po_releases_all

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
591: set authorization_status = 'APPROVED'
592: where po_release_id = p_can_rel_id;
593: end if;
594: commit;

Line 636: from po_releases_all

632: where po_header_id = p_can_hdr_id;
633: else
634: if(p_can_line_loc_id is null) then
635: select cancel_flag into l_cancel_flag
636: from po_releases_all
637: where po_release_id = p_can_rel_id;
638: else
639: select cancel_flag into l_cancel_flag
640: from po_line_locations_all

Line 644: update po_releases_all

640: from po_line_locations_all
641: where line_location_id = p_can_line_loc_id;
642: end if;
643:
644: update po_releases_all
645: set authorization_status = 'IN PROCESS'
646: where po_release_id = p_can_rel_id;
647: end if;
648: commit;

Line 666: update po_releases_all

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
667: set authorization_status = 'IN PROCESS'
668: where po_release_id = p_can_rel_id;
669: end if;
670: commit;

Line 997: from po_releases

993: into
994: l_Po_Header_Id,
995: l_revision_num,
996: l_employee_id
997: from po_releases
998: where po_release_id = l_document_id;
999: end if;
1000:
1001: -- Bug 2850566 RBAIRRAJ

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 1053: update po_releases

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,
1056: acceptance_due_date = ''
1057: where po_release_id = l_po_release_id;

Line 1145: po_releases por,

1141: else
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

Line 1299: from po_releases_all por,

1295: into l_Document_SubType,
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:

Line 1344: from po_releases_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
1344: from po_releases_all
1345: where po_release_id = l_document_id;
1346: end if;
1347:
1348: EXCEPTION

Line 1520: from po_releases_all

1516: resultout);
1517: else
1518: select revision_num
1519: into l_revision_num
1520: from po_releases_all
1521: where po_release_id = l_document_id;
1522: IsPOHeaderRejected(
1523: 1.0,
1524: l_return_status,

Line 1620: l_release_num po_releases_all.release_num%TYPE;

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;
1623: l_acc_req_flag varchar2(1);
1624: l_document varchar2(32000);

Line 1957: from po_releases_all pr,

1953: l_fob,
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*/

Line 2449: l_release_num po_releases_all.release_num%TYPE;

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;
2452: l_acc_req_flag varchar2(1);
2453: l_document varchar2(32000);

Line 2795: from po_releases_all pr,

2791: l_fob,
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:

Line 3276: l_release_num po_releases_all.release_num%TYPE;

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;
3279: l_acc_req_flag varchar2(1);
3280: l_document varchar2(32000);

Line 3718: from po_releases_all pr,

3714: l_fob,
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:

Line 4351: l_release_num po_releases_all.release_num%TYPE;

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;
4354: l_document_type varchar2(2000);
4355: l_po_num po_headers_all.segment1%TYPE;

Line 4635: from po_releases_all pr,

4631: l_carrier,
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;

Line 5121: l_release_num po_releases_all.release_num%TYPE;

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;
5124: l_global_agreement_flag varchar2(3);
5125: l_header_cancel varchar2(1);

Line 5282: po_releases_all pra,

5278: l_rel_revision_num,
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

Line 5346: l_release_num po_releases_all.release_num%TYPE;

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;
5349: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
5350: l_doc_hdr_info varchar2(2000);

Line 5465: po_releases_all pra,

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
5469: and pha.org_id = hou.organization_id(+)

Line 5532: l_release_num po_releases_all.release_num%TYPE;

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;
5535: l_document_header_info varchar2(2000);
5536:

Line 5630: po_releases_all pra,

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
5634: and pv.vendor_id = pha.vendor_id;

Line 5689: l_release_num po_releases_all.release_num%TYPE;

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;
5692: l_document_header_info varchar2(2000);
5693:

Line 5786: po_releases_all pra,

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
5790: and pv.vendor_id = pha.vendor_id;

Line 5985: update po_releases_all set

5981: end if;
5982:
5983: if(l_release_id is not null) then
5984:
5985: update po_releases_all set
5986: authorization_status = 'REQUIRES REAPPROVAL',
5987: revision_num = revision_num + 1,
5988: revised_date = sysdate,
5989: last_update_date = sysdate,

Line 6017: update po_releases_all

6013: set change_active_flag = 'N'
6014: where change_request_group_id = l_chg_req_grp_id;
6015:
6016: if(l_release_id is not null) then
6017: update po_releases_all
6018: set authorization_status = l_authorization_status,
6019: change_requested_by = null
6020: where po_release_id = l_release_id;
6021: else

Line 6086: from po_releases_all

6082: l_header_id := null;
6083: l_release_id := l_document_id;
6084: select revision_num
6085: into l_revision_num
6086: from po_releases_all
6087: where po_release_id = l_document_id;
6088: else
6089: l_header_id := l_document_id;
6090: l_release_id := null;

Line 6140: from po_releases_all

6136:
6137: if(l_document_type = 'RELEASE') then
6138: select acceptance_required_flag
6139: into l_acc_flag
6140: from po_releases_all
6141: where po_release_id = l_document_id;
6142: else
6143: select acceptance_required_flag
6144: into l_acc_flag

Line 6182: l_release_num po_releases_all.release_num%TYPE;

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;
6185: l_revision_num number;
6186: l_revision_num2 number;

Line 6323: po_releases_all pra,

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
6327: and pha.org_id = hou.organization_id(+)

Line 6332: from po_releases_archive_all

6328: and hou.language(+) = userenv('LANG');
6329:
6330: select revision_num
6331: into l_revision_num2
6332: from po_releases_archive_all
6333: where po_release_id = l_document_id
6334: and latest_external_flag='Y';
6335:
6336: l_header_cancel := 'N';

Line 6366: update po_releases_all

6362: l_notification_subject := fnd_message.get;
6363: end if;
6364:
6365: /*
6366: update po_releases_all
6367: set change_requested_by = null
6368: where po_release_id = l_document_id;
6369: */
6370:

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 7068: from po_releases_all pra

7064: where pha.po_header_id = p_header_id;
7065: else
7066: select pra.agent_id
7067: into l_buyer_agent_id
7068: from po_releases_all pra
7069: where pra.po_release_id = p_release_id;
7070: end if;
7071:
7072: /* Commenting out for bug 3484201. Since change has already been requested by a

Line 7363: from po_releases_all por,

7359: l_org_id,
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:

Line 7660: from po_releases_all

7656: where po_header_id = l_header_id;
7657: else
7658: select agent_id
7659: into l_agent_id
7660: from po_releases_all
7661: where po_release_id = l_release_id;
7662: end if;
7663:
7664: l_progress := '001';

Line 7936: from po_releases_all pra,

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,
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;

Line 8558: FROM po_releases_all pora

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
8558: FROM po_releases_all pora
8559: WHERE pora.po_header_id = po_header_id_csr
8560: AND pora.po_release_id = po_release_id_csr;
8561:
8562: BEGIN