APPS.PO_CHG_REQUEST_PVT dependencies on PO_RELEASES_ALL

Line 53: from wf_notifications a, po_releases_all por,

49: else
50: begin
51: select a.notification_id,por.wf_item_type,por.wf_item_key, a.message_name
52: INTO v_nid,l_po_item_type,l_po_item_key, l_message_name
53: from wf_notifications a, po_releases_all por,
54: wf_item_activity_statuses wa
55: where por.po_release_id = p_po_release_id and
56: por.wf_item_key = wa.item_key and
57: por.wf_item_type = wa.item_type

Line 231: from po_releases_all

227: where po_header_id = p_po_header_id;
228: else
229: select wf_item_key,wf_item_type
230: into l_po_item_key,l_po_item_type
231: from po_releases_all
232: where po_release_id = p_po_release_id;
233: end if;
234:
235: if(p_ack_reqd = 'Y') then

Line 694: FROM PO_RELEASES_ALL

690: poRec PO_CSR%ROWTYPE;
691:
692: CURSOR REL_CSR(p_po_release_id in number) IS
693: SELECT last_update_date
694: FROM PO_RELEASES_ALL
695: WHERE PO_RELEASE_ID = p_po_release_id
696: FOR UPDATE of last_update_date NOWAIT;
697:
698: relRec REL_CSR%ROWTYPE;

Line 874: from po_releases_all

870: where po_header_id = p_po_header_id;
871: else
872: select agent_id,nvl(acceptance_required_flag,'N')
873: into v_buyer_id,x_accp_flag
874: from po_releases_all
875: where po_release_id = p_po_release_id;
876: end if;
877:
878: FOR i in 1..l_po_change_requests.count()

Line 990: update po_releases_all

986: set vendor_order_num = l_po_change_requests(i).New_Supplier_Order_Number
987: where po_header_id = p_po_header_id;
988: else
989: -- Update the vendor_order_num for PO Releases no need of approval.
990: update po_releases_all
991: set vendor_order_num = l_po_change_requests(i).New_Supplier_Order_Number
992: where po_release_id = p_po_release_id;
993: end if;
994: end if;

Line 1143: update po_releases_all set

1139: l_login_id := p_login_id;
1140: end if;
1141: -- Update the last update date if po dosent require to be updated
1142: if (p_po_release_id is not null) then
1143: update po_releases_all set
1144: last_update_date = sysdate,
1145: last_updated_by = l_user_id,
1146: last_update_login = l_login_id,
1147: request_id = fnd_global.conc_request_id,

Line 1183: * Effects: Updates The PO_HEADERS_ALL, PO_RELEASES_ALL

1179: /**
1180: * Private Procedure: update_po_attributes
1181: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,REQUEST_GROUP_ID
1182: * Modifies:
1183: * Effects: Updates The PO_HEADERS_ALL, PO_RELEASES_ALL
1184: * Returns:
1185: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1186: * FND_API.G_RET_STS_ERROR if an error occurs
1187: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

Line 1287: update po_releases_all set

1283: request_status ='PENDING') ;
1284: */
1285: else
1286: -- For Releases
1287: update po_releases_all set
1288: authorization_status = 'IN PROCESS',
1289: CHANGE_REQUESTED_BY = 'SUPPLIER',
1290: revised_date = sysdate,
1291: last_update_date = sysdate,

Line 1485: from po_releases_all

1481: v_document_type := 'RELEASE';
1482: v_document_subtype := 'RELEASE';
1483: select org_id
1484: into x_org_id
1485: from po_releases_all
1486: where po_release_id= p_po_release_id;
1487: else
1488: p_document_id := p_po_header_id;
1489: select type_lookup_code , org_id

Line 2020: from po_headers_all poh,po_releases_all por

2016:
2017:
2018: select poh.type_lookup_code,por.org_id
2019: into v_type_code,x_org_id
2020: from po_headers_all poh,po_releases_all por
2021: where por.po_header_id = poh.po_header_id and
2022: por.po_release_id = p_po_release_id;
2023:
2024: if (v_type_code = 'BLANKET') then

Line 2275: po_releases_all por,

2271: pll.po_header_id, p_po_release_id,p_revision_num),nvl(por.acceptance_required_flag,'N'),
2272: por.revision_num,nvl(pll.consigned_flag,'N')
2273: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2274: from po_line_locations_all pll,
2275: po_releases_all por,
2276: po_lookup_codes polc
2277: where
2278: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and
2279: polc.lookup_type = 'DOCUMENT STATE' and

Line 2638: update po_releases_all set

2634: fetch c2 into lGrpId,lRevNum;
2635: close c2;
2636: if (lGrpId is null) then
2637:
2638: update po_releases_all set
2639: authorization_status = 'APPROVED',
2640: CHANGE_REQUESTED_BY = null,
2641: revised_date = sysdate,
2642: last_update_date = sysdate,

Line 2655: from po_releases_all

2651: else
2652: begin
2653: select revision_num
2654: into l_revision_num
2655: from po_releases_all
2656: where po_release_id = p_po_release_id;
2657: exception
2658: when others then
2659: raise;

Line 3135: from po_releases_All where

3131: if (p_header_id is null) then
3132:
3133: select last_update_Date
3134: into p_last_update_date
3135: from po_releases_All where
3136: po_release_id = p_release_id
3137: and rownum=1;
3138:
3139: else