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

Line 31: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

27: PROCEDURE process_create_lines_in_group
28: (
29: p_group_num IN NUMBER,
30: p_expire_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
31: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
32: );
33:
34: PROCEDURE process_update_lines_in_group
35: (

Line 37: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

33:
34: PROCEDURE process_update_lines_in_group
35: (
36: p_group_num IN NUMBER,
37: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
38: );
39:
40: PROCEDURE process_line_locations;
41:

Line 189: l_headers_csr PO_PDOI_TYPES.intf_cursor_type;

185: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
186: d_position NUMBER;
187:
188: -- cursor variable to point to currently processing row
189: l_headers_csr PO_PDOI_TYPES.intf_cursor_type;
190:
191: -- all header attribute values within a batch
192: l_headers PO_PDOI_TYPES.headers_rec_type;
193:

Line 192: l_headers PO_PDOI_TYPES.headers_rec_type;

188: -- cursor variable to point to currently processing row
189: l_headers_csr PO_PDOI_TYPES.intf_cursor_type;
190:
191: -- all header attribute values within a batch
192: l_headers PO_PDOI_TYPES.headers_rec_type;
193:
194: -- variable to track the largest intf_header_id processed so far
195: l_max_intf_header_id NUMBER := -1;
196:

Line 516: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;

512: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
513: d_position NUMBER;
514:
515: -- cursor variable defined for the query
516: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;
517:
518: -- all line attribute values within a batch
519: l_lines PO_PDOI_TYPES.lines_rec_type;
520:

Line 519: l_lines PO_PDOI_TYPES.lines_rec_type;

515: -- cursor variable defined for the query
516: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;
517:
518: -- all line attribute values within a batch
519: l_lines PO_PDOI_TYPES.lines_rec_type;
520:
521: -- variable to track the largest intf_line_id processed so far
522: l_max_intf_line_id NUMBER := -1;
523:

Line 856: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;

852: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
853: d_position NUMBER;
854:
855: -- cursor variable defined for the query
856: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;
857:
858: -- all line attribute values within a batch
859: l_lines PO_PDOI_TYPES.lines_rec_type;
860:

Line 859: l_lines PO_PDOI_TYPES.lines_rec_type;

855: -- cursor variable defined for the query
856: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;
857:
858: -- all line attribute values within a batch
859: l_lines PO_PDOI_TYPES.lines_rec_type;
860:
861: -- variable to track the largest intf_line_id processed so far
862: l_max_intf_line_id NUMBER := -1;
863:

Line 865: l_create_lines PO_PDOI_TYPES.lines_rec_type;

861: -- variable to track the largest intf_line_id processed so far
862: l_max_intf_line_id NUMBER := -1;
863:
864: -- lines that are going to be created/updated
865: l_create_lines PO_PDOI_TYPES.lines_rec_type;
866: l_update_lines PO_PDOI_TYPES.lines_rec_type;
867:
868: /* bug 6926550 Added the following variable to null the
869: l_create_lines and l_update_lines inside the procedure*/

Line 866: l_update_lines PO_PDOI_TYPES.lines_rec_type;

862: l_max_intf_line_id NUMBER := -1;
863:
864: -- lines that are going to be created/updated
865: l_create_lines PO_PDOI_TYPES.lines_rec_type;
866: l_update_lines PO_PDOI_TYPES.lines_rec_type;
867:
868: /* bug 6926550 Added the following variable to null the
869: l_create_lines and l_update_lines inside the procedure*/
870: l_null_lines PO_PDOI_TYPES.lines_rec_type;

Line 870: l_null_lines PO_PDOI_TYPES.lines_rec_type;

866: l_update_lines PO_PDOI_TYPES.lines_rec_type;
867:
868: /* bug 6926550 Added the following variable to null the
869: l_create_lines and l_update_lines inside the procedure*/
870: l_null_lines PO_PDOI_TYPES.lines_rec_type;
871:
872: -- line grouping num
873: l_group_num NUMBER := 0;
874:

Line 1209: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

1205: PROCEDURE process_create_lines_in_group
1206: (
1207: p_group_num IN NUMBER,
1208: p_expire_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1209: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
1210: ) IS
1211:
1212: d_api_name CONSTANT VARCHAR2(30) := 'process_create_lines_in_group';
1213: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1371: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

1367: ------------------------------------------------------------------------
1368: PROCEDURE process_update_lines_in_group
1369: (
1370: p_group_num IN NUMBER,
1371: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
1372: ) IS
1373:
1374: d_api_name CONSTANT VARCHAR2(30) := 'process_update_lines_in_group';
1375: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1512: l_line_locs_csr PO_PDOI_TYPES.intf_cursor_type;

1508: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1509: d_position NUMBER;
1510:
1511: -- cursor variable defined for the query
1512: l_line_locs_csr PO_PDOI_TYPES.intf_cursor_type;
1513:
1514: -- all line location attribute values within a batch
1515: l_line_locs PO_PDOI_TYPES.line_locs_rec_type;
1516:

Line 1515: l_line_locs PO_PDOI_TYPES.line_locs_rec_type;

1511: -- cursor variable defined for the query
1512: l_line_locs_csr PO_PDOI_TYPES.intf_cursor_type;
1513:
1514: -- all line location attribute values within a batch
1515: l_line_locs PO_PDOI_TYPES.line_locs_rec_type;
1516:
1517: -- variables to track the records that need to be rejected due
1518: -- to errors in the processing
1519: l_rej_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 1845: l_dists PO_PDOI_TYPES.distributions_rec_type;

1841: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1842: d_position NUMBER;
1843:
1844: -- record to hold distribution values read within a batch
1845: l_dists PO_PDOI_TYPES.distributions_rec_type;
1846:
1847: -- cursor variable to point to currently processing row
1848: l_dists_csr PO_PDOI_TYPES.intf_cursor_type;
1849:

Line 1848: l_dists_csr PO_PDOI_TYPES.intf_cursor_type;

1844: -- record to hold distribution values read within a batch
1845: l_dists PO_PDOI_TYPES.distributions_rec_type;
1846:
1847: -- cursor variable to point to currently processing row
1848: l_dists_csr PO_PDOI_TYPES.intf_cursor_type;
1849:
1850: -- variables to track the records that need to be rejected due
1851: -- to errors in the processing
1852: l_rej_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 2067: l_price_diffs PO_PDOI_TYPES.price_diffs_rec_type;

2063: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2064: d_position NUMBER;
2065:
2066: -- record to hold price differential values read within a batch
2067: l_price_diffs PO_PDOI_TYPES.price_diffs_rec_type;
2068:
2069: -- cursor variable to point to currently processing row
2070: l_price_diffs_csr PO_PDOI_TYPES.intf_cursor_type;
2071:

Line 2070: l_price_diffs_csr PO_PDOI_TYPES.intf_cursor_type;

2066: -- record to hold price differential values read within a batch
2067: l_price_diffs PO_PDOI_TYPES.price_diffs_rec_type;
2068:
2069: -- cursor variable to point to currently processing row
2070: l_price_diffs_csr PO_PDOI_TYPES.intf_cursor_type;
2071:
2072: -- variables to track the records that need to be rejected due
2073: -- to errors in the processing
2074: l_rej_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 2371: l_attr_values PO_PDOI_TYPES.attr_values_rec_type;

2367: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2368: d_position NUMBER;
2369:
2370: -- record to hold attribute values read within a batch
2371: l_attr_values PO_PDOI_TYPES.attr_values_rec_type;
2372:
2373: -- cursor variable to point to currently processing row
2374: l_attr_values_csr PO_PDOI_TYPES.intf_cursor_type;
2375:

Line 2374: l_attr_values_csr PO_PDOI_TYPES.intf_cursor_type;

2370: -- record to hold attribute values read within a batch
2371: l_attr_values PO_PDOI_TYPES.attr_values_rec_type;
2372:
2373: -- cursor variable to point to currently processing row
2374: l_attr_values_csr PO_PDOI_TYPES.intf_cursor_type;
2375:
2376: -- pl/sql table to track rows that needs to be created or updated
2377: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;
2378:

Line 2564: l_attr_values_tlp PO_PDOI_TYPES.attr_values_tlp_rec_type;

2560: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2561: d_position NUMBER;
2562:
2563: -- record to hold attribute tlp values read within a batch
2564: l_attr_values_tlp PO_PDOI_TYPES.attr_values_tlp_rec_type;
2565:
2566: -- cursor variable to point to currently processing row
2567: l_attr_values_tlp_csr PO_PDOI_TYPES.intf_cursor_type;
2568:

Line 2567: l_attr_values_tlp_csr PO_PDOI_TYPES.intf_cursor_type;

2563: -- record to hold attribute tlp values read within a batch
2564: l_attr_values_tlp PO_PDOI_TYPES.attr_values_tlp_rec_type;
2565:
2566: -- cursor variable to point to currently processing row
2567: l_attr_values_tlp_csr PO_PDOI_TYPES.intf_cursor_type;
2568:
2569: -- pl/sql table to track rows that needs to be created or updated
2570: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;
2571: