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.

[Home] [Help]

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: --CLM PDOI Integration Starts
260: PROCEDURE derive_contract_type

Line 701: x_lines_csr OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type

697: PROCEDURE open_lines
698: (
699: p_data_set_type IN NUMBER,
700: p_max_intf_line_id IN NUMBER,
701: x_lines_csr OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type
702: ) IS
703:
704: d_api_name CONSTANT VARCHAR2(30) := 'open_lines';
705: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1886: x_lines_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,

1882: --End of Comments
1883: ------------------------------------------------------------------------
1884: PROCEDURE fetch_lines
1885: (
1886: x_lines_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
1887: x_lines OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
1888: ) IS
1889:
1890: d_api_name CONSTANT VARCHAR2(30) := 'fetch_lines';

Line 1887: x_lines OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

1883: ------------------------------------------------------------------------
1884: PROCEDURE fetch_lines
1885: (
1886: x_lines_csr IN OUT NOCOPY PO_PDOI_TYPES.intf_cursor_type,
1887: x_lines OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
1888: ) IS
1889:
1890: d_api_name CONSTANT VARCHAR2(30) := 'fetch_lines';
1891: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2096: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

2092: --End of Comments
2093: ------------------------------------------------------------------------
2094: PROCEDURE derive_lines
2095: (
2096: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
2097: ) IS
2098:
2099: d_api_name CONSTANT VARCHAR2(30) := 'derive_lines';
2100: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2814: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

2810: --End of Comments
2811: ------------------------------------------------------------------------
2812: PROCEDURE derive_lines_for_update
2813: (
2814: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
2815: ) IS
2816:
2817: d_api_name CONSTANT VARCHAR2(30) := 'derive_lines_for_update';
2818: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3051: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

3047: --End of Comments
3048: ------------------------------------------------------------------------
3049: PROCEDURE default_lines
3050: (
3051: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
3052: ) IS
3053:
3054: d_api_name CONSTANT VARCHAR2(30) := 'default_lines';
3055: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3535: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

3531: --End of Comments
3532: ------------------------------------------------------------------------
3533: PROCEDURE default_lines_for_update
3534: (
3535: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
3536: ) IS
3537:
3538: d_api_name CONSTANT VARCHAR2(30) := 'default_lines_for_update';
3539: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3670: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

3666: ------------------------------------------------------------------------
3667: PROCEDURE match_lines
3668: (
3669: p_data_set_type IN NUMBER, -- bug5129752
3670: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
3671: ) IS
3672:
3673: d_api_name CONSTANT VARCHAR2(30) := 'match_lines';
3674: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3679: l_create_lines PO_PDOI_TYPES.lines_rec_type;

3675: d_position NUMBER;
3676:
3677: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3678:
3679: l_create_lines PO_PDOI_TYPES.lines_rec_type;
3680: l_update_lines PO_PDOI_TYPES.lines_rec_type;
3681:
3682: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3683: BEGIN

Line 3680: l_update_lines PO_PDOI_TYPES.lines_rec_type;

3676:
3677: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3678:
3679: l_create_lines PO_PDOI_TYPES.lines_rec_type;
3680: l_update_lines PO_PDOI_TYPES.lines_rec_type;
3681:
3682: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3683: BEGIN
3684: d_position := 0;

Line 3869: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

3865: --End of Comments
3866: ------------------------------------------------------------------------
3867: PROCEDURE check_line_locations
3868: (
3869: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
3870: ) IS
3871:
3872: d_api_name CONSTANT VARCHAR2(30) := 'check_line_locations';
3873: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4002: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

3998: --End of Comments
3999: ------------------------------------------------------------------------
4000: PROCEDURE update_line_intf_tbl
4001: (
4002: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
4003: ) IS
4004:
4005: d_api_name CONSTANT VARCHAR2(30) := 'update_line_intf_tbl';
4006: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4102: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,

4098: (
4099: p_type IN NUMBER,
4100: p_group_num IN NUMBER,
4101: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
4102: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
4103: x_expire_line_id_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
4104: ) IS
4105:
4106: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check';

Line 4358: p_lines IN PO_PDOI_TYPES.lines_rec_type,

4354: ------------------------------------------------------------------------
4355: PROCEDURE split_lines
4356: (
4357: p_group_num IN NUMBER,
4358: p_lines IN PO_PDOI_TYPES.lines_rec_type,
4359: x_create_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
4360: x_update_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
4361: ) IS
4362:

Line 4359: x_create_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,

4355: PROCEDURE split_lines
4356: (
4357: p_group_num IN NUMBER,
4358: p_lines IN PO_PDOI_TYPES.lines_rec_type,
4359: x_create_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
4360: x_update_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
4361: ) IS
4362:
4363: d_api_name CONSTANT VARCHAR2(30) := 'split_lines';

Line 4360: x_update_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

4356: (
4357: p_group_num IN NUMBER,
4358: p_lines IN PO_PDOI_TYPES.lines_rec_type,
4359: x_create_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
4360: x_update_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
4361: ) IS
4362:
4363: d_api_name CONSTANT VARCHAR2(30) := 'split_lines';
4364: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4457: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

4453: ------------------------------------------------------------------------
4454: PROCEDURE validate_lines
4455: (
4456: p_action IN VARCHAR2 DEFAULT 'CREATE',
4457: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
4458: ) IS
4459:
4460: d_api_name CONSTANT VARCHAR2(30) := 'validate_lines';
4461: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6647: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

6643: ------------------------------------------------------------------------
6644: PROCEDURE match_lines_on_line_num
6645: (
6646: p_index_tbl DBMS_SQL.NUMBER_TABLE,
6647: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6648: ) IS
6649:
6650: d_api_name CONSTANT VARCHAR2(30) := 'match_lines_on_line_num';
6651: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 6797: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

6793: --End of Comments
6794: ------------------------------------------------------------------------
6795: PROCEDURE match_lines_on_item_info
6796: (
6797: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6798: ) IS
6799:
6800: d_api_name CONSTANT VARCHAR2(30) := 'match_lines_on_item_info';
6801: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 7144: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,

7140: --End of Comments
7141: ------------------------------------------------------------------------
7142: PROCEDURE copy_lines
7143: (
7144: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,
7145: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,
7146: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7147: ) IS
7148:

Line 7146: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

7142: PROCEDURE copy_lines
7143: (
7144: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,
7145: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,
7146: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7147: ) IS
7148:
7149: d_api_name CONSTANT VARCHAR2(30) := 'copy_lines';
7150: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

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

7159: PO_LOG.proc_begin(d_module);
7160: END IF;
7161:
7162: -- bug5107324
7163: -- Refactored the code as PO_PDOI_TYPES.fill_all_lines_attr already does
7164: -- all the initialization work for all attributes in lines
7165:
7166: -- bug5129752
7167: -- Move the initialization up front

Line 7170: PO_PDOI_TYPES.fill_all_lines_attr

7166: -- bug5129752
7167: -- Move the initialization up front
7168:
7169: -- initialize the tables
7170: PO_PDOI_TYPES.fill_all_lines_attr
7171: ( p_num_records => p_source_index_tbl.COUNT,
7172: x_lines => x_target_lines
7173: );
7174:

Line 7400: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

7396: (
7397: p_key IN po_session_gt.key%TYPE,
7398: p_group_num IN NUMBER,
7399: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7400: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7401: ) IS
7402:
7403: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_desc';
7404: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 7654: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

7650: (
7651: p_key IN po_session_gt.key%TYPE,
7652: p_group_num IN NUMBER,
7653: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7654: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7655: ) IS
7656:
7657: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_item';
7658: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 7956: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

7952: (
7953: p_key IN po_session_gt.key%TYPE,
7954: p_group_num IN NUMBER,
7955: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7956: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7957: ) IS
7958:
7959: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_vpn';
7960: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 8214: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

8210: (
8211: p_key IN po_session_gt.key%TYPE,
8212: p_group_num IN NUMBER,
8213: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
8214: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8215: ) IS
8216:
8217: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_job';
8218: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 8469: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

8465: (
8466: p_key IN po_session_gt.key%TYPE,
8467: p_group_num IN NUMBER,
8468: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
8469: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8470: ) IS
8471:
8472: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_line_num';
8473: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 8691: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

8687: p_group_num IN NUMBER,
8688: p_target_lines_index_tbl IN PO_TBL_NUMBER,
8689: p_check_line_num_assign IN VARCHAR2,
8690: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
8691: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8692: ) IS
8693:
8694:
8695: d_api_name CONSTANT VARCHAR2(30) := 'set_action_add';

Line 8790: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

8786: --End of Comments
8787: ------------------------------------------------------------------------
8788: PROCEDURE validate_attr_tlp
8789: (
8790: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8791: ) IS
8792:
8793: d_api_name CONSTANT VARCHAR2(30) := 'validate_attr_tlp';
8794: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 8910: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

8906: ------------------------------------------------------------------------
8907: PROCEDURE populate_error_flag
8908: (
8909: x_results IN po_validation_results_type,
8910: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8911: ) IS
8912:
8913: d_api_name CONSTANT VARCHAR2(30) := 'populate_error_flag';
8914: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 8985: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

8981: --End of Comments
8982: ------------------------------------------------------------------------
8983: PROCEDURE handle_err_tolerance
8984: (
8985: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8986: ) IS
8987:
8988: d_api_name CONSTANT VARCHAR2(30) := 'handle_err_tolerance';
8989: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';