DBA Data[Home] [Help]

APPS.AMS_PRICE_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 503: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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
507: ,x_return_status_text out nocopy varchar2

Line 635: x_status_text_tbl := JTF_VARCHAR2_TABLE_300();

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();
639:

Line 685: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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();
689:

Line 742: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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();
746:

Line 803: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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();
807:

Line 882: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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();
886:

Line 971: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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();
975:

Line 1064: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

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();
1068:

Line 1139: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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:
1143: )

Line 1182: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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:
1186: )

Line 1227: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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:
1231: )

Line 1273: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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
1277: ,x_return_status_text out nocopy varchar2

Line 1320: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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
1324: ,x_return_status_text out nocopy varchar2

Line 1369: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300

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
1373: ,x_return_status_text out nocopy varchar2