APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_RELEASES_ALL

Line 591: from po_releases_all

587: where po_header_id=p_po_header_id;
588: else
589: select nvl(authorization_status, 'IN PROCESS')
590: into l_doc_status
591: from po_releases_all
592: where po_release_id=p_po_release_id;
593: end if;
594:
595: x_progress :='PO_ReqChangeRequestWF_PVT.ValidateAndSaveRequest:001';

Line 1146: po_releases_all por

1142: po_headers_all poh,
1143: po_lines_all pol,
1144: po_line_locations_all pll,
1145: po_distributions_all pod,
1146: po_releases_all por
1147: where pcr.change_request_group_id=p_change_request_group_id
1148: and pcr.request_status='PENDING'
1149: and pcr.parent_change_request_id is not null
1150: and pcr.document_header_id=poh.po_header_id

Line 1399: from po_releases_all

1395: x_progress :='002';
1396: else
1397: select nvl(authorization_status, 'IN PROCESS'), revision_num
1398: into l_doc_status, ll_document_revision_num
1399: from po_releases_all
1400: where po_release_id=ll_po_release_id;
1401: x_progress :='003';
1402: end if;
1403:

Line 1902: update po_releases_all

1898: update po_headers_all
1899: set AUTHORIZATION_STATUS = 'APPROVED'
1900: where po_header_id = l_document_id;
1901: elsif l_document_type = 'RELEASE' THEN
1902: update po_releases_all
1903: set AUTHORIZATION_STATUS = 'APPROVED'
1904: WHERE po_release_id = l_release_id;
1905: end if;
1906: -- Bug 6936399 end

Line 1996: update po_releases_all

1992: else
1993: l_document_subtype := 'BLANKET';
1994: l_document_type:= 'RELEASE';
1995:
1996: update po_releases_all
1997: set AUTHORIZATION_STATUS = 'APPROVED',
1998: approved_flag='Y',
1999: CHANGE_REQUESTED_BY=null,
2000: last_updated_by = fnd_global.user_id,

Line 2119: update po_releases_all set

2115: else
2116: -- fix bug 2733373. when change is submitted, and wait
2117: -- for buyer's response, we just set the status to
2118: -- 'IN PROCESS', but not the approved_flag
2119: update po_releases_all set
2120: AUTHORIZATION_STATUS = 'IN PROCESS',
2121: -- approved_flag='N',
2122: CHANGE_REQUESTED_BY='REQUESTER',
2123: last_updated_by = fnd_global.user_id,

Line 3093: po_releases_all por,

3089: from po_change_requests pcr,
3090: po_line_locations_all pll,
3091: po_requisition_lines_all prl,
3092: po_headers_all poh,
3093: po_releases_all por,
3094: po_lines_all pol
3095: where pcr.change_request_group_id=l_change_request_group_id
3096: and pcr.request_status='MGR_APP'
3097: and pcr.document_distribution_id is null

Line 3149: po_releases_all por,

3145: from po_change_requests pcr,
3146: po_line_locations_all pll,
3147: po_requisition_lines_all prl,
3148: po_headers_all poh,
3149: po_releases_all por,
3150: po_lines_all pol
3151: where pcr.change_request_group_id=l_change_request_group_id
3152: and pcr.request_status='MGR_APP'
3153: and pcr.document_distribution_id is null

Line 3212: po_releases_all por,

3208: from po_change_requests pcr,
3209: po_line_locations_all pll,
3210: po_requisition_lines_all prl,
3211: po_headers_all poh,
3212: po_releases_all por,
3213: po_distributions_all pod,
3214: po_req_distributions_all prd,
3215: po_lines_all pol
3216: where pcr.change_request_group_id=l_change_request_group_id

Line 3858: from PO_RELEASES_ALL

3854: x_progress := '004';
3855:
3856: select revision_num
3857: into l_revision_num
3858: from PO_RELEASES_ALL
3859: where po_release_id = p_doc_id;
3860:
3861: END IF;
3862:

Line 4116: update po_releases_all set

4112:
4113: -- fix bug 2733373. when change is submitted, and wait
4114: -- for buyer's response, we just set the status to
4115: -- 'IN PROCESS', but not the approved_flag
4116: update po_releases_all set
4117: AUTHORIZATION_STATUS = 'IN PROCESS',
4118: -- approved_flag='N',
4119: CHANGE_REQUESTED_BY='REQUESTER',
4120: last_updated_by = fnd_global.user_id,

Line 4556: from po_releases_all por, po_headers_all poh

4552: l_document_type_disp := fnd_message.get;
4553:
4554: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num)
4555: into l_org_id, l_agent_id, l_document_num
4556: from po_releases_all por, po_headers_all poh
4557: where por.po_release_id=l_document_id
4558: and por.po_header_id=poh.po_header_id;
4559: else
4560: l_document_subtype:='STANDARD';

Line 4897: update po_releases_all

4893: last_update_login = fnd_global.login_id,
4894: last_update_date = sysdate
4895: where po_header_id = p_document_id;
4896: else
4897: update po_releases_all
4898: set change_requested_by = null,
4899: last_updated_by = fnd_global.user_id,
4900: last_update_login = fnd_global.login_id,
4901: last_update_date = sysdate

Line 5195: from po_releases_all

5191: where requisition_header_id=l_doc_id;
5192: else
5193: select agent_id
5194: into l_employee_id
5195: from po_releases_all
5196: where po_release_id=l_doc_id;
5197: end if;
5198: end if;
5199:

Line 6678: from po_releases_all

6674: ELSIF l_doc_type = 'RELEASE' THEN
6675:
6676: select AUTHORIZATION_STATUS
6677: into l_authorization_status
6678: from po_releases_all
6679: where PO_RELEASE_ID = l_doc_id;
6680: end if;
6681:
6682:

Line 6858: from po_releases_all

6854: where po_header_id=l_doc_id;
6855: ELSIF l_doc_type = 'RELEASE' THEN
6856: select revision_num
6857: into l_doc_revision
6858: from po_releases_all
6859: where po_release_id=l_doc_id;
6860: end if;
6861:
6862: if(nvl(l_old_doc_revision, -1)=nvl(l_doc_revision, -1)) then

Line 7209: from po_releases_all

7205: ELSIF l_doc_type = 'RELEASE' THEN
7206:
7207: select agent_id
7208: into l_employee_id
7209: from po_releases_all
7210: where PO_RELEASE_ID = l_doc_id;
7211: end if;
7212:
7213: -- Bug 9685961

Line 7698: UPDATE po_releases_all

7694: close document_id_rejected;
7695: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF:05';
7696:
7697: IF(l_release_id is not null) THEN
7698: UPDATE po_releases_all
7699: SET authorization_status='APPROVED'
7700: WHERE po_release_id = l_release_id;
7701: ELSE
7702: UPDATE po_headers_all

Line 8514: from po_releases_all por, po_headers_all poh

8510: l_document_type_disp := fnd_message.get;
8511:
8512: select por.org_id, por.agent_id, poh.segment1||'-'||to_char(por.release_num), por.REVISION_NUM
8513: into l_org_id, l_buyer_id, l_document_num, l_document_revision
8514: from po_releases_all por, po_headers_all poh
8515: where por.po_release_id=l_document_id
8516: and por.po_header_id=poh.po_header_id;
8517:
8518: END IF;

Line 10011: from po_releases_all pr, po_headers_all ph

10007: ELSIF l_doc_type = 'RELEASE' THEN
10008:
10009: select pr.creation_date, ph.currency_code
10010: into l_order_date, l_po_currency
10011: from po_releases_all pr, po_headers_all ph
10012: where pr.po_release_id = l_doc_id
10013: and pr.po_header_id = ph.po_header_id;
10014:
10015: END IF;

Line 10367: po_releases_all por,

10363:
10364: SELECT por.document_creation_method, por.org_id
10365: INTO l_creation_method, l_po_org_id
10366: FROM
10367: po_releases_all por,
10368: po_change_requests pcr
10369: WHERE por.po_release_id = pcr.po_release_id
10370: AND pcr.change_request_group_id = l_po_chg_group_id
10371: AND rownum = 1;

Line 10572: FROM po_releases_all

10568: ELSIF l_document_type = 'RELEASE' THEN
10569:
10570: SELECT agent_id, creation_date
10571: INTO l_buyer_id, l_order_date
10572: FROM po_releases_all
10573: WHERE PO_RELEASE_ID = l_document_id;
10574:
10575: END IF;
10576:

Line 10718: FROM po_releases_all pr, po_headers_all ph

10714: ELSIF l_po_doc_type = 'RELEASE' THEN
10715:
10716: SELECT ph.currency_code
10717: INTO l_po_currency
10718: FROM po_releases_all pr, po_headers_all ph
10719: WHERE pr.po_release_id = l_po_doc_id
10720: and pr.po_header_id = ph.po_header_id;
10721:
10722: END IF;

Line 11208: from po_headers_all poh, po_releases_all pr

11204: -- For releases, the current doc header id is the release id
11205: if (l_po_doc_type = 'RELEASE') then
11206: select poh.currency_code, poh.org_id
11207: into l_po_currency_code, l_org_id
11208: from po_headers_all poh, po_releases_all pr
11209: where pr.po_release_id = l_poheader_id
11210: and poh.po_header_id = pr.po_header_id;
11211: else
11212: select poh.currency_code, poh.org_id