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_UTL_PVT dependencies on PO_TBL_NUMBER

Line 189: p_po_header_id_tbl IN PO_TBL_NUMBER,

185: --End of Comments
186: --------------------------------------------------------------------------
187: PROCEDURE calculate_max_line_num
188: (
189: p_po_header_id_tbl IN PO_TBL_NUMBER,
190: p_draft_id_tbl IN PO_TBL_NUMBER
191: ) IS
192:
193: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_line_num';

Line 190: p_draft_id_tbl IN PO_TBL_NUMBER

186: --------------------------------------------------------------------------
187: PROCEDURE calculate_max_line_num
188: (
189: p_po_header_id_tbl IN PO_TBL_NUMBER,
190: p_draft_id_tbl IN PO_TBL_NUMBER
191: ) IS
192:
193: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_line_num';
194: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 198: l_po_header_id_tbl PO_TBL_NUMBER;

194: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
195: d_position NUMBER;
196:
197: l_key po_session_gt.key%TYPE;
198: l_po_header_id_tbl PO_TBL_NUMBER;
199: l_max_line_num_tbl PO_TBL_NUMBER;
200:
201: l_processing_row_tbl DBMS_SQL.number_table;
202: l_po_header_id_no_dup_tbl DBMS_SQL.number_table;

Line 199: l_max_line_num_tbl PO_TBL_NUMBER;

195: d_position NUMBER;
196:
197: l_key po_session_gt.key%TYPE;
198: l_po_header_id_tbl PO_TBL_NUMBER;
199: l_max_line_num_tbl PO_TBL_NUMBER;
200:
201: l_processing_row_tbl DBMS_SQL.number_table;
202: l_po_header_id_no_dup_tbl DBMS_SQL.number_table;
203: BEGIN

Line 466: p_po_header_id_tbl IN PO_TBL_NUMBER,

462: --End of Comments
463: --------------------------------------------------------------------------
464: PROCEDURE check_line_num_unique
465: (
466: p_po_header_id_tbl IN PO_TBL_NUMBER,
467: p_draft_id_tbl IN PO_TBL_NUMBER,
468: p_intf_line_id_tbl IN PO_TBL_NUMBER,
469: p_line_num_tbl IN PO_TBL_NUMBER,
470: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 467: p_draft_id_tbl IN PO_TBL_NUMBER,

463: --------------------------------------------------------------------------
464: PROCEDURE check_line_num_unique
465: (
466: p_po_header_id_tbl IN PO_TBL_NUMBER,
467: p_draft_id_tbl IN PO_TBL_NUMBER,
468: p_intf_line_id_tbl IN PO_TBL_NUMBER,
469: p_line_num_tbl IN PO_TBL_NUMBER,
470: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
471: ) IS

Line 468: p_intf_line_id_tbl IN PO_TBL_NUMBER,

464: PROCEDURE check_line_num_unique
465: (
466: p_po_header_id_tbl IN PO_TBL_NUMBER,
467: p_draft_id_tbl IN PO_TBL_NUMBER,
468: p_intf_line_id_tbl IN PO_TBL_NUMBER,
469: p_line_num_tbl IN PO_TBL_NUMBER,
470: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
471: ) IS
472:

Line 469: p_line_num_tbl IN PO_TBL_NUMBER,

465: (
466: p_po_header_id_tbl IN PO_TBL_NUMBER,
467: p_draft_id_tbl IN PO_TBL_NUMBER,
468: p_intf_line_id_tbl IN PO_TBL_NUMBER,
469: p_line_num_tbl IN PO_TBL_NUMBER,
470: x_line_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
471: ) IS
472:
473: d_api_name CONSTANT VARCHAR2(30) := 'check_line_num_unique';

Line 600: p_po_line_id_tbl IN PO_TBL_NUMBER,

596: --End of Comments
597: --------------------------------------------------------------------------
598: PROCEDURE calculate_max_shipment_num
599: (
600: p_po_line_id_tbl IN PO_TBL_NUMBER,
601: p_draft_id_tbl IN PO_TBL_NUMBER
602: ) IS
603:
604: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_shipment_num';

Line 601: p_draft_id_tbl IN PO_TBL_NUMBER

597: --------------------------------------------------------------------------
598: PROCEDURE calculate_max_shipment_num
599: (
600: p_po_line_id_tbl IN PO_TBL_NUMBER,
601: p_draft_id_tbl IN PO_TBL_NUMBER
602: ) IS
603:
604: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_shipment_num';
605: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 609: l_po_line_id_tbl PO_TBL_NUMBER;

605: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
606: d_position NUMBER;
607:
608: l_key po_session_gt.key%TYPE;
609: l_po_line_id_tbl PO_TBL_NUMBER;
610: l_max_shipment_num_tbl PO_TBL_NUMBER;
611:
612: l_processing_row_tbl DBMS_SQL.number_table;
613: l_po_line_id_no_dup_tbl DBMS_SQL.number_table;

Line 610: l_max_shipment_num_tbl PO_TBL_NUMBER;

606: d_position NUMBER;
607:
608: l_key po_session_gt.key%TYPE;
609: l_po_line_id_tbl PO_TBL_NUMBER;
610: l_max_shipment_num_tbl PO_TBL_NUMBER;
611:
612: l_processing_row_tbl DBMS_SQL.number_table;
613: l_po_line_id_no_dup_tbl DBMS_SQL.number_table;
614: BEGIN

Line 895: p_po_line_id_tbl IN PO_TBL_NUMBER,

891: --End of Comments
892: --------------------------------------------------------------------------
893: PROCEDURE check_shipment_num_unique
894: (
895: p_po_line_id_tbl IN PO_TBL_NUMBER,
896: p_draft_id_tbl IN PO_TBL_NUMBER,
897: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
898: p_shipment_num_tbl IN PO_TBL_NUMBER,
899: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 896: p_draft_id_tbl IN PO_TBL_NUMBER,

892: --------------------------------------------------------------------------
893: PROCEDURE check_shipment_num_unique
894: (
895: p_po_line_id_tbl IN PO_TBL_NUMBER,
896: p_draft_id_tbl IN PO_TBL_NUMBER,
897: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
898: p_shipment_num_tbl IN PO_TBL_NUMBER,
899: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
900: ) IS

Line 897: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,

893: PROCEDURE check_shipment_num_unique
894: (
895: p_po_line_id_tbl IN PO_TBL_NUMBER,
896: p_draft_id_tbl IN PO_TBL_NUMBER,
897: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
898: p_shipment_num_tbl IN PO_TBL_NUMBER,
899: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
900: ) IS
901:

Line 898: p_shipment_num_tbl IN PO_TBL_NUMBER,

894: (
895: p_po_line_id_tbl IN PO_TBL_NUMBER,
896: p_draft_id_tbl IN PO_TBL_NUMBER,
897: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
898: p_shipment_num_tbl IN PO_TBL_NUMBER,
899: x_shipment_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
900: ) IS
901:
902: d_api_name CONSTANT VARCHAR2(30) := 'check_shipment_num_unique';

Line 1026: p_line_loc_id_tbl IN PO_TBL_NUMBER,

1022: --End of Comments
1023: --------------------------------------------------------------------------
1024: PROCEDURE calculate_max_dist_num
1025: (
1026: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1027: p_draft_id_tbl IN PO_TBL_NUMBER
1028: ) IS
1029:
1030: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_dist_num';

Line 1027: p_draft_id_tbl IN PO_TBL_NUMBER

1023: --------------------------------------------------------------------------
1024: PROCEDURE calculate_max_dist_num
1025: (
1026: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1027: p_draft_id_tbl IN PO_TBL_NUMBER
1028: ) IS
1029:
1030: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_dist_num';
1031: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1035: l_line_loc_id_tbl PO_TBL_NUMBER;

1031: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1032: d_position NUMBER;
1033:
1034: l_key po_session_gt.key%TYPE;
1035: l_line_loc_id_tbl PO_TBL_NUMBER;
1036: l_max_dist_num_tbl PO_TBL_NUMBER;
1037:
1038: l_processing_row_tbl DBMS_SQL.number_table;
1039: l_line_loc_id_no_dup_tbl DBMS_SQL.number_table;

Line 1036: l_max_dist_num_tbl PO_TBL_NUMBER;

1032: d_position NUMBER;
1033:
1034: l_key po_session_gt.key%TYPE;
1035: l_line_loc_id_tbl PO_TBL_NUMBER;
1036: l_max_dist_num_tbl PO_TBL_NUMBER;
1037:
1038: l_processing_row_tbl DBMS_SQL.number_table;
1039: l_line_loc_id_no_dup_tbl DBMS_SQL.number_table;
1040: BEGIN

Line 1303: p_line_loc_id_tbl IN PO_TBL_NUMBER,

1299: --End of Comments
1300: --------------------------------------------------------------------------
1301: PROCEDURE check_dist_num_unique
1302: (
1303: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1304: p_draft_id_tbl IN PO_TBL_NUMBER,
1305: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
1306: p_dist_num_tbl IN PO_TBL_NUMBER,
1307: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 1304: p_draft_id_tbl IN PO_TBL_NUMBER,

1300: --------------------------------------------------------------------------
1301: PROCEDURE check_dist_num_unique
1302: (
1303: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1304: p_draft_id_tbl IN PO_TBL_NUMBER,
1305: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
1306: p_dist_num_tbl IN PO_TBL_NUMBER,
1307: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
1308: ) IS

Line 1305: p_intf_dist_id_tbl IN PO_TBL_NUMBER,

1301: PROCEDURE check_dist_num_unique
1302: (
1303: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1304: p_draft_id_tbl IN PO_TBL_NUMBER,
1305: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
1306: p_dist_num_tbl IN PO_TBL_NUMBER,
1307: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
1308: ) IS
1309:

Line 1306: p_dist_num_tbl IN PO_TBL_NUMBER,

1302: (
1303: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1304: p_draft_id_tbl IN PO_TBL_NUMBER,
1305: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
1306: p_dist_num_tbl IN PO_TBL_NUMBER,
1307: x_dist_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
1308: ) IS
1309:
1310: d_api_name CONSTANT VARCHAR2(30) := 'check_dist_num_unique';

Line 1438: p_entity_id_tbl IN PO_TBL_NUMBER,

1434: --------------------------------------------------------------------------
1435: PROCEDURE calculate_max_price_diff_num
1436: (
1437: p_entity_type_tbl IN PO_TBL_VARCHAR30,
1438: p_entity_id_tbl IN PO_TBL_NUMBER,
1439: p_draft_id_tbl IN PO_TBL_NUMBER,
1440: p_price_diff_num_tbl IN PO_TBL_NUMBER
1441: ) IS
1442:

Line 1439: p_draft_id_tbl IN PO_TBL_NUMBER,

1435: PROCEDURE calculate_max_price_diff_num
1436: (
1437: p_entity_type_tbl IN PO_TBL_VARCHAR30,
1438: p_entity_id_tbl IN PO_TBL_NUMBER,
1439: p_draft_id_tbl IN PO_TBL_NUMBER,
1440: p_price_diff_num_tbl IN PO_TBL_NUMBER
1441: ) IS
1442:
1443: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_price_diff_num';

Line 1440: p_price_diff_num_tbl IN PO_TBL_NUMBER

1436: (
1437: p_entity_type_tbl IN PO_TBL_VARCHAR30,
1438: p_entity_id_tbl IN PO_TBL_NUMBER,
1439: p_draft_id_tbl IN PO_TBL_NUMBER,
1440: p_price_diff_num_tbl IN PO_TBL_NUMBER
1441: ) IS
1442:
1443: d_api_name CONSTANT VARCHAR2(30) := 'calculate_max_price_diff_num';
1444: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1449: l_entity_id_tbl PO_TBL_NUMBER;

1445: d_position NUMBER;
1446:
1447: l_key po_session_gt.key%TYPE;
1448: l_entity_type_tbl PO_TBL_VARCHAR30;
1449: l_entity_id_tbl PO_TBL_NUMBER;
1450: l_max_price_diff_num_tbl PO_TBL_NUMBER;
1451:
1452: BEGIN
1453: d_position := 0;

Line 1450: l_max_price_diff_num_tbl PO_TBL_NUMBER;

1446:
1447: l_key po_session_gt.key%TYPE;
1448: l_entity_type_tbl PO_TBL_VARCHAR30;
1449: l_entity_id_tbl PO_TBL_NUMBER;
1450: l_max_price_diff_num_tbl PO_TBL_NUMBER;
1451:
1452: BEGIN
1453: d_position := 0;
1454:

Line 1671: p_entity_id_tbl IN PO_TBL_NUMBER,

1667: --------------------------------------------------------------------------
1668: PROCEDURE check_price_diff_num_unique
1669: (
1670: p_entity_type_tbl IN PO_TBL_VARCHAR30,
1671: p_entity_id_tbl IN PO_TBL_NUMBER,
1672: p_draft_id_tbl IN PO_TBL_NUMBER,
1673: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
1674: p_price_diff_num_tbl IN PO_TBL_NUMBER,
1675: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 1672: p_draft_id_tbl IN PO_TBL_NUMBER,

1668: PROCEDURE check_price_diff_num_unique
1669: (
1670: p_entity_type_tbl IN PO_TBL_VARCHAR30,
1671: p_entity_id_tbl IN PO_TBL_NUMBER,
1672: p_draft_id_tbl IN PO_TBL_NUMBER,
1673: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
1674: p_price_diff_num_tbl IN PO_TBL_NUMBER,
1675: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
1676: ) IS

Line 1673: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,

1669: (
1670: p_entity_type_tbl IN PO_TBL_VARCHAR30,
1671: p_entity_id_tbl IN PO_TBL_NUMBER,
1672: p_draft_id_tbl IN PO_TBL_NUMBER,
1673: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
1674: p_price_diff_num_tbl IN PO_TBL_NUMBER,
1675: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
1676: ) IS
1677:

Line 1674: p_price_diff_num_tbl IN PO_TBL_NUMBER,

1670: p_entity_type_tbl IN PO_TBL_VARCHAR30,
1671: p_entity_id_tbl IN PO_TBL_NUMBER,
1672: p_draft_id_tbl IN PO_TBL_NUMBER,
1673: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,
1674: p_price_diff_num_tbl IN PO_TBL_NUMBER,
1675: x_price_diff_num_unique_tbl OUT NOCOPY PO_TBL_VARCHAR1
1676: ) IS
1677:
1678: d_api_name CONSTANT VARCHAR2(30) := 'check_price_diff_num_unique';

Line 1838: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,

1834: --End of Comments
1835: --------------------------------------------------------------------------
1836: PROCEDURE default_who_columns(
1837: x_last_update_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1838: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1839: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1840: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1841: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1842: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

Line 1839: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,

1835: --------------------------------------------------------------------------
1836: PROCEDURE default_who_columns(
1837: x_last_update_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1838: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1839: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1840: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1841: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1842: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1843: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

Line 1841: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,

1837: x_last_update_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1838: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1839: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1840: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1841: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1842: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1843: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1844: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1845: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE

Line 1842: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

1838: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1839: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1840: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1841: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1842: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1843: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1844: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1845: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
1846: ) IS

Line 1843: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

1839: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1840: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1841: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1842: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1843: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1844: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1845: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
1846: ) IS
1847:

Line 1844: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

1840: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1841: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1842: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1843: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1844: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1845: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
1846: ) IS
1847:
1848: d_api_name CONSTANT VARCHAR2(30) := 'default_who_columns';