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.AMS_PRICE_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 494: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

490: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
491: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
492: ,p_currency_code IN VARCHAR2
493: ,p_item_tbl IN JTF_NUMBER_TABLE
494: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
495: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null
496: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null
497: -- ,p_calculate_flag IN CHAR(1) :='Y'
498: ,p_request_type_code IN VARCHAR2

Line 502: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

498: ,p_request_type_code IN VARCHAR2
499: ,p_pricing_event IN VARCHAR2
500: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
501: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
502: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
503: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
504: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE
505: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
506: ,x_return_status out nocopy varchar2

Line 634: x_status_code_tbl := JTF_VARCHAR2_TABLE_100();

630: clear_Global_Structures;
631:
632: x_listprice_tbl := JTF_NUMBER_TABLE();
633: x_bestprice_tbl := JTF_NUMBER_TABLE();
634: x_status_code_tbl := JTF_VARCHAR2_TABLE_100();
635: x_status_text_tbl := JTF_VARCHAR2_TABLE_300();
636:
637: x_parentIndex_tbl := JTF_NUMBER_TABLE();
638: x_childIndex_tbl := JTF_NUMBER_TABLE();

Line 681: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

677: ,x_status_text OUT NOCOPY varchar2
678: )
679: IS
680: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
681: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
682: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
683: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
684: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
685: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 684: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

680: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
681: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
682: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
683: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
684: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
685: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
686:
687: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
688: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 738: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

734: ,x_status_text OUT NOCOPY varchar2
735: )
736: IS
737: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
738: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
739: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
740: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
741: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
742: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 741: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

737: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
738: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
739: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
740: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
741: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
742: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
743:
744: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
745: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 799: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

795: ,x_status_text OUT NOCOPY varchar2
796: )
797: IS
798: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
799: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
800: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
801: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
802: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
803: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 802: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

798: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
799: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
800: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
801: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
802: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
803: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
804:
805: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
806: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 878: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

874: ,x_related_status_text OUT NOCOPY varchar2
875: )
876: IS
877: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
878: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
879: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
880: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
881: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
882: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 881: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

877: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
878: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
879: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
880: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
881: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
882: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
883:
884: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
885: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 967: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

963: ,x_related_status_text OUT NOCOPY varchar2
964: )
965: IS
966: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
967: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
968: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
969: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
970: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
971: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 970: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

966: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
967: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
968: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
969: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
970: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
971: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
972:
973: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
974: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1060: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1056: ,x_related_status_text OUT NOCOPY varchar2
1057: )
1058: IS
1059: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1060: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1061: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1062: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1063: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1064: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 1063: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1059: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1060: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1061: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1062: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1063: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1064: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1065:
1066: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1067: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1132: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1128: PROCEDURE GetPrices(
1129: p_price_list_id IN NUMBER
1130: ,p_currency_code IN VARCHAR2
1131: ,p_item_tbl IN JTF_NUMBER_TABLE
1132: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1133: -- ,p_calculate_flag IN CHAR(1) :='Y'
1134: ,p_request_type_code IN VARCHAR2
1135: ,p_pricing_event IN VARCHAR2
1136: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1138: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1134: ,p_request_type_code IN VARCHAR2
1135: ,p_pricing_event IN VARCHAR2
1136: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1137: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1138: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1139: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1140: ,x_return_status out nocopy varchar2
1141: ,x_return_status_text out nocopy varchar2
1142:

Line 1175: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1171: p_party_id IN NUMBER
1172: ,p_cust_account_id IN number
1173: ,p_currency_code IN VARCHAR2
1174: ,p_item_tbl IN JTF_NUMBER_TABLE
1175: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1176: -- ,p_calculate_flag IN CHAR(1) :='Y'
1177: ,p_request_type_code IN VARCHAR2
1178: ,p_pricing_event IN VARCHAR2
1179: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1181: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1177: ,p_request_type_code IN VARCHAR2
1178: ,p_pricing_event IN VARCHAR2
1179: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1180: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1181: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1182: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1183: ,x_return_status out nocopy varchar2
1184: ,x_return_status_text out nocopy varchar2
1185:

Line 1220: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1216: ,p_party_id IN NUMBER
1217: ,p_cust_account_id IN number
1218: ,p_currency_code IN VARCHAR2
1219: ,p_item_tbl IN JTF_NUMBER_TABLE
1220: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1221: -- ,p_calculate_flag IN CHAR(1) :='Y'
1222: ,p_request_type_code IN VARCHAR2
1223: ,p_pricing_event IN VARCHAR2
1224: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1226: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1222: ,p_request_type_code IN VARCHAR2
1223: ,p_pricing_event IN VARCHAR2
1224: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1225: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1226: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1227: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1228: ,x_return_status out nocopy varchar2
1229: ,x_return_status_text out nocopy varchar2
1230:

Line 1264: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1260: PROCEDURE GetPrices(
1261: p_price_list_id IN NUMBER
1262: ,p_currency_code IN VARCHAR2
1263: ,p_item_tbl IN JTF_NUMBER_TABLE
1264: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1265: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1266: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1267: -- ,p_calculate_flag IN CHAR(1) :='Y'
1268: ,p_request_type_code IN VARCHAR2

Line 1272: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1268: ,p_request_type_code IN VARCHAR2
1269: ,p_pricing_event IN VARCHAR2
1270: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1271: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1272: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1273: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1274: ,x_parentIndex_tbl out nocopy JTF_NUMBER_TABLE
1275: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
1276: ,x_return_status out nocopy varchar2

Line 1311: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1307: p_party_id IN NUMBER
1308: ,p_cust_account_id IN number
1309: ,p_currency_code IN VARCHAR2
1310: ,p_item_tbl IN JTF_NUMBER_TABLE
1311: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1312: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1313: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1314: -- ,p_calculate_flag IN CHAR(1) :='Y'
1315: ,p_request_type_code IN VARCHAR2

Line 1319: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1315: ,p_request_type_code IN VARCHAR2
1316: ,p_pricing_event IN VARCHAR2
1317: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1318: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1319: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1320: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1321: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1322: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1323: ,x_return_status out nocopy varchar2

Line 1360: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1356: ,p_party_id IN NUMBER
1357: ,p_cust_account_id IN number
1358: ,p_currency_code IN VARCHAR2
1359: ,p_item_tbl IN JTF_NUMBER_TABLE
1360: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1361: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1362: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1363: -- ,p_calculate_flag IN CHAR(1) :='Y'
1364: ,p_request_type_code IN VARCHAR2

Line 1368: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1364: ,p_request_type_code IN VARCHAR2
1365: ,p_pricing_event IN VARCHAR2
1366: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1367: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1368: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1369: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1370: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1371: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1372: ,x_return_status out nocopy varchar2