APPS.POR_HISTORY_FEED_PKG dependencies on PO_LINES

Line 96: CURSOR cur_po_lines (i_po_header_id IN NUMBER,

92: PROCEDURE Write_Detail_Record (
93: i_po_id IN NUMBER,
94: i_rel_id IN NUMBER) IS
95:
96: CURSOR cur_po_lines (i_po_header_id IN NUMBER,
97: i_release_id IN NUMBER) IS
98:
99: SELECT
100: po_number,

Line 152: IF cur_PO_lines%ISOPEN THEN

148: BEGIN
149:
150: l_progress := '000';
151:
152: IF cur_PO_lines%ISOPEN THEN
153: CLOSE cur_PO_lines;
154: END IF;
155:
156: FOR rec_line IN cur_po_lines (i_po_id,i_rel_id) LOOP

Line 153: CLOSE cur_PO_lines;

149:
150: l_progress := '000';
151:
152: IF cur_PO_lines%ISOPEN THEN
153: CLOSE cur_PO_lines;
154: END IF;
155:
156: FOR rec_line IN cur_po_lines (i_po_id,i_rel_id) LOOP
157: BEGIN

Line 156: FOR rec_line IN cur_po_lines (i_po_id,i_rel_id) LOOP

152: IF cur_PO_lines%ISOPEN THEN
153: CLOSE cur_PO_lines;
154: END IF;
155:
156: FOR rec_line IN cur_po_lines (i_po_id,i_rel_id) LOOP
157: BEGIN
158:
159: l_progress := '010';
160:

Line 1080: TYPE tab_uom IS TABLE OF po_lines.unit_meas_lookup_code%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;
1084: TYPE tab_unit_price IS TABLE OF po_lines.unit_price%TYPE;

Line 1082: TYPE tab_item_desc IS TABLE OF po_lines.item_description%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;
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;

Line 1084: TYPE tab_unit_price IS TABLE OF po_lines.unit_price%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;
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;

Line 1093: TYPE tab_line_cancel_flag IS TABLE OF po_lines.cancel_flag%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;
1097: l_rel_num tab_rel_num;

Line 1174: PO_LINES PL,

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,
1178: PO_VENDOR_SITES PVS,

Line 1250: PO_LINES PL,

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,
1254: PO_VENDOR_SITES PVS,

Line 1324: PO_LINES PL,

1320:
1321: FROM
1322: PO_HEADERS PH,
1323: PO_RELEASES PR,
1324: PO_LINES PL,
1325: PO_LINE_LOCATIONS PLL,
1326: PO_DISTRIBUTIONS PD,
1327: PO_VENDORS PV,
1328: PO_VENDOR_SITES PVS,

Line 1400: PO_LINES PL,

1396:
1397: FROM
1398: PO_HEADERS PH,
1399: PO_RELEASES PR,
1400: PO_LINES PL,
1401: PO_LINE_LOCATIONS PLL,
1402: PO_DISTRIBUTIONS PD,
1403: PO_VENDORS PV,
1404: PO_VENDOR_SITES PVS,