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 PO_HEADERS

Line 47: CURSOR g_cur_po_headers IS

43: g_max_card_num_size NUMBER := 0; -- maximum card size that is acceptable by AMEX :16
44: g_max_po_num_size NUMBER := 0; -- maximum po number size that is acceptable by AMEX : 15
45:
46: --global cursor for use by write_control_record and write_header_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

Line 355: IF g_cur_po_headers%ISOPEN THEN

351: BEGIN
352:
353: l_progress := '000';
354:
355: IF g_cur_po_headers%ISOPEN THEN
356: CLOSE g_cur_po_headers;
357: END IF;
358:
359: FOR rec_header IN g_cur_po_headers LOOP

Line 356: CLOSE g_cur_po_headers;

352:
353: l_progress := '000';
354:
355: IF g_cur_po_headers%ISOPEN THEN
356: CLOSE g_cur_po_headers;
357: END IF;
358:
359: FOR rec_header IN g_cur_po_headers LOOP
360:

Line 359: FOR rec_header IN g_cur_po_headers LOOP

355: IF g_cur_po_headers%ISOPEN THEN
356: CLOSE g_cur_po_headers;
357: END IF;
358:
359: FOR rec_header IN g_cur_po_headers LOOP
360:
361: BEGIN
362:
363: l_progress := '010';

Line 702: FOR rec_header IN g_cur_po_headers

698: BEGIN
699:
700: l_progress := '000';
701:
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

Line 991: FOR rec_header IN g_cur_po_headers

987:
988: BEGIN
989: l_progress := '000';
990:
991: FOR rec_header IN g_cur_po_headers
992: LOOP
993:
994: SELECT base_currency_code,
995: local_currency_code

Line 1064: TYPE tab_po_num IS TABLE OF po_headers.segment1%TYPE;

1060: -------------------------------------------------------------------------------
1061:
1062: PROCEDURE Get_PO_Distributions IS
1063:
1064: TYPE tab_po_num IS TABLE OF po_headers.segment1%TYPE;
1065: TYPE tab_rel_num IS TABLE OF po_releases.release_num%TYPE;
1066: TYPE tab_po_header_id IS TABLE OF po_headers.po_header_id%TYPE;
1067: TYPE tab_po_release_id IS TABLE OF po_releases.po_release_id%TYPE;
1068: TYPE tab_cardno IS TABLE OF iby_creditcard.masked_cc_number%TYPE;

Line 1066: TYPE tab_po_header_id IS TABLE OF po_headers.po_header_id%TYPE;

1062: PROCEDURE Get_PO_Distributions IS
1063:
1064: TYPE tab_po_num IS TABLE OF po_headers.segment1%TYPE;
1065: TYPE tab_rel_num IS TABLE OF po_releases.release_num%TYPE;
1066: TYPE tab_po_header_id IS TABLE OF po_headers.po_header_id%TYPE;
1067: TYPE tab_po_release_id IS TABLE OF po_releases.po_release_id%TYPE;
1068: TYPE tab_cardno IS TABLE OF iby_creditcard.masked_cc_number%TYPE;
1069: TYPE tab_cardmember IS TABLE OF ap_cards.cardmember_name%TYPE;
1070: TYPE tab_card_type IS TABLE OF ap_card_programs.card_type_lookup_code%TYPE;

Line 1077: TYPE tab_order_date IS TABLE OF po_headers.last_update_date%TYPE;

1073: TYPE tab_vendor_name IS TABLE OF po_vendors.vendor_name%TYPE;
1074: TYPE tab_vendor_site_code IS TABLE OF po_vendor_sites.vendor_site_code%TYPE;
1075: TYPE tab_vendor_id IS TABLE OF po_vendors.vendor_id%TYPE;
1076: TYPE tab_vendor_site_id IS TABLE OF po_vendor_sites.vendor_site_id%TYPE;
1077: TYPE tab_order_date IS TABLE OF po_headers.last_update_date%TYPE;
1078: TYPE tab_base_curr IS TABLE OF gl_sets_of_books.currency_code%TYPE;
1079: TYPE tab_local_curr IS TABLE OF po_headers.currency_code%TYPE;
1080: TYPE tab_uom IS TABLE OF po_lines.unit_meas_lookup_code%TYPE;
1081: TYPE tab_item_num IS TABLE OF mtl_system_items_kfv.concatenated_segments%TYPE;

Line 1079: TYPE tab_local_curr IS TABLE OF po_headers.currency_code%TYPE;

1075: TYPE tab_vendor_id IS TABLE OF po_vendors.vendor_id%TYPE;
1076: TYPE tab_vendor_site_id IS TABLE OF po_vendor_sites.vendor_site_id%TYPE;
1077: TYPE tab_order_date IS TABLE OF po_headers.last_update_date%TYPE;
1078: TYPE tab_base_curr IS TABLE OF gl_sets_of_books.currency_code%TYPE;
1079: TYPE tab_local_curr IS TABLE OF po_headers.currency_code%TYPE;
1080: TYPE tab_uom IS TABLE OF po_lines.unit_meas_lookup_code%TYPE;
1081: TYPE tab_item_num IS TABLE OF mtl_system_items_kfv.concatenated_segments%TYPE;
1082: TYPE tab_item_desc IS TABLE OF po_lines.item_description%TYPE;
1083: TYPE tab_qty IS TABLE OF po_distributions.quantity_ordered%TYPE;

Line 1088: TYPE tab_appr_status IS TABLE OF po_headers.authorization_status%TYPE;

1084: TYPE tab_unit_price IS TABLE OF po_lines.unit_price%TYPE;
1085: TYPE tab_amount IS TABLE OF NUMBER;
1086: TYPE tab_acct_id IS TABLE OF gl_sets_of_books.chart_of_accounts_id%TYPE;
1087: TYPE tab_acct_code IS TABLE OF gl_code_combinations_kfv.concatenated_segments%TYPE;
1088: TYPE tab_appr_status IS TABLE OF po_headers.authorization_status%TYPE;
1089: TYPE tab_appr_date IS TABLE OF po_headers.approved_date%TYPE;
1090: TYPE tab_control_status IS TABLE OF po_headers.closed_code%TYPE;
1091: TYPE tab_cancel_flag IS TABLE OF po_headers.cancel_flag%TYPE;
1092: TYPE tab_hold_flag IS TABLE OF po_headers.user_hold_flag%TYPE;

Line 1089: TYPE tab_appr_date IS TABLE OF po_headers.approved_date%TYPE;

1085: TYPE tab_amount IS TABLE OF NUMBER;
1086: TYPE tab_acct_id IS TABLE OF gl_sets_of_books.chart_of_accounts_id%TYPE;
1087: TYPE tab_acct_code IS TABLE OF gl_code_combinations_kfv.concatenated_segments%TYPE;
1088: TYPE tab_appr_status IS TABLE OF po_headers.authorization_status%TYPE;
1089: TYPE tab_appr_date IS TABLE OF po_headers.approved_date%TYPE;
1090: TYPE tab_control_status IS TABLE OF po_headers.closed_code%TYPE;
1091: TYPE tab_cancel_flag IS TABLE OF po_headers.cancel_flag%TYPE;
1092: TYPE tab_hold_flag IS TABLE OF po_headers.user_hold_flag%TYPE;
1093: TYPE tab_line_cancel_flag IS TABLE OF po_lines.cancel_flag%TYPE;

Line 1090: TYPE tab_control_status IS TABLE OF po_headers.closed_code%TYPE;

1086: TYPE tab_acct_id IS TABLE OF gl_sets_of_books.chart_of_accounts_id%TYPE;
1087: TYPE tab_acct_code IS TABLE OF gl_code_combinations_kfv.concatenated_segments%TYPE;
1088: TYPE tab_appr_status IS TABLE OF po_headers.authorization_status%TYPE;
1089: TYPE tab_appr_date IS TABLE OF po_headers.approved_date%TYPE;
1090: TYPE tab_control_status IS TABLE OF po_headers.closed_code%TYPE;
1091: TYPE tab_cancel_flag IS TABLE OF po_headers.cancel_flag%TYPE;
1092: TYPE tab_hold_flag IS TABLE OF po_headers.user_hold_flag%TYPE;
1093: TYPE tab_line_cancel_flag IS TABLE OF po_lines.cancel_flag%TYPE;
1094: TYPE tab_shipment_cancel_flag IS TABLE OF po_line_locations.cancel_flag%TYPE;

Line 1091: TYPE tab_cancel_flag IS TABLE OF po_headers.cancel_flag%TYPE;

1087: TYPE tab_acct_code IS TABLE OF gl_code_combinations_kfv.concatenated_segments%TYPE;
1088: TYPE tab_appr_status IS TABLE OF po_headers.authorization_status%TYPE;
1089: TYPE tab_appr_date IS TABLE OF po_headers.approved_date%TYPE;
1090: TYPE tab_control_status IS TABLE OF po_headers.closed_code%TYPE;
1091: TYPE tab_cancel_flag IS TABLE OF po_headers.cancel_flag%TYPE;
1092: TYPE tab_hold_flag IS TABLE OF po_headers.user_hold_flag%TYPE;
1093: TYPE tab_line_cancel_flag IS TABLE OF po_lines.cancel_flag%TYPE;
1094: TYPE tab_shipment_cancel_flag IS TABLE OF po_line_locations.cancel_flag%TYPE;
1095:

Line 1092: TYPE tab_hold_flag IS TABLE OF po_headers.user_hold_flag%TYPE;

1088: TYPE tab_appr_status IS TABLE OF po_headers.authorization_status%TYPE;
1089: TYPE tab_appr_date IS TABLE OF po_headers.approved_date%TYPE;
1090: TYPE tab_control_status IS TABLE OF po_headers.closed_code%TYPE;
1091: TYPE tab_cancel_flag IS TABLE OF po_headers.cancel_flag%TYPE;
1092: TYPE tab_hold_flag IS TABLE OF po_headers.user_hold_flag%TYPE;
1093: TYPE tab_line_cancel_flag IS TABLE OF po_lines.cancel_flag%TYPE;
1094: TYPE tab_shipment_cancel_flag IS TABLE OF po_line_locations.cancel_flag%TYPE;
1095:
1096: l_po_num tab_po_num;

Line 1173: PO_HEADERS PH,

1169: PLL.CANCEL_FLAG shipment_cancel_flag --ref
1170:
1171: FROM
1172:
1173: PO_HEADERS PH,
1174: PO_LINES PL,
1175: PO_LINE_LOCATIONS PLL,
1176: PO_DISTRIBUTIONS PD,
1177: PO_VENDORS PV,

Line 1249: PO_HEADERS PH,

1245: PL.CANCEL_FLAG line_cancel_flag, --ref
1246: PLL.CANCEL_FLAG shipment_cancel_flag --ref
1247:
1248: FROM
1249: PO_HEADERS PH,
1250: PO_LINES PL,
1251: PO_LINE_LOCATIONS PLL,
1252: PO_DISTRIBUTIONS PD,
1253: PO_VENDORS PV,

Line 1322: PO_HEADERS PH,

1318: PL.CANCEL_FLAG line_cancel_flag, --ref
1319: PLL.CANCEL_FLAG shipment_cancel_flag --ref
1320:
1321: FROM
1322: PO_HEADERS PH,
1323: PO_RELEASES PR,
1324: PO_LINES PL,
1325: PO_LINE_LOCATIONS PLL,
1326: PO_DISTRIBUTIONS PD,

Line 1398: PO_HEADERS PH,

1394: PL.CANCEL_FLAG line_cancel_flag, --ref
1395: PLL.CANCEL_FLAG shipment_cancel_flag --ref
1396:
1397: FROM
1398: PO_HEADERS PH,
1399: PO_RELEASES PR,
1400: PO_LINES PL,
1401: PO_LINE_LOCATIONS PLL,
1402: PO_DISTRIBUTIONS PD,

Line 1473: PO_HEADERS PH,

1469: PH.USER_HOLD_FLAG hold_flag --for order status
1470:
1471: FROM
1472:
1473: PO_HEADERS PH,
1474: PO_VENDORS PV,
1475: PO_VENDOR_SITES PVS,
1476: AP_CARDS AC,
1477: AP_CARD_PROGRAMS ACP,

Line 1530: PO_HEADERS PH,

1526: PR.HOLD_FLAG hold_flag --for order status
1527:
1528: FROM
1529:
1530: PO_HEADERS PH,
1531: PO_RELEASES PR,
1532: PO_VENDORS PV,
1533: PO_VENDOR_SITES PVS,
1534: AP_CARDS AC,