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_PDOI_LINE_PROCESS_PVT dependencies on PO_PDOI_TYPES

Line 176: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

172:
173: PROCEDURE match_lines_on_line_num
174: (
175: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
176: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
177: );
178:
179: PROCEDURE match_lines_on_item_info
180: (

Line 181: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

177: );
178:
179: PROCEDURE match_lines_on_item_info
180: (
181: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
182: );
183:
184: PROCEDURE copy_lines
185: (

Line 186: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,

182: );
183:
184: PROCEDURE copy_lines
185: (
186: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,
187: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,
188: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
189: );
190:

Line 188: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

184: PROCEDURE copy_lines
185: (
186: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,
187: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,
188: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
189: );
190:
191: PROCEDURE uniqueness_check_on_desc
192: (

Line 196: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

192: (
193: p_key IN po_session_gt.key%TYPE,
194: p_group_num IN NUMBER,
195: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
196: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
197: );
198:
199: PROCEDURE uniqueness_check_on_item
200: (

Line 204: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

200: (
201: p_key IN po_session_gt.key%TYPE,
202: p_group_num IN NUMBER,
203: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
204: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
205: );
206:
207: PROCEDURE uniqueness_check_on_vpn
208: (

Line 212: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

208: (
209: p_key IN po_session_gt.key%TYPE,
210: p_group_num IN NUMBER,
211: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
212: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
213: );
214:
215: PROCEDURE uniqueness_check_on_job
216: (

Line 220: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

216: (
217: p_key IN po_session_gt.key%TYPE,
218: p_group_num IN NUMBER,
219: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
220: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
221: );
222:
223: PROCEDURE uniqueness_check_on_line_num
224: (

Line 228: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

224: (
225: p_key IN po_session_gt.key%TYPE,
226: p_group_num IN NUMBER,
227: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
228: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
229: );
230:
231:
232: PROCEDURE set_action_add

Line 239: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

235: p_group_num IN NUMBER,
236: p_target_lines_index_tbl IN PO_TBL_NUMBER,
237: p_check_line_num_assign IN VARCHAR2,
238: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
239: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
240: );
241:
242:
243: PROCEDURE validate_attr_tlp

Line 245: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

241:
242:
243: PROCEDURE validate_attr_tlp
244: (
245: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
246: );
247:
248: PROCEDURE populate_error_flag
249: (

Line 251: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

247:
248: PROCEDURE populate_error_flag
249: (
250: x_results IN po_validation_results_type,
251: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
252: );
253:
254: PROCEDURE handle_err_tolerance
255: (

Line 256: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

252: );
253:
254: PROCEDURE handle_err_tolerance
255: (
256: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
257: );
258:
259: --------------------------------------------------------------------------
260: ---------------------- PUBLIC PROCEDURES ---------------------------------

Line 616: x_lines_csr OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type

612: PROCEDURE open_lines
613: (
614: p_data_set_type IN NUMBER,
615: p_max_intf_line_id IN NUMBER,
616: x_lines_csr OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type
617: ) IS
618:
619: d_api_name CONSTANT VARCHAR2(30) := 'open_lines';
620: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1357: x_lines_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,

1353: --End of Comments
1354: ------------------------------------------------------------------------
1355: PROCEDURE fetch_lines
1356: (
1357: x_lines_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
1358: x_lines OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
1359: ) IS
1360:
1361: d_api_name CONSTANT VARCHAR2(30) := 'fetch_lines';

Line 1358: x_lines OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

1354: ------------------------------------------------------------------------
1355: PROCEDURE fetch_lines
1356: (
1357: x_lines_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
1358: x_lines OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
1359: ) IS
1360:
1361: d_api_name CONSTANT VARCHAR2(30) := 'fetch_lines';
1362: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1522: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

1518: --End of Comments
1519: ------------------------------------------------------------------------
1520: PROCEDURE derive_lines
1521: (
1522: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
1523: ) IS
1524:
1525: d_api_name CONSTANT VARCHAR2(30) := 'derive_lines';
1526: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2020: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

2016: --End of Comments
2017: ------------------------------------------------------------------------
2018: PROCEDURE derive_lines_for_update
2019: (
2020: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
2021: ) IS
2022:
2023: d_api_name CONSTANT VARCHAR2(30) := 'derive_lines_for_update';
2024: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2231: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

2227: --End of Comments
2228: ------------------------------------------------------------------------
2229: PROCEDURE default_lines
2230: (
2231: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
2232: ) IS
2233:
2234: d_api_name CONSTANT VARCHAR2(30) := 'default_lines';
2235: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2645: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

2641: --End of Comments
2642: ------------------------------------------------------------------------
2643: PROCEDURE default_lines_for_update
2644: (
2645: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
2646: ) IS
2647:
2648: d_api_name CONSTANT VARCHAR2(30) := 'default_lines_for_update';
2649: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2774: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

2770: ------------------------------------------------------------------------
2771: PROCEDURE match_lines
2772: (
2773: p_data_set_type IN NUMBER, -- bug5129752
2774: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
2775: ) IS
2776:
2777: d_api_name CONSTANT VARCHAR2(30) := 'match_lines';
2778: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2783: l_create_lines PO_PDOI_TYPES.lines_rec_type;

2779: d_position NUMBER;
2780:
2781: l_index_tbl DBMS_SQL.NUMBER_TABLE;
2782:
2783: l_create_lines PO_PDOI_TYPES.lines_rec_type;
2784: l_update_lines PO_PDOI_TYPES.lines_rec_type;
2785:
2786: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2787: BEGIN

Line 2784: l_update_lines PO_PDOI_TYPES.lines_rec_type;

2780:
2781: l_index_tbl DBMS_SQL.NUMBER_TABLE;
2782:
2783: l_create_lines PO_PDOI_TYPES.lines_rec_type;
2784: l_update_lines PO_PDOI_TYPES.lines_rec_type;
2785:
2786: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2787: BEGIN
2788: d_position := 0;

Line 2973: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

2969: --End of Comments
2970: ------------------------------------------------------------------------
2971: PROCEDURE check_line_locations
2972: (
2973: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
2974: ) IS
2975:
2976: d_api_name CONSTANT VARCHAR2(30) := 'check_line_locations';
2977: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3106: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

3102: --End of Comments
3103: ------------------------------------------------------------------------
3104: PROCEDURE update_line_intf_tbl
3105: (
3106: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
3107: ) IS
3108:
3109: d_api_name CONSTANT VARCHAR2(30) := 'update_line_intf_tbl';
3110: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3203: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,

3199: (
3200: p_type IN NUMBER,
3201: p_group_num IN NUMBER,
3202: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
3203: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
3204: x_expire_line_id_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
3205: ) IS
3206:
3207: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check';

Line 3459: p_lines IN PO_PDOI_TYPES.lines_rec_type,

3455: ------------------------------------------------------------------------
3456: PROCEDURE split_lines
3457: (
3458: p_group_num IN NUMBER,
3459: p_lines IN PO_PDOI_TYPES.lines_rec_type,
3460: x_create_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
3461: x_update_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
3462: ) IS
3463:

Line 3460: x_create_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,

3456: PROCEDURE split_lines
3457: (
3458: p_group_num IN NUMBER,
3459: p_lines IN PO_PDOI_TYPES.lines_rec_type,
3460: x_create_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
3461: x_update_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
3462: ) IS
3463:
3464: d_api_name CONSTANT VARCHAR2(30) := 'split_lines';

Line 3461: x_update_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

3457: (
3458: p_group_num IN NUMBER,
3459: p_lines IN PO_PDOI_TYPES.lines_rec_type,
3460: x_create_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
3461: x_update_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
3462: ) IS
3463:
3464: d_api_name CONSTANT VARCHAR2(30) := 'split_lines';
3465: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3558: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

3554: ------------------------------------------------------------------------
3555: PROCEDURE validate_lines
3556: (
3557: p_action IN VARCHAR2 DEFAULT 'CREATE',
3558: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
3559: ) IS
3560:
3561: d_api_name CONSTANT VARCHAR2(30) := 'validate_lines';
3562: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5725: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

5721: ------------------------------------------------------------------------
5722: PROCEDURE match_lines_on_line_num
5723: (
5724: p_index_tbl DBMS_SQL.NUMBER_TABLE,
5725: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
5726: ) IS
5727:
5728: d_api_name CONSTANT VARCHAR2(30) := 'match_lines_on_line_num';
5729: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 5872: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

5868: --End of Comments
5869: ------------------------------------------------------------------------
5870: PROCEDURE match_lines_on_item_info
5871: (
5872: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
5873: ) IS
5874:
5875: d_api_name CONSTANT VARCHAR2(30) := 'match_lines_on_item_info';
5876: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6216: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,

6212: --End of Comments
6213: ------------------------------------------------------------------------
6214: PROCEDURE copy_lines
6215: (
6216: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,
6217: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6218: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6219: ) IS
6220:

Line 6218: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

6214: PROCEDURE copy_lines
6215: (
6216: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,
6217: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6218: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6219: ) IS
6220:
6221: d_api_name CONSTANT VARCHAR2(30) := 'copy_lines';
6222: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6235: -- Refactored the code as PO_PDOI_TYPES.fill_all_lines_attr already does

6231: PO_LOG.proc_begin(d_module);
6232: END IF;
6233:
6234: -- bug5107324
6235: -- Refactored the code as PO_PDOI_TYPES.fill_all_lines_attr already does
6236: -- all the initialization work for all attributes in lines
6237:
6238: -- bug5129752
6239: -- Move the initialization up front

Line 6242: PO_PDOI_TYPES.fill_all_lines_attr

6238: -- bug5129752
6239: -- Move the initialization up front
6240:
6241: -- initialize the tables
6242: PO_PDOI_TYPES.fill_all_lines_attr
6243: ( p_num_records => p_source_index_tbl.COUNT,
6244: x_lines => x_target_lines
6245: );
6246:

Line 6433: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

6429: (
6430: p_key IN po_session_gt.key%TYPE,
6431: p_group_num IN NUMBER,
6432: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
6433: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6434: ) IS
6435:
6436: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_desc';
6437: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6687: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

6683: (
6684: p_key IN po_session_gt.key%TYPE,
6685: p_group_num IN NUMBER,
6686: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
6687: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6688: ) IS
6689:
6690: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_item';
6691: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6989: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

6985: (
6986: p_key IN po_session_gt.key%TYPE,
6987: p_group_num IN NUMBER,
6988: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
6989: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6990: ) IS
6991:
6992: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_vpn';
6993: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 7247: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

7243: (
7244: p_key IN po_session_gt.key%TYPE,
7245: p_group_num IN NUMBER,
7246: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7247: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7248: ) IS
7249:
7250: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_job';
7251: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 7502: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

7498: (
7499: p_key IN po_session_gt.key%TYPE,
7500: p_group_num IN NUMBER,
7501: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7502: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7503: ) IS
7504:
7505: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_line_num';
7506: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 7724: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

7720: p_group_num IN NUMBER,
7721: p_target_lines_index_tbl IN PO_TBL_NUMBER,
7722: p_check_line_num_assign IN VARCHAR2,
7723: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7724: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7725: ) IS
7726:
7727:
7728: d_api_name CONSTANT VARCHAR2(30) := 'set_action_add';

Line 7823: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

7819: --End of Comments
7820: ------------------------------------------------------------------------
7821: PROCEDURE validate_attr_tlp
7822: (
7823: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7824: ) IS
7825:
7826: d_api_name CONSTANT VARCHAR2(30) := 'validate_attr_tlp';
7827: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 7943: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

7939: ------------------------------------------------------------------------
7940: PROCEDURE populate_error_flag
7941: (
7942: x_results IN po_validation_results_type,
7943: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7944: ) IS
7945:
7946: d_api_name CONSTANT VARCHAR2(30) := 'populate_error_flag';
7947: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 8018: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

8014: --End of Comments
8015: ------------------------------------------------------------------------
8016: PROCEDURE handle_err_tolerance
8017: (
8018: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8019: ) IS
8020:
8021: d_api_name CONSTANT VARCHAR2(30) := 'handle_err_tolerance';
8022: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';