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_ALL

Line 345: from PO_RELEASES_ALL

341: x_progress := '004';
342:
343: select revision_num
344: into l_revision_num
345: from PO_RELEASES_ALL
346: where po_release_id = p_doc_id;
347:
348: END IF;
349:

Line 468: update po_releases_all

464: l_api_name varchar2(50) :='Update_Chg_Req_If_Po_Apprvd';
465: Begin
466:
467: IF (p_release_id is not null) THEN
468: update po_releases_all
469: set change_requested_by = null
470: where po_release_id = p_release_id;
471: ELSE
472: update po_headers_all

Line 522: update po_releases_all

518: update po_headers_all
519: set authorization_status = 'APPROVED'
520: where po_header_id = p_can_hdr_id;
521: else
522: update po_releases_all
523: set authorization_status = 'APPROVED'
524: where po_release_id = p_can_rel_id;
525: end if;
526: commit;

Line 566: from po_releases_all

562: where po_header_id = p_can_hdr_id;
563: else
564: if(p_can_line_loc_id is null) then
565: select cancel_flag into l_cancel_flag
566: from po_releases_all
567: where po_release_id = p_can_rel_id;
568: else
569: select cancel_flag into l_cancel_flag
570: from po_line_locations_all

Line 574: update po_releases_all

570: from po_line_locations_all
571: where line_location_id = p_can_line_loc_id;
572: end if;
573:
574: update po_releases_all
575: set authorization_status = 'IN PROCESS'
576: where po_release_id = p_can_rel_id;
577: end if;
578: commit;

Line 596: update po_releases_all

592: update po_headers_all
593: set authorization_status = 'IN PROCESS'
594: where po_header_id = p_can_hdr_id;
595: else
596: update po_releases_all
597: set authorization_status = 'IN PROCESS'
598: where po_release_id = p_can_rel_id;
599: end if;
600: commit;

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

952: -- End of Bug 2850566 RBAIRRAJ
953:
954: -- Reset the Acceptance required Flag
955: --Bug 6772960 - Start
956: --Update the last update date when po_headers_all/po_releases_all tables are updated.
957: if l_po_release_id is not null then
958: update po_releases
959: set acceptance_required_flag = 'N',
960: LAST_UPDATE_DATE = SYSDATE,

Line 1192: from po_releases_all por,

1188: into l_Document_SubType,
1189: l_org_id,
1190: l_document_num,
1191: l_agent_id
1192: from po_releases_all por,
1193: po_headers_all poh
1194: where po_release_id = p_release_id
1195: and por.po_header_id=poh.po_header_id;
1196:

Line 1237: from po_releases_all

1233: where po_header_id = l_document_id;
1234: else
1235: select wf_item_type, wf_item_key
1236: into l_orig_itemtype, l_orig_itemkey
1237: from po_releases_all
1238: where po_release_id = l_document_id;
1239: end if;
1240:
1241: EXCEPTION

Line 1379: from po_releases_all

1375: resultout);
1376: else
1377: select revision_num
1378: into l_revision_num
1379: from po_releases_all
1380: where po_release_id = l_document_id;
1381: IsPOHeaderRejected(
1382: 1.0,
1383: l_return_status,

Line 1479: l_release_num po_releases_all.release_num%TYPE;

1475: l_rel_currency po_headers.currency_code%TYPE;
1476: --l_blanket_num number;
1477: l_blanket_num po_headers_all.segment1%TYPE;
1478: --l_release_num number;
1479: l_release_num po_releases_all.release_num%TYPE;
1480: l_po_doc_id number;
1481: l_rel_doc_id number;
1482: l_acc_req_flag varchar2(1);
1483: l_document varchar2(32000);

Line 1810: from po_releases_all pr,

1806: l_fob,
1807: l_carrier,
1808: l_ship_to_id,
1809: l_type_lookup_code
1810: from po_releases_all pr,
1811: po_headers_all ph
1812: where pr.po_release_id = l_release_id
1813: and pr.po_header_id = ph.po_header_id;
1814:

Line 2301: l_release_num po_releases_all.release_num%TYPE;

2297: l_rel_currency po_headers.currency_code%TYPE;
2298: --l_blanket_num number;
2299: l_blanket_num po_headers_all.segment1%TYPE;
2300: --l_release_num number;
2301: l_release_num po_releases_all.release_num%TYPE;
2302: l_po_doc_id number;
2303: l_rel_doc_id number;
2304: l_acc_req_flag varchar2(1);
2305: l_document varchar2(32000);

Line 2643: from po_releases_all pr,

2639: l_fob,
2640: l_carrier,
2641: l_ship_to_id,
2642: l_type_lookup_code
2643: from po_releases_all pr,
2644: po_headers_all ph
2645: where pr.po_release_id = l_release_id
2646: and pr.po_header_id = ph.po_header_id;
2647:

Line 3124: l_release_num po_releases_all.release_num%TYPE;

3120: l_rel_currency po_headers.currency_code%TYPE;
3121: --l_blanket_num number;
3122: l_blanket_num po_headers_all.segment1%TYPE;
3123: --l_release_num number;
3124: l_release_num po_releases_all.release_num%TYPE;
3125: l_po_doc_id number;
3126: l_rel_doc_id number;
3127: l_acc_req_flag varchar2(1);
3128: l_document varchar2(32000);

Line 3566: from po_releases_all pr,

3562: l_fob,
3563: l_carrier,
3564: l_ship_to_id,
3565: l_type_lookup_code
3566: from po_releases_all pr,
3567: po_headers_all ph
3568: where pr.po_release_id = l_release_id
3569: and pr.po_header_id = ph.po_header_id;
3570:

Line 4199: l_release_num po_releases_all.release_num%TYPE;

4195: l_rel_currency po_headers.currency_code%TYPE;
4196: --l_blanket_num number;
4197: l_blanket_num po_headers_all.segment1%TYPE;
4198: --l_release_num number;
4199: l_release_num po_releases_all.release_num%TYPE;
4200: l_document varchar2(32000);
4201: l_document_header_id number;
4202: l_document_type varchar2(2000);
4203: l_po_num po_headers_all.segment1%TYPE;

Line 4483: from po_releases_all pr,

4479: l_carrier,
4480: l_ship_to_id,
4481: l_type_lookup_code,
4482: l_global_agreement_flag
4483: from po_releases_all pr,
4484: po_headers_all ph
4485: where pr.po_release_id = l_po_release_id
4486: and pr.po_header_id = ph.po_header_id;
4487: end if;

Line 4969: l_release_num po_releases_all.release_num%TYPE;

4965: l_po_num po_headers_all.segment1%TYPE;
4966: l_supplier_name po_vendors.vendor_name%TYPE;
4967: l_blanket_num po_headers_all.segment1%TYPE;
4968: --l_release_num number;
4969: l_release_num po_releases_all.release_num%TYPE;
4970: l_document_header_info varchar2(2000);
4971: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
4972: l_global_agreement_flag varchar2(3);
4973: l_header_cancel varchar2(1);

Line 5130: po_releases_all pra,

5126: l_rel_revision_num,
5127: l_rel_total,
5128: l_rel_currency_code
5129: from
5130: po_releases_all pra,
5131: po_headers_all pha,
5132: po_vendors pv
5133: where pra.po_release_id = l_release_id
5134: and pra.po_header_id = pha.po_header_id

Line 5194: l_release_num po_releases_all.release_num%TYPE;

5190:
5191: l_po_num po_headers_all.segment1%TYPE;
5192: l_blanket_num po_headers_all.segment1%TYPE;
5193: --l_release_num number;
5194: l_release_num po_releases_all.release_num%TYPE;
5195: l_buyer_name hr_all_organization_units_tl.name%TYPE;
5196: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5197: l_global_agreement_flag po_headers_all.GLOBAL_AGREEMENT_FLAG%TYPE := 'F';
5198: l_doc_hdr_info varchar2(2000);

Line 5311: po_releases_all pra,

5307: l_release_num,
5308: l_buyer_name,
5309: l_type_lookup_code
5310: from po_headers_all pha,
5311: po_releases_all pra,
5312: hr_all_organization_units_tl hou
5313: where pra.po_release_id = l_release_id
5314: and pha.po_header_id = pra.po_header_id
5315: and pha.org_id = hou.organization_id(+)

Line 5378: l_release_num po_releases_all.release_num%TYPE;

5374:
5375: l_po_num po_headers_all.segment1%TYPE;
5376: l_blanket_num po_headers_all.segment1%TYPE;
5377: --l_release_num number;
5378: l_release_num po_releases_all.release_num%TYPE;
5379: l_supplier_name po_vendors.vendor_name%TYPE;
5380: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5381: l_document_header_info varchar2(2000);
5382:

Line 5476: po_releases_all pra,

5472: l_blanket_num,
5473: l_release_num,
5474: l_supplier_name
5475: from po_headers_all pha,
5476: po_releases_all pra,
5477: po_vendors pv
5478: where pra.po_release_id = l_release_id
5479: and pra.po_header_id = pha.po_header_id
5480: and pv.vendor_id = pha.vendor_id;

Line 5535: l_release_num po_releases_all.release_num%TYPE;

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

Line 5632: po_releases_all pra,

5628: l_blanket_num,
5629: l_release_num,
5630: l_supplier_name
5631: from po_headers_all pha,
5632: po_releases_all pra,
5633: po_vendors pv
5634: where pra.po_release_id = l_release_id
5635: and pra.po_header_id = pha.po_header_id
5636: and pv.vendor_id = pha.vendor_id;

Line 5831: update po_releases_all set

5827: end if;
5828:
5829: if(l_release_id is not null) then
5830:
5831: update po_releases_all set
5832: authorization_status = 'REQUIRES REAPPROVAL',
5833: revision_num = revision_num + 1,
5834: revised_date = sysdate,
5835: last_update_date = sysdate,

Line 5863: update po_releases_all

5859: set change_active_flag = 'N'
5860: where change_request_group_id = l_chg_req_grp_id;
5861:
5862: if(l_release_id is not null) then
5863: update po_releases_all
5864: set authorization_status = l_authorization_status,
5865: change_requested_by = null
5866: where po_release_id = l_release_id;
5867: else

Line 5932: from po_releases_all

5928: l_header_id := null;
5929: l_release_id := l_document_id;
5930: select revision_num
5931: into l_revision_num
5932: from po_releases_all
5933: where po_release_id = l_document_id;
5934: else
5935: l_header_id := l_document_id;
5936: l_release_id := null;

Line 5982: from po_releases_all

5978:
5979: if(l_document_type = 'RELEASE') then
5980: select acceptance_required_flag
5981: into l_acc_flag
5982: from po_releases_all
5983: where po_release_id = l_document_id;
5984: else
5985: select acceptance_required_flag
5986: into l_acc_flag

Line 6024: l_release_num po_releases_all.release_num%TYPE;

6020: l_change_request_group_id number;
6021: l_supplier_username fnd_user.user_name%TYPE;
6022: l_blanket_num po_headers_all.segment1%TYPE;
6023: --l_release_num number;
6024: l_release_num po_releases_all.release_num%TYPE;
6025: l_buyer_name hr_all_organization_units_tl.name%TYPE;
6026: l_po_num po_headers_all.segment1%TYPE;
6027: l_revision_num number;
6028: l_revision_num2 number;

Line 6165: po_releases_all pra,

6161: l_buyer_agent_id,
6162: l_vendor_id,
6163: l_acceptance_required_flag
6164: from po_headers_all pha,
6165: po_releases_all pra,
6166: hr_all_organization_units_tl hou
6167: where pra.po_release_id = l_document_id
6168: and pha.po_header_id = pra.po_header_id
6169: and pha.org_id = hou.organization_id(+)

Line 6208: update po_releases_all

6204: l_notification_subject := fnd_message.get;
6205: end if;
6206:
6207: /*
6208: update po_releases_all
6209: set change_requested_by = null
6210: where po_release_id = l_document_id;
6211: */
6212:

Line 6668: from po_headers_all pha, po_releases_all pra

6664: pra.agent_id
6665: into
6666: l_doc_subtype,
6667: l_employee_id
6668: from po_headers_all pha, po_releases_all pra
6669: where pra.po_release_id = l_release_id
6670: and pra.po_header_id = pha.po_header_id;
6671: end if;
6672: x_progress := '001';

Line 6910: from po_releases_all pra

6906: where pha.po_header_id = p_header_id;
6907: else
6908: select pra.agent_id
6909: into l_buyer_agent_id
6910: from po_releases_all pra
6911: where pra.po_release_id = p_release_id;
6912: end if;
6913:
6914: /* Commenting out for bug 3484201. Since change has already been requested by a

Line 7205: from po_releases_all por,

7201: l_org_id,
7202: l_agent_id,
7203: l_doc_subtype,
7204: l_closed_code
7205: from po_releases_all por,
7206: po_headers_all pha
7207: where po_release_id = p_release_id
7208: and por.po_header_id= pha.po_header_id;
7209:

Line 7502: from po_releases_all

7498: where po_header_id = l_header_id;
7499: else
7500: select agent_id
7501: into l_agent_id
7502: from po_releases_all
7503: where po_release_id = l_release_id;
7504: end if;
7505:
7506: l_progress := '001';

Line 7778: from po_releases_all pra,

7774: where po_headers_all.po_header_id = p_header_id;
7775: else
7776: select pra.agent_id
7777: into l_buyer_agent_id
7778: from po_releases_all pra,
7779: po_headers_all pha
7780: where pra.po_release_id = p_release_id
7781: and pra.po_header_id = pha.po_header_id;
7782: end if;

Line 8283: FROM po_releases_all pora

8279: WHERE po_header_id = po_header_id_csr;
8280:
8281: CURSOR getRevisionNumAckRel(po_header_id_csr IN NUMBER,po_release_id_csr IN NUMBER) IS
8282: SELECT pora.revision_num
8283: FROM po_releases_all pora
8284: WHERE pora.po_header_id = po_header_id_csr
8285: AND pora.po_release_id = po_release_id_csr;
8286:
8287: BEGIN