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 87: c_result_type_rank_tbl CONSTANT PO_TBL_VARCHAR30 :=

83: For example, if one result is WARNING and the other is FAILURE,
84: then the overall result should be FAILURE. This is indicated
85: by the fact that FAILURE has a lower index in this list than WARNING.
86: */
87: c_result_type_rank_tbl CONSTANT PO_TBL_VARCHAR30 :=
88: PO_TBL_VARCHAR30(
89: c_result_type_FATAL
90: , c_result_type_FAILURE
91: , c_result_type_WARNING

Line 88: PO_TBL_VARCHAR30(

84: then the overall result should be FAILURE. This is indicated
85: by the fact that FAILURE has a lower index in this list than WARNING.
86: */
87: c_result_type_rank_tbl CONSTANT PO_TBL_VARCHAR30 :=
88: PO_TBL_VARCHAR30(
89: c_result_type_FATAL
90: , c_result_type_FAILURE
91: , c_result_type_WARNING
92: , c_result_type_SUCCESS

Line 1124: , p_result_type_tbl IN PO_TBL_VARCHAR30

1120: -------------------------------------------------------------------------------
1121: PROCEDURE commit_validation_results_auto(
1122: p_result_id_tbl IN PO_TBL_NUMBER
1123: , p_result_set_id_tbl IN PO_TBL_NUMBER
1124: , p_result_type_tbl IN PO_TBL_VARCHAR30
1125: , p_table_name_tbl IN PO_TBL_VARCHAR30
1126: , p_table_id_tbl IN PO_TBL_NUMBER
1127: , p_message_application_tbl IN PO_TBL_VARCHAR30
1128: , p_message_name_tbl IN PO_TBL_VARCHAR30

Line 1125: , p_table_name_tbl IN PO_TBL_VARCHAR30

1121: PROCEDURE commit_validation_results_auto(
1122: p_result_id_tbl IN PO_TBL_NUMBER
1123: , p_result_set_id_tbl IN PO_TBL_NUMBER
1124: , p_result_type_tbl IN PO_TBL_VARCHAR30
1125: , p_table_name_tbl IN PO_TBL_VARCHAR30
1126: , p_table_id_tbl IN PO_TBL_NUMBER
1127: , p_message_application_tbl IN PO_TBL_VARCHAR30
1128: , p_message_name_tbl IN PO_TBL_VARCHAR30
1129: , p_column_name_tbl IN PO_TBL_VARCHAR30

Line 1127: , p_message_application_tbl IN PO_TBL_VARCHAR30

1123: , p_result_set_id_tbl IN PO_TBL_NUMBER
1124: , p_result_type_tbl IN PO_TBL_VARCHAR30
1125: , p_table_name_tbl IN PO_TBL_VARCHAR30
1126: , p_table_id_tbl IN PO_TBL_NUMBER
1127: , p_message_application_tbl IN PO_TBL_VARCHAR30
1128: , p_message_name_tbl IN PO_TBL_VARCHAR30
1129: , p_column_name_tbl IN PO_TBL_VARCHAR30
1130: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1131: , p_token1_value_tbl IN PO_TBL_VARCHAR2000

Line 1128: , p_message_name_tbl IN PO_TBL_VARCHAR30

1124: , p_result_type_tbl IN PO_TBL_VARCHAR30
1125: , p_table_name_tbl IN PO_TBL_VARCHAR30
1126: , p_table_id_tbl IN PO_TBL_NUMBER
1127: , p_message_application_tbl IN PO_TBL_VARCHAR30
1128: , p_message_name_tbl IN PO_TBL_VARCHAR30
1129: , p_column_name_tbl IN PO_TBL_VARCHAR30
1130: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1131: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1132: , p_token2_name_tbl IN PO_TBL_VARCHAR30

Line 1129: , p_column_name_tbl IN PO_TBL_VARCHAR30

1125: , p_table_name_tbl IN PO_TBL_VARCHAR30
1126: , p_table_id_tbl IN PO_TBL_NUMBER
1127: , p_message_application_tbl IN PO_TBL_VARCHAR30
1128: , p_message_name_tbl IN PO_TBL_VARCHAR30
1129: , p_column_name_tbl IN PO_TBL_VARCHAR30
1130: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1131: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1132: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1133: , p_token2_value_tbl IN PO_TBL_VARCHAR2000

Line 1130: , p_token1_name_tbl IN PO_TBL_VARCHAR30

1126: , p_table_id_tbl IN PO_TBL_NUMBER
1127: , p_message_application_tbl IN PO_TBL_VARCHAR30
1128: , p_message_name_tbl IN PO_TBL_VARCHAR30
1129: , p_column_name_tbl IN PO_TBL_VARCHAR30
1130: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1131: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1132: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1133: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1134: , p_token3_name_tbl IN PO_TBL_VARCHAR30

Line 1132: , p_token2_name_tbl IN PO_TBL_VARCHAR30

1128: , p_message_name_tbl IN PO_TBL_VARCHAR30
1129: , p_column_name_tbl IN PO_TBL_VARCHAR30
1130: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1131: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1132: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1133: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1134: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1135: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1136: , p_token4_name_tbl IN PO_TBL_VARCHAR30

Line 1134: , p_token3_name_tbl IN PO_TBL_VARCHAR30

1130: , p_token1_name_tbl IN PO_TBL_VARCHAR30
1131: , p_token1_value_tbl IN PO_TBL_VARCHAR2000
1132: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1133: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1134: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1135: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1136: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1137: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1138: , p_token5_name_tbl IN PO_TBL_VARCHAR30

Line 1136: , p_token4_name_tbl IN PO_TBL_VARCHAR30

1132: , p_token2_name_tbl IN PO_TBL_VARCHAR30
1133: , p_token2_value_tbl IN PO_TBL_VARCHAR2000
1134: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1135: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1136: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1137: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1138: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1139: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1140: , p_token6_name_tbl IN PO_TBL_VARCHAR30

Line 1138: , p_token5_name_tbl IN PO_TBL_VARCHAR30

1134: , p_token3_name_tbl IN PO_TBL_VARCHAR30
1135: , p_token3_value_tbl IN PO_TBL_VARCHAR2000
1136: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1137: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1138: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1139: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1140: , p_token6_name_tbl IN PO_TBL_VARCHAR30
1141: , p_token6_value_tbl IN PO_TBL_VARCHAR2000
1142: )

Line 1140: , p_token6_name_tbl IN PO_TBL_VARCHAR30

1136: , p_token4_name_tbl IN PO_TBL_VARCHAR30
1137: , p_token4_value_tbl IN PO_TBL_VARCHAR2000
1138: , p_token5_name_tbl IN PO_TBL_VARCHAR30
1139: , p_token5_value_tbl IN PO_TBL_VARCHAR2000
1140: , p_token6_name_tbl IN PO_TBL_VARCHAR30
1141: , p_token6_value_tbl IN PO_TBL_VARCHAR2000
1142: )
1143: IS
1144: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1315: l_result_type_tbl PO_TBL_VARCHAR30;

1311: d_position NUMBER := 0;
1312:
1313: l_result_id_tbl PO_TBL_NUMBER;
1314: l_result_set_id_tbl PO_TBL_NUMBER;
1315: l_result_type_tbl PO_TBL_VARCHAR30;
1316: l_table_name_tbl PO_TBL_VARCHAR30;
1317: l_table_id_tbl PO_TBL_NUMBER;
1318: l_message_application_tbl PO_TBL_VARCHAR30;
1319: l_message_name_tbl PO_TBL_VARCHAR30;

Line 1316: l_table_name_tbl PO_TBL_VARCHAR30;

1312:
1313: l_result_id_tbl PO_TBL_NUMBER;
1314: l_result_set_id_tbl PO_TBL_NUMBER;
1315: l_result_type_tbl PO_TBL_VARCHAR30;
1316: l_table_name_tbl PO_TBL_VARCHAR30;
1317: l_table_id_tbl PO_TBL_NUMBER;
1318: l_message_application_tbl PO_TBL_VARCHAR30;
1319: l_message_name_tbl PO_TBL_VARCHAR30;
1320: l_column_name_tbl PO_TBL_VARCHAR30;

Line 1318: l_message_application_tbl PO_TBL_VARCHAR30;

1314: l_result_set_id_tbl PO_TBL_NUMBER;
1315: l_result_type_tbl PO_TBL_VARCHAR30;
1316: l_table_name_tbl PO_TBL_VARCHAR30;
1317: l_table_id_tbl PO_TBL_NUMBER;
1318: l_message_application_tbl PO_TBL_VARCHAR30;
1319: l_message_name_tbl PO_TBL_VARCHAR30;
1320: l_column_name_tbl PO_TBL_VARCHAR30;
1321: l_token1_name_tbl PO_TBL_VARCHAR30;
1322: l_token1_value_tbl PO_TBL_VARCHAR2000;

Line 1319: l_message_name_tbl PO_TBL_VARCHAR30;

1315: l_result_type_tbl PO_TBL_VARCHAR30;
1316: l_table_name_tbl PO_TBL_VARCHAR30;
1317: l_table_id_tbl PO_TBL_NUMBER;
1318: l_message_application_tbl PO_TBL_VARCHAR30;
1319: l_message_name_tbl PO_TBL_VARCHAR30;
1320: l_column_name_tbl PO_TBL_VARCHAR30;
1321: l_token1_name_tbl PO_TBL_VARCHAR30;
1322: l_token1_value_tbl PO_TBL_VARCHAR2000;
1323: l_token2_name_tbl PO_TBL_VARCHAR30;

Line 1320: l_column_name_tbl PO_TBL_VARCHAR30;

1316: l_table_name_tbl PO_TBL_VARCHAR30;
1317: l_table_id_tbl PO_TBL_NUMBER;
1318: l_message_application_tbl PO_TBL_VARCHAR30;
1319: l_message_name_tbl PO_TBL_VARCHAR30;
1320: l_column_name_tbl PO_TBL_VARCHAR30;
1321: l_token1_name_tbl PO_TBL_VARCHAR30;
1322: l_token1_value_tbl PO_TBL_VARCHAR2000;
1323: l_token2_name_tbl PO_TBL_VARCHAR30;
1324: l_token2_value_tbl PO_TBL_VARCHAR2000;

Line 1321: l_token1_name_tbl PO_TBL_VARCHAR30;

1317: l_table_id_tbl PO_TBL_NUMBER;
1318: l_message_application_tbl PO_TBL_VARCHAR30;
1319: l_message_name_tbl PO_TBL_VARCHAR30;
1320: l_column_name_tbl PO_TBL_VARCHAR30;
1321: l_token1_name_tbl PO_TBL_VARCHAR30;
1322: l_token1_value_tbl PO_TBL_VARCHAR2000;
1323: l_token2_name_tbl PO_TBL_VARCHAR30;
1324: l_token2_value_tbl PO_TBL_VARCHAR2000;
1325: l_token3_name_tbl PO_TBL_VARCHAR30;

Line 1323: l_token2_name_tbl PO_TBL_VARCHAR30;

1319: l_message_name_tbl PO_TBL_VARCHAR30;
1320: l_column_name_tbl PO_TBL_VARCHAR30;
1321: l_token1_name_tbl PO_TBL_VARCHAR30;
1322: l_token1_value_tbl PO_TBL_VARCHAR2000;
1323: l_token2_name_tbl PO_TBL_VARCHAR30;
1324: l_token2_value_tbl PO_TBL_VARCHAR2000;
1325: l_token3_name_tbl PO_TBL_VARCHAR30;
1326: l_token3_value_tbl PO_TBL_VARCHAR2000;
1327: l_token4_name_tbl PO_TBL_VARCHAR30;

Line 1325: l_token3_name_tbl PO_TBL_VARCHAR30;

1321: l_token1_name_tbl PO_TBL_VARCHAR30;
1322: l_token1_value_tbl PO_TBL_VARCHAR2000;
1323: l_token2_name_tbl PO_TBL_VARCHAR30;
1324: l_token2_value_tbl PO_TBL_VARCHAR2000;
1325: l_token3_name_tbl PO_TBL_VARCHAR30;
1326: l_token3_value_tbl PO_TBL_VARCHAR2000;
1327: l_token4_name_tbl PO_TBL_VARCHAR30;
1328: l_token4_value_tbl PO_TBL_VARCHAR2000;
1329: l_token5_name_tbl PO_TBL_VARCHAR30;

Line 1327: l_token4_name_tbl PO_TBL_VARCHAR30;

1323: l_token2_name_tbl PO_TBL_VARCHAR30;
1324: l_token2_value_tbl PO_TBL_VARCHAR2000;
1325: l_token3_name_tbl PO_TBL_VARCHAR30;
1326: l_token3_value_tbl PO_TBL_VARCHAR2000;
1327: l_token4_name_tbl PO_TBL_VARCHAR30;
1328: l_token4_value_tbl PO_TBL_VARCHAR2000;
1329: l_token5_name_tbl PO_TBL_VARCHAR30;
1330: l_token5_value_tbl PO_TBL_VARCHAR2000;
1331: l_token6_name_tbl PO_TBL_VARCHAR30;

Line 1329: l_token5_name_tbl PO_TBL_VARCHAR30;

1325: l_token3_name_tbl PO_TBL_VARCHAR30;
1326: l_token3_value_tbl PO_TBL_VARCHAR2000;
1327: l_token4_name_tbl PO_TBL_VARCHAR30;
1328: l_token4_value_tbl PO_TBL_VARCHAR2000;
1329: l_token5_name_tbl PO_TBL_VARCHAR30;
1330: l_token5_value_tbl PO_TBL_VARCHAR2000;
1331: l_token6_name_tbl PO_TBL_VARCHAR30;
1332: l_token6_value_tbl PO_TBL_VARCHAR2000;
1333:

Line 1331: l_token6_name_tbl PO_TBL_VARCHAR30;

1327: l_token4_name_tbl PO_TBL_VARCHAR30;
1328: l_token4_value_tbl PO_TBL_VARCHAR2000;
1329: l_token5_name_tbl PO_TBL_VARCHAR30;
1330: l_token5_value_tbl PO_TBL_VARCHAR2000;
1331: l_token6_name_tbl PO_TBL_VARCHAR30;
1332: l_token6_value_tbl PO_TBL_VARCHAR2000;
1333:
1334: BEGIN
1335:

Line 5187: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30

5183: --End of Comments
5184: -------------------------------------------------------------------------------
5185: PROCEDURE validate_unit_price_change(
5186: p_line_id_tbl IN PO_TBL_NUMBER
5187: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
5188: , p_stopping_result_type IN VARCHAR2 DEFAULT NULL
5189: , x_result_type OUT NOCOPY VARCHAR2
5190: , x_result_set_id IN OUT NOCOPY NUMBER
5191: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE