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_VALIDATIONS dependencies on PO_TBL_VARCHAR30

Line 93: c_result_type_rank_tbl CONSTANT PO_TBL_VARCHAR30 :=

89: For example, if one result is WARNING and the other is FAILURE,
90: then the overall result should be FAILURE. This is indicated
91: by the fact that FAILURE has a lower index in this list than WARNING.
92: */
93: c_result_type_rank_tbl CONSTANT PO_TBL_VARCHAR30 :=
94: PO_TBL_VARCHAR30(
95: c_result_type_FATAL
96: , c_result_type_FAILURE
97: , c_result_type_WARNING

Line 94: PO_TBL_VARCHAR30(

90: then the overall result should be FAILURE. This is indicated
91: by the fact that FAILURE has a lower index in this list than WARNING.
92: */
93: c_result_type_rank_tbl CONSTANT PO_TBL_VARCHAR30 :=
94: PO_TBL_VARCHAR30(
95: c_result_type_FATAL
96: , c_result_type_FAILURE
97: , c_result_type_WARNING
98: , c_result_type_SUCCESS

Line 1407: , p_result_type_tbl IN PO_TBL_VARCHAR30

1403: -------------------------------------------------------------------------------
1404: PROCEDURE commit_validation_results_auto(
1405: p_result_id_tbl IN PO_TBL_NUMBER
1406: , p_result_set_id_tbl IN PO_TBL_NUMBER
1407: , p_result_type_tbl IN PO_TBL_VARCHAR30
1408: , p_table_name_tbl IN PO_TBL_VARCHAR30
1409: , p_table_id_tbl IN PO_TBL_NUMBER
1410: , p_message_application_tbl IN PO_TBL_VARCHAR30
1411: , p_message_name_tbl IN PO_TBL_VARCHAR30

Line 1408: , p_table_name_tbl IN PO_TBL_VARCHAR30

1404: PROCEDURE commit_validation_results_auto(
1405: p_result_id_tbl IN PO_TBL_NUMBER
1406: , p_result_set_id_tbl IN PO_TBL_NUMBER
1407: , p_result_type_tbl IN PO_TBL_VARCHAR30
1408: , p_table_name_tbl IN PO_TBL_VARCHAR30
1409: , p_table_id_tbl IN PO_TBL_NUMBER
1410: , p_message_application_tbl IN PO_TBL_VARCHAR30
1411: , p_message_name_tbl IN PO_TBL_VARCHAR30
1412: , p_column_name_tbl IN PO_TBL_VARCHAR30

Line 1410: , p_message_application_tbl IN PO_TBL_VARCHAR30

1406: , p_result_set_id_tbl IN PO_TBL_NUMBER
1407: , p_result_type_tbl IN PO_TBL_VARCHAR30
1408: , p_table_name_tbl IN PO_TBL_VARCHAR30
1409: , p_table_id_tbl IN PO_TBL_NUMBER
1410: , p_message_application_tbl IN PO_TBL_VARCHAR30
1411: , p_message_name_tbl IN PO_TBL_VARCHAR30
1412: , p_column_name_tbl IN PO_TBL_VARCHAR30
1413: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1414: , p_token1_value_tbl IN PO_TBL_VARCHAR2000

Line 1411: , p_message_name_tbl IN PO_TBL_VARCHAR30

1407: , p_result_type_tbl IN PO_TBL_VARCHAR30
1408: , p_table_name_tbl IN PO_TBL_VARCHAR30
1409: , p_table_id_tbl IN PO_TBL_NUMBER
1410: , p_message_application_tbl IN PO_TBL_VARCHAR30
1411: , p_message_name_tbl IN PO_TBL_VARCHAR30
1412: , p_column_name_tbl IN PO_TBL_VARCHAR30
1413: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1414: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1415: , p_token2_name_tbl IN PO_TBL_VARCHAR30

Line 1412: , p_column_name_tbl IN PO_TBL_VARCHAR30

1408: , p_table_name_tbl IN PO_TBL_VARCHAR30
1409: , p_table_id_tbl IN PO_TBL_NUMBER
1410: , p_message_application_tbl IN PO_TBL_VARCHAR30
1411: , p_message_name_tbl IN PO_TBL_VARCHAR30
1412: , p_column_name_tbl IN PO_TBL_VARCHAR30
1413: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1414: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1415: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1416: , p_token2_value_tbl IN PO_TBL_VARCHAR2000

Line 1413: , p_token1_name_tbl IN PO_TBL_VARCHAR30

1409: , p_table_id_tbl IN PO_TBL_NUMBER
1410: , p_message_application_tbl IN PO_TBL_VARCHAR30
1411: , p_message_name_tbl IN PO_TBL_VARCHAR30
1412: , p_column_name_tbl IN PO_TBL_VARCHAR30
1413: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1414: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1415: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1416: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1417: , p_token3_name_tbl IN PO_TBL_VARCHAR30

Line 1415: , p_token2_name_tbl IN PO_TBL_VARCHAR30

1411: , p_message_name_tbl IN PO_TBL_VARCHAR30
1412: , p_column_name_tbl IN PO_TBL_VARCHAR30
1413: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1414: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1415: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1416: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1417: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1418: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1419: , p_token4_name_tbl IN PO_TBL_VARCHAR30

Line 1417: , p_token3_name_tbl IN PO_TBL_VARCHAR30

1413: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1414: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1415: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1416: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1417: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1418: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1419: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1420: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1421: , p_token5_name_tbl IN PO_TBL_VARCHAR30

Line 1419: , p_token4_name_tbl IN PO_TBL_VARCHAR30

1415: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1416: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1417: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1418: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1419: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1420: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1421: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1422: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1423: , p_token6_name_tbl IN PO_TBL_VARCHAR30

Line 1421: , p_token5_name_tbl IN PO_TBL_VARCHAR30

1417: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1418: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1419: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1420: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1421: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1422: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1423: , p_token6_name_tbl IN PO_TBL_VARCHAR30
1424: , p_token6_value_tbl IN PO_TBL_VARCHAR2000
1425: )

Line 1423: , p_token6_name_tbl IN PO_TBL_VARCHAR30

1419: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1420: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1421: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1422: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1423: , p_token6_name_tbl IN PO_TBL_VARCHAR30
1424: , p_token6_value_tbl IN PO_TBL_VARCHAR2000
1425: )
1426: IS
1427: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1598: l_result_type_tbl PO_TBL_VARCHAR30;

1594: d_position NUMBER := 0;
1595:
1596: l_result_id_tbl PO_TBL_NUMBER;
1597: l_result_set_id_tbl PO_TBL_NUMBER;
1598: l_result_type_tbl PO_TBL_VARCHAR30;
1599: l_table_name_tbl PO_TBL_VARCHAR30;
1600: l_table_id_tbl PO_TBL_NUMBER;
1601: l_message_application_tbl PO_TBL_VARCHAR30;
1602: l_message_name_tbl PO_TBL_VARCHAR30;

Line 1599: l_table_name_tbl PO_TBL_VARCHAR30;

1595:
1596: l_result_id_tbl PO_TBL_NUMBER;
1597: l_result_set_id_tbl PO_TBL_NUMBER;
1598: l_result_type_tbl PO_TBL_VARCHAR30;
1599: l_table_name_tbl PO_TBL_VARCHAR30;
1600: l_table_id_tbl PO_TBL_NUMBER;
1601: l_message_application_tbl PO_TBL_VARCHAR30;
1602: l_message_name_tbl PO_TBL_VARCHAR30;
1603: l_column_name_tbl PO_TBL_VARCHAR30;

Line 1601: l_message_application_tbl PO_TBL_VARCHAR30;

1597: l_result_set_id_tbl PO_TBL_NUMBER;
1598: l_result_type_tbl PO_TBL_VARCHAR30;
1599: l_table_name_tbl PO_TBL_VARCHAR30;
1600: l_table_id_tbl PO_TBL_NUMBER;
1601: l_message_application_tbl PO_TBL_VARCHAR30;
1602: l_message_name_tbl PO_TBL_VARCHAR30;
1603: l_column_name_tbl PO_TBL_VARCHAR30;
1604: l_token1_name_tbl PO_TBL_VARCHAR30;
1605: l_token1_value_tbl PO_TBL_VARCHAR2000;

Line 1602: l_message_name_tbl PO_TBL_VARCHAR30;

1598: l_result_type_tbl PO_TBL_VARCHAR30;
1599: l_table_name_tbl PO_TBL_VARCHAR30;
1600: l_table_id_tbl PO_TBL_NUMBER;
1601: l_message_application_tbl PO_TBL_VARCHAR30;
1602: l_message_name_tbl PO_TBL_VARCHAR30;
1603: l_column_name_tbl PO_TBL_VARCHAR30;
1604: l_token1_name_tbl PO_TBL_VARCHAR30;
1605: l_token1_value_tbl PO_TBL_VARCHAR2000;
1606: l_token2_name_tbl PO_TBL_VARCHAR30;

Line 1603: l_column_name_tbl PO_TBL_VARCHAR30;

1599: l_table_name_tbl PO_TBL_VARCHAR30;
1600: l_table_id_tbl PO_TBL_NUMBER;
1601: l_message_application_tbl PO_TBL_VARCHAR30;
1602: l_message_name_tbl PO_TBL_VARCHAR30;
1603: l_column_name_tbl PO_TBL_VARCHAR30;
1604: l_token1_name_tbl PO_TBL_VARCHAR30;
1605: l_token1_value_tbl PO_TBL_VARCHAR2000;
1606: l_token2_name_tbl PO_TBL_VARCHAR30;
1607: l_token2_value_tbl PO_TBL_VARCHAR2000;

Line 1604: l_token1_name_tbl PO_TBL_VARCHAR30;

1600: l_table_id_tbl PO_TBL_NUMBER;
1601: l_message_application_tbl PO_TBL_VARCHAR30;
1602: l_message_name_tbl PO_TBL_VARCHAR30;
1603: l_column_name_tbl PO_TBL_VARCHAR30;
1604: l_token1_name_tbl PO_TBL_VARCHAR30;
1605: l_token1_value_tbl PO_TBL_VARCHAR2000;
1606: l_token2_name_tbl PO_TBL_VARCHAR30;
1607: l_token2_value_tbl PO_TBL_VARCHAR2000;
1608: l_token3_name_tbl PO_TBL_VARCHAR30;

Line 1606: l_token2_name_tbl PO_TBL_VARCHAR30;

1602: l_message_name_tbl PO_TBL_VARCHAR30;
1603: l_column_name_tbl PO_TBL_VARCHAR30;
1604: l_token1_name_tbl PO_TBL_VARCHAR30;
1605: l_token1_value_tbl PO_TBL_VARCHAR2000;
1606: l_token2_name_tbl PO_TBL_VARCHAR30;
1607: l_token2_value_tbl PO_TBL_VARCHAR2000;
1608: l_token3_name_tbl PO_TBL_VARCHAR30;
1609: l_token3_value_tbl PO_TBL_VARCHAR2000;
1610: l_token4_name_tbl PO_TBL_VARCHAR30;

Line 1608: l_token3_name_tbl PO_TBL_VARCHAR30;

1604: l_token1_name_tbl PO_TBL_VARCHAR30;
1605: l_token1_value_tbl PO_TBL_VARCHAR2000;
1606: l_token2_name_tbl PO_TBL_VARCHAR30;
1607: l_token2_value_tbl PO_TBL_VARCHAR2000;
1608: l_token3_name_tbl PO_TBL_VARCHAR30;
1609: l_token3_value_tbl PO_TBL_VARCHAR2000;
1610: l_token4_name_tbl PO_TBL_VARCHAR30;
1611: l_token4_value_tbl PO_TBL_VARCHAR2000;
1612: l_token5_name_tbl PO_TBL_VARCHAR30;

Line 1610: l_token4_name_tbl PO_TBL_VARCHAR30;

1606: l_token2_name_tbl PO_TBL_VARCHAR30;
1607: l_token2_value_tbl PO_TBL_VARCHAR2000;
1608: l_token3_name_tbl PO_TBL_VARCHAR30;
1609: l_token3_value_tbl PO_TBL_VARCHAR2000;
1610: l_token4_name_tbl PO_TBL_VARCHAR30;
1611: l_token4_value_tbl PO_TBL_VARCHAR2000;
1612: l_token5_name_tbl PO_TBL_VARCHAR30;
1613: l_token5_value_tbl PO_TBL_VARCHAR2000;
1614: l_token6_name_tbl PO_TBL_VARCHAR30;

Line 1612: l_token5_name_tbl PO_TBL_VARCHAR30;

1608: l_token3_name_tbl PO_TBL_VARCHAR30;
1609: l_token3_value_tbl PO_TBL_VARCHAR2000;
1610: l_token4_name_tbl PO_TBL_VARCHAR30;
1611: l_token4_value_tbl PO_TBL_VARCHAR2000;
1612: l_token5_name_tbl PO_TBL_VARCHAR30;
1613: l_token5_value_tbl PO_TBL_VARCHAR2000;
1614: l_token6_name_tbl PO_TBL_VARCHAR30;
1615: l_token6_value_tbl PO_TBL_VARCHAR2000;
1616:

Line 1614: l_token6_name_tbl PO_TBL_VARCHAR30;

1610: l_token4_name_tbl PO_TBL_VARCHAR30;
1611: l_token4_value_tbl PO_TBL_VARCHAR2000;
1612: l_token5_name_tbl PO_TBL_VARCHAR30;
1613: l_token5_value_tbl PO_TBL_VARCHAR2000;
1614: l_token6_name_tbl PO_TBL_VARCHAR30;
1615: l_token6_value_tbl PO_TBL_VARCHAR2000;
1616:
1617: BEGIN
1618:

Line 6346: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30

6342: --End of Comments
6343: -------------------------------------------------------------------------------
6344: PROCEDURE validate_unit_price_change(
6345: p_line_id_tbl IN PO_TBL_NUMBER
6346: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
6347: -- 6348: -- identify if the amount on the distributions of the line has been changed
6349: , p_amount_changed_flag_tbl IN PO_TBL_VARCHAR1
6350: , p_stopping_result_type IN VARCHAR2 DEFAULT NULL