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

Line 524: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

520: ,p_model_id IN NUMBER --:= FND_API.G_MISS_NUM
521:
522: ,p_currency_code IN VARCHAR2
523: ,p_item_tbl IN JTF_NUMBER_TABLE
524: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
525: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null
526: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null
527: -- ,p_calculate_flag IN CHAR(1) :='Y'
528: ,p_request_type_code IN VARCHAR2

Line 532: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

528: ,p_request_type_code IN VARCHAR2
529: ,p_pricing_event IN VARCHAR2
530: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
531: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
532: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
533: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
534: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE
535: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
536: ,x_return_status out nocopy varchar2

Line 683: x_status_code_tbl := JTF_VARCHAR2_TABLE_100();

679: clear_Global_Structures;
680:
681: x_listprice_tbl := JTF_NUMBER_TABLE();
682: x_bestprice_tbl := JTF_NUMBER_TABLE();
683: x_status_code_tbl := JTF_VARCHAR2_TABLE_100();
684: x_status_text_tbl := JTF_VARCHAR2_TABLE_300();
685:
686: x_parentIndex_tbl := JTF_NUMBER_TABLE();
687: x_childIndex_tbl := JTF_NUMBER_TABLE();

Line 743: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

739:
740: ,p_organization_id IN NUMBER
741: ,p_currency_code IN VARCHAR2
742: ,p_item_tbl IN JTF_NUMBER_TABLE
743: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
744: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null
745: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null
746:
747: --gzhang 01/21/01, model bundle cache

Line 748: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

744: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null
745: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null
746:
747: --gzhang 01/21/01, model bundle cache
748: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
749:
750: ,p_request_type_code IN VARCHAR2
751: ,p_pricing_event IN VARCHAR2
752: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 754: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

750: ,p_request_type_code IN VARCHAR2
751: ,p_pricing_event IN VARCHAR2
752: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
753: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
754: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
755: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
756: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE
757: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
758: ,x_return_status out nocopy varchar2

Line 767: l_sub_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

763: L_API VARCHAR2(64);
764: l_itm_id NUMBER;
765:
766: l_sub_itm_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
767: l_sub_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
768: l_sub_qty_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
769:
770: l_sub_listprice_tbl JTF_NUMBER_TABLE;
771: l_sub_bestprice_tbl JTF_NUMBER_TABLE;

Line 773: l_sub_status_code_tbl JTF_VARCHAR2_TABLE_100;

769:
770: l_sub_listprice_tbl JTF_NUMBER_TABLE;
771: l_sub_bestprice_tbl JTF_NUMBER_TABLE;
772:
773: l_sub_status_code_tbl JTF_VARCHAR2_TABLE_100;
774: l_sub_status_text_tbl JTF_VARCHAR2_TABLE_300;
775:
776: l_sub_parentIndex_tbl JTF_NUMBER_TABLE;
777: l_sub_childIndex_tbl JTF_NUMBER_TABLE;

Line 1026: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1022: ,x_status_text OUT NOCOPY varchar2
1023: )
1024: IS
1025: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1026: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1027: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1028: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1029: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1030: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 1029: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1025: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1026: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1027: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1028: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1029: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1030: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1031:
1032: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1033: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1036: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1032: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1033: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1034:
1035: --gzhang 01/21/01, model bundle cache
1036: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1037:
1038: x_return_status VARCHAR2(1);
1039: x_return_status_text VARCHAR2(240);
1040:

Line 1113: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1109: ,x_status_text OUT NOCOPY varchar2
1110: )
1111: IS
1112: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1113: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1114: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1115: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1116: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1117: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 1116: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1112: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1113: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1114: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1115: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1116: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1117: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1118:
1119: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1120: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1123: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1119: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1120: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1121:
1122: --gzhang 01/21/01, model bundle cache
1123: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1124:
1125: x_return_status VARCHAR2(1);
1126: x_return_status_text VARCHAR2(240);
1127:

Line 1203: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1199: ,x_status_text OUT NOCOPY varchar2
1200: )
1201: IS
1202: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1203: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1204: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1205: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1206: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1207: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 1206: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1202: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1203: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1204: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1205: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1206: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1207: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1208:
1209: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1210: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1213: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1209: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1210: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1211:
1212: --gzhang 01/21/01, model bundle cache
1213: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1214:
1215: x_return_status VARCHAR2(1);
1216: x_return_status_text VARCHAR2(240);
1217:

Line 1303: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1299: ,x_related_status_text OUT NOCOPY varchar2
1300: )
1301: IS
1302: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1303: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1304: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1305: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1306: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1307: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 1306: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1302: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1303: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1304: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1305: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1306: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1307: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1308:
1309: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1310: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1316: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1312: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1313: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1314:
1315: --gzhang 01/21/01, model bundle cache
1316: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1317:
1318: x_return_status VARCHAR2(1);
1319: x_return_status_text VARCHAR2(240);
1320:

Line 1421: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1417: ,x_related_status_text OUT NOCOPY varchar2
1418: )
1419: IS
1420: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1421: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1422: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1423: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1424: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1425: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 1424: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1420: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1421: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1422: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1423: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1424: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1425: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1426:
1427: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1428: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1434: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1430: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1431: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1432:
1433: --gzhang 01/21/01, model bundle cache
1434: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1435:
1436: x_return_status VARCHAR2(1);
1437: x_return_status_text VARCHAR2(240);
1438:

Line 1542: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1538: ,x_related_status_text OUT NOCOPY varchar2
1539: )
1540: IS
1541: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1542: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1543: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1544: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1545: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1546: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 1545: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1541: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1542: l_uom_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1543: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1544: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1545: l_status_code_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1546: l_status_text_tbl JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1547:
1548: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1549: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1555: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1551: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1552: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1553:
1554: --gzhang 01/21/01, model bundle cache
1555: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1556:
1557: x_return_status VARCHAR2(1);
1558: x_return_status_text VARCHAR2(240);
1559:

Line 1638: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1634: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
1635:
1636: ,p_currency_code IN VARCHAR2
1637: ,p_item_tbl IN JTF_NUMBER_TABLE
1638: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1639: -- ,p_calculate_flag IN CHAR(1) :='Y'
1640:
1641: --gzhang 01/21/01, model bundle cache
1642: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

Line 1642: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

1638: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1639: -- ,p_calculate_flag IN CHAR(1) :='Y'
1640:
1641: --gzhang 01/21/01, model bundle cache
1642: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
1643:
1644: ,p_request_type_code IN VARCHAR2
1645: ,p_pricing_event IN VARCHAR2
1646: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1648: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1644: ,p_request_type_code IN VARCHAR2
1645: ,p_pricing_event IN VARCHAR2
1646: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1647: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1648: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1649: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1650: ,x_return_status out nocopy varchar2
1651: ,x_return_status_text out nocopy varchar2
1652:

Line 1703: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1699: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
1700:
1701: ,p_currency_code IN VARCHAR2
1702: ,p_item_tbl IN JTF_NUMBER_TABLE
1703: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1704: -- ,p_calculate_flag IN CHAR(1) :='Y'
1705:
1706: --gzhang 01/21/01, model bundle cache
1707: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

Line 1707: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

1703: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1704: -- ,p_calculate_flag IN CHAR(1) :='Y'
1705:
1706: --gzhang 01/21/01, model bundle cache
1707: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
1708:
1709: ,p_request_type_code IN VARCHAR2
1710: ,p_pricing_event IN VARCHAR2
1711: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1713: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1709: ,p_request_type_code IN VARCHAR2
1710: ,p_pricing_event IN VARCHAR2
1711: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1712: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1713: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1714: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1715: ,x_return_status out nocopy varchar2
1716: ,x_return_status_text out nocopy varchar2
1717:

Line 1770: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1766: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
1767:
1768: ,p_currency_code IN VARCHAR2
1769: ,p_item_tbl IN JTF_NUMBER_TABLE
1770: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1771: -- ,p_calculate_flag IN CHAR(1) :='Y'
1772:
1773: --gzhang 01/21/01, model bundle cache
1774: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

Line 1774: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

1770: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1771: -- ,p_calculate_flag IN CHAR(1) :='Y'
1772:
1773: --gzhang 01/21/01, model bundle cache
1774: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
1775:
1776: ,p_request_type_code IN VARCHAR2
1777: ,p_pricing_event IN VARCHAR2
1778: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1780: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1776: ,p_request_type_code IN VARCHAR2
1777: ,p_pricing_event IN VARCHAR2
1778: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1779: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1780: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1781: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1782: ,x_return_status out nocopy varchar2
1783: ,x_return_status_text out nocopy varchar2
1784:

Line 1836: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1832: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
1833:
1834: ,p_currency_code IN VARCHAR2
1835: ,p_item_tbl IN JTF_NUMBER_TABLE
1836: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1837: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1838: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1839: -- ,p_calculate_flag IN CHAR(1) :='Y'
1840:

Line 1842: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

1838: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1839: -- ,p_calculate_flag IN CHAR(1) :='Y'
1840:
1841: --gzhang 01/21/01, model bundle cache
1842: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
1843:
1844: ,p_request_type_code IN VARCHAR2
1845: ,p_pricing_event IN VARCHAR2
1846: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1848: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1844: ,p_request_type_code IN VARCHAR2
1845: ,p_pricing_event IN VARCHAR2
1846: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1847: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1848: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1849: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1850: ,x_parentIndex_tbl out nocopy JTF_NUMBER_TABLE
1851: ,x_childIndex_tbl out nocopy JTF_NUMBER_TABLE
1852: ,x_return_status out nocopy varchar2

Line 1905: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1901: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
1902:
1903: ,p_currency_code IN VARCHAR2
1904: ,p_item_tbl IN JTF_NUMBER_TABLE
1905: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1906: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1907: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1908: -- ,p_calculate_flag IN CHAR(1) :='Y'
1909:

Line 1911: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

1907: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1908: -- ,p_calculate_flag IN CHAR(1) :='Y'
1909:
1910: --gzhang 01/21/01, model bundle cache
1911: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
1912:
1913: ,p_request_type_code IN VARCHAR2
1914: ,p_pricing_event IN VARCHAR2
1915: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1917: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1913: ,p_request_type_code IN VARCHAR2
1914: ,p_pricing_event IN VARCHAR2
1915: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1916: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1917: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1918: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1919: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1920: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1921: ,x_return_status out nocopy varchar2

Line 1976: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100

1972: ,p_organization_id IN NUMBER := FND_API.G_MISS_NUM
1973:
1974: ,p_currency_code IN VARCHAR2
1975: ,p_item_tbl IN JTF_NUMBER_TABLE
1976: ,p_uom_tbl IN JTF_VARCHAR2_TABLE_100
1977: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE
1978: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1979: -- ,p_calculate_flag IN CHAR(1) :='Y'
1980:

Line 1982: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

1978: ,p_childIndex_tbl IN JTF_NUMBER_TABLE
1979: -- ,p_calculate_flag IN CHAR(1) :='Y'
1980:
1981: --gzhang 01/21/01, model bundle cache
1982: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
1983:
1984: ,p_request_type_code IN VARCHAR2
1985: ,p_pricing_event IN VARCHAR2
1986: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 1988: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100

1984: ,p_request_type_code IN VARCHAR2
1985: ,p_pricing_event IN VARCHAR2
1986: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE
1987: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE
1988: ,x_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100
1989: ,x_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300
1990: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1991: ,x_childIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE
1992: ,x_return_status out nocopy varchar2

Line 2051: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

2047: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2048: ,p_request_type_code IN VARCHAR2 := 'ASO'
2049: ,p_pricing_event IN VARCHAR2
2050: ,x_price_csr OUT NOCOPY PRICE_REFCURSOR_TYPE
2051: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
2052: ,x_return_status OUT NOCOPY VARCHAR2
2053: ,x_return_status_text OUT NOCOPY VARCHAR2
2054: )
2055: IS

Line 2191: X_LINE_INDEX_TBL := JTF_VARCHAR2_TABLE_100();

2187: IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||
2188: ': populating line items..., total line items='||p_item_tbl.count);
2189: END IF;
2190:
2191: X_LINE_INDEX_TBL := JTF_VARCHAR2_TABLE_100();
2192: X_LINE_INDEX_TBL.EXTEND(p_item_tbl.count+1);
2193: FOR I in p_item_tbl.FIRST..p_item_tbl.LAST LOOP
2194: l_target_duration := NULL;
2195: l_service_duration := NULL;

Line 2515: ,p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100

2511: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
2512: ,p_currency_code IN VARCHAR2
2513: ,p_minisite_id IN NUMBER := NULL
2514: ,p_item_tbl IN JTF_NUMBER_TABLE
2515: ,p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100
2516: ,p_model_id_tbl IN JTF_NUMBER_TABLE
2517: ,p_line_quantity_tbl IN JTF_NUMBER_TABLE
2518: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := NULL
2519: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := NULL

Line 2523: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100

2519: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := NULL
2520: ,p_request_type_code IN VARCHAR2 := 'ASO'
2521: ,p_pricing_event IN VARCHAR2
2522: ,x_price_csr OUT NOCOPY PRICE_REFCURSOR_TYPE
2523: ,x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
2524: ,x_return_status OUT NOCOPY VARCHAR2
2525: ,x_return_status_text OUT NOCOPY VARCHAR2
2526: )
2527: IS