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 464: p_po_header_id_tbl IN PO_TBL_NUMBER,

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

Line 465: p_draft_id_tbl IN PO_TBL_NUMBER,

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

Line 466: p_intf_line_id_tbl IN PO_TBL_NUMBER,

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

Line 467: p_line_num_tbl IN PO_TBL_NUMBER,

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

Line 597: p_po_line_id_tbl IN PO_TBL_NUMBER,

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

Line 598: p_draft_id_tbl IN PO_TBL_NUMBER

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

Line 606: l_po_line_id_tbl PO_TBL_NUMBER;

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

Line 607: l_max_shipment_num_tbl PO_TBL_NUMBER;

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

Line 892: p_po_line_id_tbl IN PO_TBL_NUMBER,

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

Line 893: p_draft_id_tbl IN PO_TBL_NUMBER,

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

Line 894: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,

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

Line 895: p_shipment_num_tbl IN PO_TBL_NUMBER,

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

Line 1023: p_line_loc_id_tbl IN PO_TBL_NUMBER,

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

Line 1024: p_draft_id_tbl IN PO_TBL_NUMBER

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

Line 1032: l_line_loc_id_tbl PO_TBL_NUMBER;

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

Line 1033: l_max_dist_num_tbl PO_TBL_NUMBER;

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

Line 1300: p_line_loc_id_tbl IN PO_TBL_NUMBER,

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

Line 1301: p_draft_id_tbl IN PO_TBL_NUMBER,

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

Line 1302: p_intf_dist_id_tbl IN PO_TBL_NUMBER,

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

Line 1303: p_dist_num_tbl IN PO_TBL_NUMBER,

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

Line 1435: p_entity_id_tbl IN PO_TBL_NUMBER,

1431: --------------------------------------------------------------------------
1432: PROCEDURE calculate_max_price_diff_num
1433: (
1434: p_entity_type_tbl IN PO_TBL_VARCHAR30,
1435: p_entity_id_tbl IN PO_TBL_NUMBER,
1436: p_draft_id_tbl IN PO_TBL_NUMBER,
1437: p_price_diff_num_tbl IN PO_TBL_NUMBER
1438: ) IS
1439:

Line 1436: p_draft_id_tbl IN PO_TBL_NUMBER,

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

Line 1437: p_price_diff_num_tbl IN PO_TBL_NUMBER

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

Line 1446: l_entity_id_tbl PO_TBL_NUMBER;

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

Line 1447: l_max_price_diff_num_tbl PO_TBL_NUMBER;

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

Line 1668: p_entity_id_tbl IN PO_TBL_NUMBER,

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

Line 1669: p_draft_id_tbl IN PO_TBL_NUMBER,

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

Line 1670: p_intf_price_diff_id_tbl IN PO_TBL_NUMBER,

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

Line 1671: p_price_diff_num_tbl IN PO_TBL_NUMBER,

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

Line 1835: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,

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

Line 1836: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,

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

Line 1838: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,

1834: x_last_update_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1835: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1836: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1837: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1838: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1839: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1840: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1841: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1842: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE

Line 1839: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

1835: x_last_updated_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1836: x_last_update_login_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1837: x_creation_date_tbl IN OUT NOCOPY PO_TBL_DATE,
1838: x_created_by_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1839: x_request_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1840: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1841: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
1842: x_program_update_date_tbl IN OUT NOCOPY PO_TBL_DATE
1843: ) IS

Line 1840: x_program_application_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

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

Line 1841: x_program_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

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