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_CHG_REQUEST_PVT dependencies on PO_HEADERS_ALL

Line 27: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;

23: p_po_release_id in number,
24: x_activity_name out nocopy varchar2) RETURN NUMBER IS
25:
26: v_nid NUMBER;
27: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;
28: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;
29: l_message_name varchar2(100);
30:
31:

Line 28: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;

24: x_activity_name out nocopy varchar2) RETURN NUMBER IS
25:
26: v_nid NUMBER;
27: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;
28: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;
29: l_message_name varchar2(100);
30:
31:
32: BEGIN

Line 37: from wf_notifications a, po_headers_all poh,

33: if p_po_release_id is null then
34: begin
35: select a.notification_id,poh.wf_item_type,poh.wf_item_key, a.message_name
36: INTO v_nid,l_po_item_type,l_po_item_key, l_message_name
37: from wf_notifications a, po_headers_all poh,
38: wf_item_activity_statuses wa
39: where poh.po_header_id = p_po_header_id and
40: poh.wf_item_key = wa.item_key and
41: poh.wf_item_type = wa.item_type

Line 197: ifAckReqd PO_HEADERS_ALL.acceptance_required_flag%TYPE;

193: p_ack_reqd IN varchar2
194: ) RETURN VARCHAR2 IS
195:
196: startWf varchar2(10);
197: ifAckReqd PO_HEADERS_ALL.acceptance_required_flag%TYPE;
198: l_nid NUMBER;
199: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;
200: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;
201: l_api_name CONSTANT VARCHAR2(30) := 'startSupplierWF';

Line 199: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;

195:
196: startWf varchar2(10);
197: ifAckReqd PO_HEADERS_ALL.acceptance_required_flag%TYPE;
198: l_nid NUMBER;
199: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;
200: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;
201: l_api_name CONSTANT VARCHAR2(30) := 'startSupplierWF';
202: x_return_status VARCHAR2(10);
203: l_activity_name VARCHAR2(100);

Line 200: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;

196: startWf varchar2(10);
197: ifAckReqd PO_HEADERS_ALL.acceptance_required_flag%TYPE;
198: l_nid NUMBER;
199: l_po_item_type PO_HEADERS_ALL.WF_ITEM_TYPE%TYPE;
200: l_po_item_key PO_HEADERS_ALL.WF_ITEM_KEY%TYPE;
201: l_api_name CONSTANT VARCHAR2(30) := 'startSupplierWF';
202: x_return_status VARCHAR2(10);
203: l_activity_name VARCHAR2(100);
204: l_document_type varchar2(10);

Line 226: from po_headers_all

222:
223: if p_po_release_id is null then
224: select wf_item_key,wf_item_type
225: into l_po_item_key,l_po_item_type
226: from po_headers_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

Line 758: v_auth_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;

754: p_mpoc IN varchar2 default FND_API.G_FALSE) IS
755:
756: x_error_code varchar2(40);
757: no_rec_found exception;
758: v_auth_status PO_HEADERS_ALL.AUTHORIZATION_STATUS%TYPE;
759: x_progress varchar2(3) := '000';
760: l_api_version_number CONSTANT NUMBER := 1.0;
761: l_api_name CONSTANT VARCHAR2(30) := 'process_supplier_request';
762: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 779: x_accp_flag po_headers_all.acceptance_required_flag%type;

775: ack_cnt number :=0;
776: callDocCheck boolean :=false;
777: accp_flag char(1);
778: v_buyer_id number;
779: x_accp_flag po_headers_all.acceptance_required_flag%type;
780: l_err_msg_name_tbl po_tbl_varchar30;
781: l_err_msg_text_tbl po_tbl_varchar2000;
782: l_last_upd_date po_headers_all.last_update_date%type;
783: l_count_asn NUMBER;

Line 782: l_last_upd_date po_headers_all.last_update_date%type;

778: v_buyer_id number;
779: x_accp_flag po_headers_all.acceptance_required_flag%type;
780: l_err_msg_name_tbl po_tbl_varchar30;
781: l_err_msg_text_tbl po_tbl_varchar2000;
782: l_last_upd_date po_headers_all.last_update_date%type;
783: l_count_asn NUMBER;
784: l_ret_sts varchar2(1);
785:
786:

Line 789: FROM PO_HEADERS_ALL

785:
786:
787: CURSOR PO_CSR(p_po_header_id in number) IS
788: SELECT last_update_date
789: FROM PO_HEADERS_ALL
790: WHERE PO_HEADER_ID = p_po_header_id
791: FOR UPDATE of last_update_date NOWAIT;
792:
793: poRec PO_CSR%ROWTYPE;

Line 973: from po_headers_all

969:
970: if p_po_release_id is null then
971: select agent_id,nvl(acceptance_required_flag,'N')
972: into v_buyer_id,x_accp_flag
973: from po_headers_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

Line 1089: update po_headers_all

1085: if (nvl(l_po_change_requests(i).New_Supplier_Order_Number,-1) <> nvl(l_po_change_requests(i).Old_Supplier_Order_Number,-1)) then
1086:
1087: if (p_po_release_id is null ) then
1088: -- Update the vendor_order_num for PO Headers no need of approval.
1089: update po_headers_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.

Line 1266: update po_headers_all set

1262: program_id = fnd_global.conc_program_id,
1263: program_update_date = sysdate
1264: where po_release_id = p_po_release_id;
1265: else
1266: update po_headers_all set
1267: last_update_date = sysdate,
1268: last_updated_by = l_user_id,
1269: last_update_login = l_login_id,
1270: 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 1329: update po_headers_all set

1325: l_login_id := p_login_id;
1326: end if;
1327:
1328: if p_po_release_id is null then
1329: update po_headers_all set
1330: authorization_status = 'IN PROCESS',
1331: CHANGE_REQUESTED_BY = 'SUPPLIER',
1332: last_update_date = sysdate,
1333: last_updated_by = l_user_id,

Line 1486: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

1482: ship_cnt number :=0;
1483: dist_cnt number :=0;
1484: ack_cnt number :=0;
1485: p_document_id NUMBER;
1486: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1487: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1488: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1489: sub_check_failed exception;
1490:

Line 1487: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

1483: dist_cnt number :=0;
1484: ack_cnt number :=0;
1485: p_document_id NUMBER;
1486: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1487: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1488: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1489: sub_check_failed exception;
1490:
1491: poLineIdTbl po_tbl_number := po_tbl_number();

Line 1488: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

1484: ack_cnt number :=0;
1485: p_document_id NUMBER;
1486: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1487: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1488: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
1489: sub_check_failed exception;
1490:
1491: poLineIdTbl po_tbl_number := po_tbl_number();
1492: unitPriceTbl po_tbl_number := po_tbl_number();

Line 1570: from po_headers_all poh

1566: nvl(pol.cancel_flag,'N') <> 'Y' and
1567: nvl(pol.MANUAL_PRICE_CHANGE_FLAG,'N') <> 'Y' AND /* 9867085 */
1568: pol.from_header_id in (
1569: select po_header_id
1570: from po_headers_all poh
1571: where poh.global_agreement_flag='Y'
1572: and poh.po_header_id=pol.from_header_id) and
1573: exists(select poll.line_location_id
1574: from po_line_locations_archive_all poll

Line 1618: from po_headers_all

1614: else
1615: p_document_id := p_po_header_id;
1616: select type_lookup_code , org_id
1617: into v_type_code , x_org_id
1618: from po_headers_all
1619: where po_header_id= p_po_header_id;
1620: if (v_type_code in ('STANDARD','PLANNED')) then
1621: v_document_type := 'PO';
1622: v_document_subtype := v_type_code;

Line 2035: x_po_header_id po_headers_all.po_header_id%type;

2031: x_order_type po_line_types.order_type_lookup_code%type;
2032: l_return_status varchar2(3);
2033: l_retro_active_price_change varchar2(3);
2034: l_doc_type varchar2(25);
2035: x_po_header_id po_headers_all.po_header_id%type;
2036: l_is_complex_po varchar2(1):='N';
2037: l_is_actual_po varchar2(1):='Y';
2038:
2039: BEGIN

Line 2060: from po_headers_all poh, po_lines_all pol

2056:
2057: --See if the PO is of type BLANKET; if so, the price can be updatable at any time.
2058: select poh.type_lookup_code
2059: into l_doc_type
2060: from po_headers_all poh, po_lines_all pol
2061: where poh.po_header_id = pol.po_header_id
2062: and po_line_id = p_po_line_id;
2063:
2064: if (l_doc_type = 'STANDARD') then

Line 2130: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

2126: p_po_header_id IN NUMBER,
2127: p_po_release_id IN NUMBER) IS
2128:
2129: p_document_id NUMBER;
2130: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2131: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2132: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2133: l_api_name CONSTANT VARCHAR2(30) := 'validateCancelRequest';
2134: l_api_version CONSTANT NUMBER := 1.0;

Line 2131: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

2127: p_po_release_id IN NUMBER) IS
2128:
2129: p_document_id NUMBER;
2130: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2131: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2132: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2133: l_api_name CONSTANT VARCHAR2(30) := 'validateCancelRequest';
2134: l_api_version CONSTANT NUMBER := 1.0;
2135: x_org_id number;

Line 2132: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

2128:
2129: p_document_id NUMBER;
2130: v_document_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2131: v_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2132: v_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
2133: l_api_name CONSTANT VARCHAR2(30) := 'validateCancelRequest';
2134: l_api_version CONSTANT NUMBER := 1.0;
2135: x_org_id number;
2136: x_ship_count NUMBER := 0;

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 2181: from po_headers_all

2177: end if;
2178: else
2179: p_document_id := p_po_header_id;
2180: select type_lookup_code into v_type_code
2181: from po_headers_all
2182: where po_header_id= p_po_header_id;
2183: if (v_type_code in ('STANDARD','PLANNED')) then
2184: v_document_type := 'PO';
2185: v_document_subtype := v_type_code;

Line 2193: from po_headers_all

2189: end if;
2190:
2191: select org_id
2192: into x_org_id
2193: from po_headers_all
2194: where po_header_id= p_po_header_id;
2195:
2196: end if;
2197: -- Set the org context before calling the cancel api

Line 2237: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH

2233: AND POL.order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE');
2234: else
2235: SELECT count(*)
2236: INTO x_ship_count
2237: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH
2238: WHERE
2239: POH.PO_HEADER_ID = p_po_header_id
2240: AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
2241: AND POH.TYPE_LOOKUP_CODE ='STANDARD'

Line 2310: x_accp_flag po_headers_all.acceptance_required_flag%type;

2306: x_msg_display OUT NOCOPY VARCHAR2,
2307: x_note OUT NOCOPY CLOB) IS
2308:
2309: x_ack_stat varchar2(40);
2310: x_accp_flag po_headers_all.acceptance_required_flag%type;
2311: x_revision number;
2312: x_cons_flag po_line_locations.consigned_flag%type;
2313:
2314: BEGIN

Line 2359: po_headers_all poh,

2355: pll.po_header_id, p_po_release_id,p_revision_num),nvl(poh.acceptance_required_flag,'N'),
2356: poh.revision_num,nvl(pll.consigned_flag,'N')
2357: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2358: from po_line_locations_all pll,
2359: po_headers_all poh,
2360: po_lookup_codes polc
2361: where
2362: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and
2363: polc.lookup_type = 'DOCUMENT STATE' and

Line 2570: FROM po_headers_all

2566:
2567: BEGIN
2568: SELECT segment1
2569: INTO x_ga_number
2570: FROM po_headers_all
2571: WHERE po_header_id = p_from_header_id
2572: AND global_agreement_flag='Y';
2573: EXCEPTION
2574: when no_data_found then

Line 2822: update po_headers_all set

2818: fetch c1 into lGrpId,lRevNum;
2819: close c1;
2820: if (lGrpId is null) then
2821:
2822: update po_headers_all set
2823: authorization_status = 'APPROVED',
2824: CHANGE_REQUESTED_BY = null,
2825: last_update_date = sysdate,
2826: last_updated_by = fnd_global.user_id,

Line 2839: from po_headers_all

2835:
2836: begin
2837: select revision_num
2838: into l_revision_num
2839: from po_headers_all
2840: where po_header_id = p_po_header_id;
2841: exception
2842: when others then
2843: raise;

Line 2945: from po_headers_all

2941: end if;
2942:
2943: select wf_item_type
2944: into l_item_type
2945: from po_headers_all
2946: WHERE po_header_id = p_po_header_id;
2947:
2948:
2949: -- First Find the Item Key for this Document if it were ever generated

Line 3516: from po_headers_All

3512: else
3513:
3514: select last_update_Date
3515: into p_last_update_date
3516: from po_headers_All
3517: where po_header_id = p_header_id
3518: and rownum=1;
3519:
3520: end if;