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.POR_HISTORY_FEED_PKG dependencies on POR_FEED_RECORDS

Line 51: FROM por_feed_records

47: CURSOR g_cur_po_headers IS
48: SELECT po_header_id,
49: po_release_id,
50: concurrent_request_id
51: FROM por_feed_records
52: WHERE concurrent_request_id = g_conc_req_id
53: GROUP BY po_header_id,
54: po_release_id,
55: concurrent_request_id;

Line 113: por_feed_records

109: item_number,
110: line_cancel_flag,
111: shipment_cancel_flag
112: FROM
113: por_feed_records
114: WHERE
115: po_header_id = i_po_header_id
116: AND po_release_id = i_release_id
117: AND concurrent_request_id = g_conc_req_id;

Line 121: l_po_number por_feed_records.po_number%TYPE := NULL;

117: AND concurrent_request_id = g_conc_req_id;
118:
119: l_distr_line_number NUMBER := 0;
120: l_cr_dr_indicator VARCHAR2(1) := NULL;
121: l_po_number por_feed_records.po_number%TYPE := NULL;
122: l_line_num NUMBER := 0;
123: l_detail_record VARCHAR2(2000) := NULL;
124:
125:

Line 293: l_po_number por_feed_records.po_number%TYPE := NULL;

289: -------------------------------------------------------------------------------
290:
291: PROCEDURE Write_Header_Record IS
292:
293: l_po_number por_feed_records.po_number%TYPE := NULL;
294: l_card_member_name por_feed_records.card_member_name%TYPE := NULL;
295: l_requester_name HR_EMPLOYEES.FULL_NAME%TYPE := NULL;
296: l_requester_id por_feed_records.requester_id%TYPE := NULL;
297: l_payment_type_indicator VARCHAR2(1) := NULL;

Line 294: l_card_member_name por_feed_records.card_member_name%TYPE := NULL;

290:
291: PROCEDURE Write_Header_Record IS
292:
293: l_po_number por_feed_records.po_number%TYPE := NULL;
294: l_card_member_name por_feed_records.card_member_name%TYPE := NULL;
295: l_requester_name HR_EMPLOYEES.FULL_NAME%TYPE := NULL;
296: l_requester_id por_feed_records.requester_id%TYPE := NULL;
297: l_payment_type_indicator VARCHAR2(1) := NULL;
298: l_order_status VARCHAR2(2):= NULL;

Line 296: l_requester_id por_feed_records.requester_id%TYPE := NULL;

292:
293: l_po_number por_feed_records.po_number%TYPE := NULL;
294: l_card_member_name por_feed_records.card_member_name%TYPE := NULL;
295: l_requester_name HR_EMPLOYEES.FULL_NAME%TYPE := NULL;
296: l_requester_id por_feed_records.requester_id%TYPE := NULL;
297: l_payment_type_indicator VARCHAR2(1) := NULL;
298: l_order_status VARCHAR2(2):= NULL;
299: l_cr_dr_indicator VARCHAR2(1) := NULL;
300: l_card_number VARCHAR2(80) := NULL;

Line 301: l_release_number por_feed_records.release_number%TYPE := 0;

297: l_payment_type_indicator VARCHAR2(1) := NULL;
298: l_order_status VARCHAR2(2):= NULL;
299: l_cr_dr_indicator VARCHAR2(1) := NULL;
300: l_card_number VARCHAR2(80) := NULL;
301: l_release_number por_feed_records.release_number%TYPE := 0;
302: l_card_type_lookup_code por_feed_records.card_type_lookup_code%TYPE := NULL;
303: l_vendor_name por_feed_records.vendor_name%TYPE := NULL;
304: l_vendor_id por_feed_records.vendor_id%TYPE := 0;
305: l_vendor_site_id por_feed_records.vendor_site_id%TYPE := 0;

Line 302: l_card_type_lookup_code por_feed_records.card_type_lookup_code%TYPE := NULL;

298: l_order_status VARCHAR2(2):= NULL;
299: l_cr_dr_indicator VARCHAR2(1) := NULL;
300: l_card_number VARCHAR2(80) := NULL;
301: l_release_number por_feed_records.release_number%TYPE := 0;
302: l_card_type_lookup_code por_feed_records.card_type_lookup_code%TYPE := NULL;
303: l_vendor_name por_feed_records.vendor_name%TYPE := NULL;
304: l_vendor_id por_feed_records.vendor_id%TYPE := 0;
305: l_vendor_site_id por_feed_records.vendor_site_id%TYPE := 0;
306: l_vendor_site_code por_feed_records.vendor_site_code%TYPE := NULL;

Line 303: l_vendor_name por_feed_records.vendor_name%TYPE := NULL;

299: l_cr_dr_indicator VARCHAR2(1) := NULL;
300: l_card_number VARCHAR2(80) := NULL;
301: l_release_number por_feed_records.release_number%TYPE := 0;
302: l_card_type_lookup_code por_feed_records.card_type_lookup_code%TYPE := NULL;
303: l_vendor_name por_feed_records.vendor_name%TYPE := NULL;
304: l_vendor_id por_feed_records.vendor_id%TYPE := 0;
305: l_vendor_site_id por_feed_records.vendor_site_id%TYPE := 0;
306: l_vendor_site_code por_feed_records.vendor_site_code%TYPE := NULL;
307: l_order_date por_feed_records.order_date%TYPE := NULL;

Line 304: l_vendor_id por_feed_records.vendor_id%TYPE := 0;

300: l_card_number VARCHAR2(80) := NULL;
301: l_release_number por_feed_records.release_number%TYPE := 0;
302: l_card_type_lookup_code por_feed_records.card_type_lookup_code%TYPE := NULL;
303: l_vendor_name por_feed_records.vendor_name%TYPE := NULL;
304: l_vendor_id por_feed_records.vendor_id%TYPE := 0;
305: l_vendor_site_id por_feed_records.vendor_site_id%TYPE := 0;
306: l_vendor_site_code por_feed_records.vendor_site_code%TYPE := NULL;
307: l_order_date por_feed_records.order_date%TYPE := NULL;
308: l_base_currency_code por_feed_records.base_currency_code%TYPE := NULL;

Line 305: l_vendor_site_id por_feed_records.vendor_site_id%TYPE := 0;

301: l_release_number por_feed_records.release_number%TYPE := 0;
302: l_card_type_lookup_code por_feed_records.card_type_lookup_code%TYPE := NULL;
303: l_vendor_name por_feed_records.vendor_name%TYPE := NULL;
304: l_vendor_id por_feed_records.vendor_id%TYPE := 0;
305: l_vendor_site_id por_feed_records.vendor_site_id%TYPE := 0;
306: l_vendor_site_code por_feed_records.vendor_site_code%TYPE := NULL;
307: l_order_date por_feed_records.order_date%TYPE := NULL;
308: l_base_currency_code por_feed_records.base_currency_code%TYPE := NULL;
309: l_local_currency_code por_feed_records.local_currency_code%TYPE := NULL;

Line 306: l_vendor_site_code por_feed_records.vendor_site_code%TYPE := NULL;

302: l_card_type_lookup_code por_feed_records.card_type_lookup_code%TYPE := NULL;
303: l_vendor_name por_feed_records.vendor_name%TYPE := NULL;
304: l_vendor_id por_feed_records.vendor_id%TYPE := 0;
305: l_vendor_site_id por_feed_records.vendor_site_id%TYPE := 0;
306: l_vendor_site_code por_feed_records.vendor_site_code%TYPE := NULL;
307: l_order_date por_feed_records.order_date%TYPE := NULL;
308: l_base_currency_code por_feed_records.base_currency_code%TYPE := NULL;
309: l_local_currency_code por_feed_records.local_currency_code%TYPE := NULL;
310: l_po_header_amount por_feed_records.po_header_amount%TYPE := NULL;

Line 307: l_order_date por_feed_records.order_date%TYPE := NULL;

303: l_vendor_name por_feed_records.vendor_name%TYPE := NULL;
304: l_vendor_id por_feed_records.vendor_id%TYPE := 0;
305: l_vendor_site_id por_feed_records.vendor_site_id%TYPE := 0;
306: l_vendor_site_code por_feed_records.vendor_site_code%TYPE := NULL;
307: l_order_date por_feed_records.order_date%TYPE := NULL;
308: l_base_currency_code por_feed_records.base_currency_code%TYPE := NULL;
309: l_local_currency_code por_feed_records.local_currency_code%TYPE := NULL;
310: l_po_header_amount por_feed_records.po_header_amount%TYPE := NULL;
311: l_approval_status por_feed_records.approval_status%TYPE := NULL;

Line 308: l_base_currency_code por_feed_records.base_currency_code%TYPE := NULL;

304: l_vendor_id por_feed_records.vendor_id%TYPE := 0;
305: l_vendor_site_id por_feed_records.vendor_site_id%TYPE := 0;
306: l_vendor_site_code por_feed_records.vendor_site_code%TYPE := NULL;
307: l_order_date por_feed_records.order_date%TYPE := NULL;
308: l_base_currency_code por_feed_records.base_currency_code%TYPE := NULL;
309: l_local_currency_code por_feed_records.local_currency_code%TYPE := NULL;
310: l_po_header_amount por_feed_records.po_header_amount%TYPE := NULL;
311: l_approval_status por_feed_records.approval_status%TYPE := NULL;
312: l_control_status por_feed_records.control_status%TYPE := NULL;

Line 309: l_local_currency_code por_feed_records.local_currency_code%TYPE := NULL;

305: l_vendor_site_id por_feed_records.vendor_site_id%TYPE := 0;
306: l_vendor_site_code por_feed_records.vendor_site_code%TYPE := NULL;
307: l_order_date por_feed_records.order_date%TYPE := NULL;
308: l_base_currency_code por_feed_records.base_currency_code%TYPE := NULL;
309: l_local_currency_code por_feed_records.local_currency_code%TYPE := NULL;
310: l_po_header_amount por_feed_records.po_header_amount%TYPE := NULL;
311: l_approval_status por_feed_records.approval_status%TYPE := NULL;
312: l_control_status por_feed_records.control_status%TYPE := NULL;
313: l_approved_date por_feed_records.approved_date%TYPE := NULL;

Line 310: l_po_header_amount por_feed_records.po_header_amount%TYPE := NULL;

306: l_vendor_site_code por_feed_records.vendor_site_code%TYPE := NULL;
307: l_order_date por_feed_records.order_date%TYPE := NULL;
308: l_base_currency_code por_feed_records.base_currency_code%TYPE := NULL;
309: l_local_currency_code por_feed_records.local_currency_code%TYPE := NULL;
310: l_po_header_amount por_feed_records.po_header_amount%TYPE := NULL;
311: l_approval_status por_feed_records.approval_status%TYPE := NULL;
312: l_control_status por_feed_records.control_status%TYPE := NULL;
313: l_approved_date por_feed_records.approved_date%TYPE := NULL;
314: l_cancel_flag por_feed_records.cancel_flag%TYPE := NULL;

Line 311: l_approval_status por_feed_records.approval_status%TYPE := NULL;

307: l_order_date por_feed_records.order_date%TYPE := NULL;
308: l_base_currency_code por_feed_records.base_currency_code%TYPE := NULL;
309: l_local_currency_code por_feed_records.local_currency_code%TYPE := NULL;
310: l_po_header_amount por_feed_records.po_header_amount%TYPE := NULL;
311: l_approval_status por_feed_records.approval_status%TYPE := NULL;
312: l_control_status por_feed_records.control_status%TYPE := NULL;
313: l_approved_date por_feed_records.approved_date%TYPE := NULL;
314: l_cancel_flag por_feed_records.cancel_flag%TYPE := NULL;
315: l_hold_flag por_feed_records.hold_flag%TYPE := NULL;

Line 312: l_control_status por_feed_records.control_status%TYPE := NULL;

308: l_base_currency_code por_feed_records.base_currency_code%TYPE := NULL;
309: l_local_currency_code por_feed_records.local_currency_code%TYPE := NULL;
310: l_po_header_amount por_feed_records.po_header_amount%TYPE := NULL;
311: l_approval_status por_feed_records.approval_status%TYPE := NULL;
312: l_control_status por_feed_records.control_status%TYPE := NULL;
313: l_approved_date por_feed_records.approved_date%TYPE := NULL;
314: l_cancel_flag por_feed_records.cancel_flag%TYPE := NULL;
315: l_hold_flag por_feed_records.hold_flag%TYPE := NULL;
316: l_line_cancel_flag por_feed_records.line_cancel_flag%TYPE := NULL;

Line 313: l_approved_date por_feed_records.approved_date%TYPE := NULL;

309: l_local_currency_code por_feed_records.local_currency_code%TYPE := NULL;
310: l_po_header_amount por_feed_records.po_header_amount%TYPE := NULL;
311: l_approval_status por_feed_records.approval_status%TYPE := NULL;
312: l_control_status por_feed_records.control_status%TYPE := NULL;
313: l_approved_date por_feed_records.approved_date%TYPE := NULL;
314: l_cancel_flag por_feed_records.cancel_flag%TYPE := NULL;
315: l_hold_flag por_feed_records.hold_flag%TYPE := NULL;
316: l_line_cancel_flag por_feed_records.line_cancel_flag%TYPE := NULL;
317: l_shipment_cancel_flag por_feed_records.shipment_cancel_flag%TYPE := NULL;

Line 314: l_cancel_flag por_feed_records.cancel_flag%TYPE := NULL;

310: l_po_header_amount por_feed_records.po_header_amount%TYPE := NULL;
311: l_approval_status por_feed_records.approval_status%TYPE := NULL;
312: l_control_status por_feed_records.control_status%TYPE := NULL;
313: l_approved_date por_feed_records.approved_date%TYPE := NULL;
314: l_cancel_flag por_feed_records.cancel_flag%TYPE := NULL;
315: l_hold_flag por_feed_records.hold_flag%TYPE := NULL;
316: l_line_cancel_flag por_feed_records.line_cancel_flag%TYPE := NULL;
317: l_shipment_cancel_flag por_feed_records.shipment_cancel_flag%TYPE := NULL;
318:

Line 315: l_hold_flag por_feed_records.hold_flag%TYPE := NULL;

311: l_approval_status por_feed_records.approval_status%TYPE := NULL;
312: l_control_status por_feed_records.control_status%TYPE := NULL;
313: l_approved_date por_feed_records.approved_date%TYPE := NULL;
314: l_cancel_flag por_feed_records.cancel_flag%TYPE := NULL;
315: l_hold_flag por_feed_records.hold_flag%TYPE := NULL;
316: l_line_cancel_flag por_feed_records.line_cancel_flag%TYPE := NULL;
317: l_shipment_cancel_flag por_feed_records.shipment_cancel_flag%TYPE := NULL;
318:
319: l_object_type VARCHAR2(1) := NULL;

Line 316: l_line_cancel_flag por_feed_records.line_cancel_flag%TYPE := NULL;

312: l_control_status por_feed_records.control_status%TYPE := NULL;
313: l_approved_date por_feed_records.approved_date%TYPE := NULL;
314: l_cancel_flag por_feed_records.cancel_flag%TYPE := NULL;
315: l_hold_flag por_feed_records.hold_flag%TYPE := NULL;
316: l_line_cancel_flag por_feed_records.line_cancel_flag%TYPE := NULL;
317: l_shipment_cancel_flag por_feed_records.shipment_cancel_flag%TYPE := NULL;
318:
319: l_object_type VARCHAR2(1) := NULL;
320: l_object_id NUMBER := 0;

Line 317: l_shipment_cancel_flag por_feed_records.shipment_cancel_flag%TYPE := NULL;

313: l_approved_date por_feed_records.approved_date%TYPE := NULL;
314: l_cancel_flag por_feed_records.cancel_flag%TYPE := NULL;
315: l_hold_flag por_feed_records.hold_flag%TYPE := NULL;
316: l_line_cancel_flag por_feed_records.line_cancel_flag%TYPE := NULL;
317: l_shipment_cancel_flag por_feed_records.shipment_cancel_flag%TYPE := NULL;
318:
319: l_object_type VARCHAR2(1) := NULL;
320: l_object_id NUMBER := 0;
321: l_char VARCHAR2(1) := NULL;

Line 403: FROM por_feed_records

399: l_control_status,
400: l_approved_date,
401: l_cancel_flag,
402: l_hold_flag
403: FROM por_feed_records
404: WHERE po_header_id = rec_header.po_header_id
405: AND po_release_id = rec_header.po_release_id
406: AND concurrent_request_id = g_conc_req_id
407: AND nvl(error_flag, 'N') = 'N'

Line 467: FROM por_feed_records

463:
464: --Determine the total number of distribution lines for the PO
465: SELECT count(*)
466: INTO l_total_distr_records
467: FROM por_feed_records
468: WHERE po_header_id = rec_header.po_header_id
469: AND po_release_id = rec_header.po_release_id
470: AND (line_cancel_flag IS NULL OR line_cancel_flag = 'N')
471: AND (shipment_cancel_flag IS NULL OR shipment_cancel_flag = 'N')

Line 706: FROM por_feed_records

702: FOR rec_header IN g_cur_po_headers
703: LOOP
704: SELECT po_header_amount, card_number, po_number, release_number, cancel_flag, control_status
705: INTO l_po_header_amount, l_card_number, l_po_number, l_release_number, l_cancel_flag, l_control_status
706: FROM por_feed_records
707: WHERE po_header_id = rec_header.po_header_id
708: AND po_release_id = rec_header.po_release_id
709: AND concurrent_request_id = g_conc_req_id
710: AND rownum = 1;

Line 735: UPDATE por_feed_records

731: END IF;
732:
733: l_progress := '020';
734:
735: UPDATE por_feed_records
736: SET error_flag = 'Y'
737: WHERE po_header_id = rec_header.po_header_id
738: AND po_release_id = rec_header.po_release_id
739: AND concurrent_request_id = g_conc_req_id;

Line 762: UPDATE por_feed_records

758: END IF;
759:
760: l_progress := '030';
761:
762: UPDATE por_feed_records
763: SET error_flag = 'Y'
764: WHERE po_header_id = rec_header.po_header_id
765: AND po_release_id = rec_header.po_release_id
766: AND concurrent_request_id = g_conc_req_id;

Line 790: FROM por_feed_records

786: -- get count of distribution/detail records for POs; do not include canceled and
787: -- finally closed PO header records
788: SELECT COUNT(*)
789: INTO l_total_detail_records
790: FROM por_feed_records
791: WHERE (line_cancel_fLag IS NULL OR line_cancel_flag = 'N')
792: AND (shipment_cancel_flag IS NULL OR shipment_cancel_flag = 'N')
793: AND (control_status <> 'FINALLY CLOSED' OR control_status IS NULL) --'CLOSED' ok
794: AND NVL(cancel_flag, 'N') = 'N'

Line 810: FROM por_feed_records

806: END IF;
807:
808: SELECT MIN(order_date), MAX(order_date)
809: INTO l_trans_start_date, l_trans_end_date
810: FROM por_feed_records
811: WHERE NVL(error_flag, 'N') = 'N'
812: AND concurrent_request_id = g_conc_req_id;
813:
814: l_progress := '050';

Line 910: FROM por_feed_records

906: PROCEDURE Trim_Card_Numbers IS
907:
908: CURSOR cur_card_numbers IS
909: SELECT card_number
910: FROM por_feed_records
911: WHERE concurrent_request_id = g_conc_req_id
912: GROUP BY card_number;
913:
914: l_card_number por_feed_records.card_number%TYPE;

Line 914: l_card_number por_feed_records.card_number%TYPE;

910: FROM por_feed_records
911: WHERE concurrent_request_id = g_conc_req_id
912: GROUP BY card_number;
913:
914: l_card_number por_feed_records.card_number%TYPE;
915: l_trim_card_number por_feed_records.card_number%TYPE;
916:
917: l_char VARCHAR2(1) := NULL;
918:

Line 915: l_trim_card_number por_feed_records.card_number%TYPE;

911: WHERE concurrent_request_id = g_conc_req_id
912: GROUP BY card_number;
913:
914: l_card_number por_feed_records.card_number%TYPE;
915: l_trim_card_number por_feed_records.card_number%TYPE;
916:
917: l_char VARCHAR2(1) := NULL;
918:
919: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 947: UPDATE por_feed_records

943: END LOOP;
944:
945: l_progress := '010';
946:
947: UPDATE por_feed_records
948: SET card_number = l_trim_card_number
949: WHERE card_number = l_card_number
950: AND concurrent_request_id = g_conc_req_id;
951: END IF;

Line 978: l_base_curr_code por_feed_records.base_currency_code%TYPE;

974: ------------------------------------------------------------------------
975:
976: PROCEDURE Get_Header_Amounts IS
977:
978: l_base_curr_code por_feed_records.base_currency_code%TYPE;
979: l_local_curr_code por_feed_records.local_currency_code%TYPE;
980:
981: l_object_type VARCHAR2(1) := NULL;
982: l_object_id NUMBER := 0;

Line 979: l_local_curr_code por_feed_records.local_currency_code%TYPE;

975:
976: PROCEDURE Get_Header_Amounts IS
977:
978: l_base_curr_code por_feed_records.base_currency_code%TYPE;
979: l_local_curr_code por_feed_records.local_currency_code%TYPE;
980:
981: l_object_type VARCHAR2(1) := NULL;
982: l_object_id NUMBER := 0;
983: l_po_amount NUMBER := 0;

Line 998: FROM por_feed_records

994: SELECT base_currency_code,
995: local_currency_code
996: INTO l_base_curr_code,
997: l_local_curr_code
998: FROM por_feed_records
999: WHERE po_header_id = rec_header.po_header_id
1000: AND po_release_id = rec_header.po_release_id
1001: AND concurrent_request_id = g_conc_req_id
1002: AND rownum = 1;

Line 1034: UPDATE por_feed_records

1030: END IF;
1031:
1032: l_progress := '020';
1033:
1034: UPDATE por_feed_records
1035: SET po_header_amount = l_po_amount
1036: WHERE po_header_id = rec_header.po_header_id
1037: AND po_release_id = rec_header.po_release_id
1038: AND concurrent_request_id = g_conc_req_id;

Line 1058: --This procedure populates the por_feed_records table with valid PO distributions

1054: END Get_Header_Amounts;
1055:
1056:
1057: -------------------------------------------------------------------------------
1058: --This procedure populates the por_feed_records table with valid PO distributions
1059: --using bulk binding.
1060: -------------------------------------------------------------------------------
1061:
1062: PROCEDURE Get_PO_Distributions IS

Line 1569: --Insert standard POs and blanket releases with catalog or non-catalog items into por_feed_records

1565: BEGIN
1566:
1567: l_progress := '000';
1568:
1569: --Insert standard POs and blanket releases with catalog or non-catalog items into por_feed_records
1570: IF cur_PO_records%ISOPEN THEN
1571: CLOSE cur_PO_records;
1572: END IF;
1573:

Line 1619: INSERT INTO por_feed_records (

1615: END IF;
1616:
1617: FORALL i in 1 .. cur_PO_records%ROWCOUNT
1618:
1619: INSERT INTO por_feed_records (
1620: concurrent_request_id,
1621: po_number,
1622: release_number,
1623: po_header_id,

Line 1697: --Insert canceled standard POs and blanket releases into por_feed_records

1693:
1694: l_progress := '020';
1695:
1696:
1697: --Insert canceled standard POs and blanket releases into por_feed_records
1698:
1699: IF cur_canceled_POs%ISOPEN THEN
1700: CLOSE cur_canceled_POs;
1701: END IF;

Line 1738: INSERT INTO por_feed_records (

1734: END IF;
1735:
1736: FORALL i in 1 .. cur_canceled_POs%ROWCOUNT
1737:
1738: INSERT INTO por_feed_records (
1739: concurrent_request_id,
1740: po_number,
1741: release_number,
1742: po_header_id,

Line 1975: DELETE FROM por_feed_records

1971: l_progress := '1100';
1972:
1973: UTL_FILE.FCLOSE(g_outfile);
1974:
1975: DELETE FROM por_feed_records
1976: WHERE concurrent_request_id = g_conc_req_id;
1977:
1978: --get conc mgr status;
1979: l_result := FND_CONCURRENT.GET_REQUEST_STATUS(