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 797: FROM PO_RELEASES_ALL

793: poRec PO_CSR%ROWTYPE;
794:
795: CURSOR REL_CSR(p_po_release_id in number) IS
796: SELECT last_update_date
797: FROM PO_RELEASES_ALL
798: WHERE PO_RELEASE_ID = p_po_release_id
799: FOR UPDATE of last_update_date NOWAIT;
800:
801: relRec REL_CSR%ROWTYPE;

Line 978: from po_releases_all

974: where po_header_id = p_po_header_id;
975: else
976: select agent_id,nvl(acceptance_required_flag,'N')
977: into v_buyer_id,x_accp_flag
978: from po_releases_all
979: where po_release_id = p_po_release_id;
980: end if;
981:
982: FOR i in 1..l_po_change_requests.count()

Line 1094: update po_releases_all

1090: set vendor_order_num = l_po_change_requests(i).New_Supplier_Order_Number
1091: where po_header_id = p_po_header_id;
1092: else
1093: -- Update the vendor_order_num for PO Releases no need of approval.
1094: update po_releases_all
1095: set vendor_order_num = l_po_change_requests(i).New_Supplier_Order_Number
1096: where po_release_id = p_po_release_id;
1097: end if;
1098: end if;

Line 1256: update po_releases_all set

1252: l_login_id := p_login_id;
1253: end if;
1254: -- Update the last update date if po dosent require to be updated
1255: if (p_po_release_id is not null) then
1256: update po_releases_all set
1257: last_update_date = sysdate,
1258: last_updated_by = l_user_id,
1259: last_update_login = l_login_id,
1260: request_id = fnd_global.conc_request_id,

Line 1296: * Effects: Updates The PO_HEADERS_ALL, PO_RELEASES_ALL

1292: /**
1293: * Private Procedure: update_po_attributes
1294: * Requires: PO_HEADER_ID,PO_RELEASE_ID,REVISION_NUM,REQUEST_GROUP_ID
1295: * Modifies:
1296: * Effects: Updates The PO_HEADERS_ALL, PO_RELEASES_ALL
1297: * Returns:
1298: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
1299: * FND_API.G_RET_STS_ERROR if an error occurs
1300: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

Line 1401: update po_releases_all set

1397: request_status ='PENDING') ;
1398: */
1399: else
1400: -- For Releases
1401: update po_releases_all set
1402: authorization_status = 'IN PROCESS',
1403: CHANGE_REQUESTED_BY = 'SUPPLIER',
1404: revised_date = sysdate,
1405: last_update_date = sysdate,

Line 1612: from po_releases_all

1608: v_document_type := 'RELEASE';
1609: v_document_subtype := 'RELEASE';
1610: select org_id
1611: into x_org_id
1612: from po_releases_all
1613: where po_release_id= p_po_release_id;
1614: else
1615: p_document_id := p_po_header_id;
1616: select type_lookup_code , org_id

Line 2167: from po_headers_all poh,po_releases_all por

2163:
2164:
2165: select poh.type_lookup_code,por.org_id
2166: into v_type_code,x_org_id
2167: from po_headers_all poh,po_releases_all por
2168: where por.po_header_id = poh.po_header_id and
2169: por.po_release_id = p_po_release_id;
2170:
2171: if (v_type_code = 'BLANKET') then

Line 2422: po_releases_all por,

2418: pll.po_header_id, p_po_release_id,p_revision_num),nvl(por.acceptance_required_flag,'N'),
2419: por.revision_num,nvl(pll.consigned_flag,'N')
2420: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2421: from po_line_locations_all pll,
2422: po_releases_all por,
2423: po_lookup_codes polc
2424: where
2425: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and
2426: polc.lookup_type = 'DOCUMENT STATE' and

Line 2785: update po_releases_all set

2781: fetch c2 into lGrpId,lRevNum;
2782: close c2;
2783: if (lGrpId is null) then
2784:
2785: update po_releases_all set
2786: authorization_status = 'APPROVED',
2787: CHANGE_REQUESTED_BY = null,
2788: revised_date = sysdate,
2789: last_update_date = sysdate,

Line 2802: from po_releases_all

2798: else
2799: begin
2800: select revision_num
2801: into l_revision_num
2802: from po_releases_all
2803: where po_release_id = p_po_release_id;
2804: exception
2805: when others then
2806: raise;

Line 3508: from po_releases_All where

3504: if (p_header_id is null) then
3505:
3506: select last_update_Date
3507: into p_last_update_date
3508: from po_releases_All where
3509: po_release_id = p_release_id
3510: and rownum=1;
3511:
3512: else