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 204: l_headers_csr PO_PDOI_TYPES.intf_cursor_type;

200: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
201: d_position NUMBER;
202:
203: -- cursor variable to point to currently processing row
204: l_headers_csr PO_PDOI_TYPES.intf_cursor_type;
205:
206: -- all header attribute values within a batch
207: l_headers PO_PDOI_TYPES.headers_rec_type;
208:

Line 207: l_headers PO_PDOI_TYPES.headers_rec_type;

203: -- cursor variable to point to currently processing row
204: l_headers_csr PO_PDOI_TYPES.intf_cursor_type;
205:
206: -- all header attribute values within a batch
207: l_headers PO_PDOI_TYPES.headers_rec_type;
208:
209: -- variable to track the largest intf_header_id processed so far
210: l_max_intf_header_id NUMBER := -1;
211:

Line 649: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;

645: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
646: d_position NUMBER;
647:
648: -- cursor variable defined for the query
649: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;
650:
651: -- all line attribute values within a batch
652: l_lines PO_PDOI_TYPES.lines_rec_type;
653:

Line 652: l_lines PO_PDOI_TYPES.lines_rec_type;

648: -- cursor variable defined for the query
649: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;
650:
651: -- all line attribute values within a batch
652: l_lines PO_PDOI_TYPES.lines_rec_type;
653:
654: -- variable to track the largest intf_line_id processed so far
655: l_max_intf_line_id NUMBER := -1;
656:

Line 1019: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;

1015: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1016: d_position NUMBER;
1017:
1018: -- cursor variable defined for the query
1019: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;
1020:
1021: -- all line attribute values within a batch
1022: l_lines PO_PDOI_TYPES.lines_rec_type;
1023:

Line 1022: l_lines PO_PDOI_TYPES.lines_rec_type;

1018: -- cursor variable defined for the query
1019: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;
1020:
1021: -- all line attribute values within a batch
1022: l_lines PO_PDOI_TYPES.lines_rec_type;
1023:
1024: -- variable to track the largest intf_line_id processed so far
1025: l_max_intf_line_id NUMBER := -1;
1026:

Line 1028: l_create_lines PO_PDOI_TYPES.lines_rec_type;

1024: -- variable to track the largest intf_line_id processed so far
1025: l_max_intf_line_id NUMBER := -1;
1026:
1027: -- lines that are going to be created/updated
1028: l_create_lines PO_PDOI_TYPES.lines_rec_type;
1029: l_update_lines PO_PDOI_TYPES.lines_rec_type;
1030:
1031: /* bug 6926550 Added the following variable to null the
1032: l_create_lines and l_update_lines inside the procedure*/

Line 1029: l_update_lines PO_PDOI_TYPES.lines_rec_type;

1025: l_max_intf_line_id NUMBER := -1;
1026:
1027: -- lines that are going to be created/updated
1028: l_create_lines PO_PDOI_TYPES.lines_rec_type;
1029: l_update_lines PO_PDOI_TYPES.lines_rec_type;
1030:
1031: /* bug 6926550 Added the following variable to null the
1032: l_create_lines and l_update_lines inside the procedure*/
1033: l_null_lines PO_PDOI_TYPES.lines_rec_type;

Line 1033: l_null_lines PO_PDOI_TYPES.lines_rec_type;

1029: l_update_lines PO_PDOI_TYPES.lines_rec_type;
1030:
1031: /* bug 6926550 Added the following variable to null the
1032: l_create_lines and l_update_lines inside the procedure*/
1033: l_null_lines PO_PDOI_TYPES.lines_rec_type;
1034:
1035: -- line grouping num
1036: l_group_num NUMBER := 0;
1037:

Line 1372: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

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

Line 1534: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

1530: ------------------------------------------------------------------------
1531: PROCEDURE process_update_lines_in_group
1532: (
1533: p_group_num IN NUMBER,
1534: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
1535: ) IS
1536:
1537: d_api_name CONSTANT VARCHAR2(30) := 'process_update_lines_in_group';
1538: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1675: l_line_locs_csr PO_PDOI_TYPES.intf_cursor_type;

1671: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1672: d_position NUMBER;
1673:
1674: -- cursor variable defined for the query
1675: l_line_locs_csr PO_PDOI_TYPES.intf_cursor_type;
1676:
1677: -- all line location attribute values within a batch
1678: l_line_locs PO_PDOI_TYPES.line_locs_rec_type;
1679:

Line 1678: l_line_locs PO_PDOI_TYPES.line_locs_rec_type;

1674: -- cursor variable defined for the query
1675: l_line_locs_csr PO_PDOI_TYPES.intf_cursor_type;
1676:
1677: -- all line location attribute values within a batch
1678: l_line_locs PO_PDOI_TYPES.line_locs_rec_type;
1679:
1680: -- variables to track the records that need to be rejected due
1681: -- to errors in the processing
1682: l_rej_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 2008: l_dists PO_PDOI_TYPES.distributions_rec_type;

2004: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2005: d_position NUMBER;
2006:
2007: -- record to hold distribution values read within a batch
2008: l_dists PO_PDOI_TYPES.distributions_rec_type;
2009:
2010: -- cursor variable to point to currently processing row
2011: l_dists_csr PO_PDOI_TYPES.intf_cursor_type;
2012:

Line 2011: l_dists_csr PO_PDOI_TYPES.intf_cursor_type;

2007: -- record to hold distribution values read within a batch
2008: l_dists PO_PDOI_TYPES.distributions_rec_type;
2009:
2010: -- cursor variable to point to currently processing row
2011: l_dists_csr PO_PDOI_TYPES.intf_cursor_type;
2012:
2013: -- variables to track the records that need to be rejected due
2014: -- to errors in the processing
2015: l_rej_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 2230: l_price_diffs PO_PDOI_TYPES.price_diffs_rec_type;

2226: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2227: d_position NUMBER;
2228:
2229: -- record to hold price differential values read within a batch
2230: l_price_diffs PO_PDOI_TYPES.price_diffs_rec_type;
2231:
2232: -- cursor variable to point to currently processing row
2233: l_price_diffs_csr PO_PDOI_TYPES.intf_cursor_type;
2234:

Line 2233: l_price_diffs_csr PO_PDOI_TYPES.intf_cursor_type;

2229: -- record to hold price differential values read within a batch
2230: l_price_diffs PO_PDOI_TYPES.price_diffs_rec_type;
2231:
2232: -- cursor variable to point to currently processing row
2233: l_price_diffs_csr PO_PDOI_TYPES.intf_cursor_type;
2234:
2235: -- variables to track the records that need to be rejected due
2236: -- to errors in the processing
2237: l_rej_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 2534: l_attr_values PO_PDOI_TYPES.attr_values_rec_type;

2530: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2531: d_position NUMBER;
2532:
2533: -- record to hold attribute values read within a batch
2534: l_attr_values PO_PDOI_TYPES.attr_values_rec_type;
2535:
2536: -- cursor variable to point to currently processing row
2537: l_attr_values_csr PO_PDOI_TYPES.intf_cursor_type;
2538:

Line 2537: l_attr_values_csr PO_PDOI_TYPES.intf_cursor_type;

2533: -- record to hold attribute values read within a batch
2534: l_attr_values PO_PDOI_TYPES.attr_values_rec_type;
2535:
2536: -- cursor variable to point to currently processing row
2537: l_attr_values_csr PO_PDOI_TYPES.intf_cursor_type;
2538:
2539: -- pl/sql table to track rows that needs to be created or updated
2540: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;
2541:

Line 2733: l_attr_values_tlp PO_PDOI_TYPES.attr_values_tlp_rec_type;

2729: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2730: d_position NUMBER;
2731:
2732: -- record to hold attribute tlp values read within a batch
2733: l_attr_values_tlp PO_PDOI_TYPES.attr_values_tlp_rec_type;
2734:
2735: -- cursor variable to point to currently processing row
2736: l_attr_values_tlp_csr PO_PDOI_TYPES.intf_cursor_type;
2737:

Line 2736: l_attr_values_tlp_csr PO_PDOI_TYPES.intf_cursor_type;

2732: -- record to hold attribute tlp values read within a batch
2733: l_attr_values_tlp PO_PDOI_TYPES.attr_values_tlp_rec_type;
2734:
2735: -- cursor variable to point to currently processing row
2736: l_attr_values_tlp_csr PO_PDOI_TYPES.intf_cursor_type;
2737:
2738: -- pl/sql table to track rows that needs to be created or updated
2739: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;
2740:

Line 2920: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;

2916: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2917: d_position NUMBER;
2918:
2919: -- cursor variable defined for the query
2920: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;
2921:
2922: -- all line attribute values within a batch
2923: l_lines PO_PDOI_TYPES.lines_rec_type;
2924:

Line 2923: l_lines PO_PDOI_TYPES.lines_rec_type;

2919: -- cursor variable defined for the query
2920: l_lines_csr PO_PDOI_TYPES.intf_cursor_type;
2921:
2922: -- all line attribute values within a batch
2923: l_lines PO_PDOI_TYPES.lines_rec_type;
2924:
2925: -- variable to track the largest intf_line_id processed so far
2926: l_max_intf_line_id NUMBER := -1;
2927: