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_NUMBER_TABLE

Line 523: ,p_item_tbl IN JTF_NUMBER_TABLE

519: --gzhang 12/03/01 model bundle support
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'

Line 525: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null

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
529: ,p_pricing_event IN VARCHAR2

Line 526: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null

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
529: ,p_pricing_event IN VARCHAR2
530: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

Line 530: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

526: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null
527: -- ,p_calculate_flag IN CHAR(1) :='Y'
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

Line 531: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

527: -- ,p_calculate_flag IN CHAR(1) :='Y'
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

Line 534: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE

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
537: ,x_return_status_text out nocopy varchar2
538: )

Line 535: ,x_childIndex_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
537: ,x_return_status_text out nocopy varchar2
538: )
539: IS

Line 681: x_listprice_tbl := JTF_NUMBER_TABLE();

677:
678: -- clear values in global structures that were used
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:

Line 682: x_bestprice_tbl := JTF_NUMBER_TABLE();

678: -- clear values in global structures that were used
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();

Line 686: x_parentIndex_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();
688:
689: x_listprice_tbl.extend(l_line_tbl.count);
690: x_bestprice_tbl.extend(l_line_tbl.count);

Line 687: x_childIndex_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();
688:
689: x_listprice_tbl.extend(l_line_tbl.count);
690: x_bestprice_tbl.extend(l_line_tbl.count);
691: x_status_code_tbl.extend(l_line_tbl.count);

Line 742: ,p_item_tbl IN JTF_NUMBER_TABLE

738: ,p_model_id IN NUMBER --:= FND_API.G_MISS_NUM
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:

Line 744: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := null

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
748: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

Line 745: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := null

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
748: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL
749:

Line 752: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

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
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

Line 753: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

749:
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

Line 756: ,x_parentIndex_tbl OUT nocopy JTF_NUMBER_TABLE

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
759: ,x_return_status_text out nocopy varchar2
760: )

Line 757: ,x_childIndex_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
759: ,x_return_status_text out nocopy varchar2
760: )
761: IS

Line 766: l_sub_itm_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

762:
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;

Line 768: l_sub_qty_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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;
772:

Line 770: l_sub_listprice_tbl JTF_NUMBER_TABLE;

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;
772:
773: l_sub_status_code_tbl JTF_VARCHAR2_TABLE_100;
774: l_sub_status_text_tbl JTF_VARCHAR2_TABLE_300;

Line 771: l_sub_bestprice_tbl 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;
772:
773: l_sub_status_code_tbl JTF_VARCHAR2_TABLE_100;
774: l_sub_status_text_tbl JTF_VARCHAR2_TABLE_300;
775:

Line 776: l_sub_parentIndex_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;
778:
779: l_sub_return_status varchar2(1);
780: l_sub_return_status_text varchar2(30);

Line 777: l_sub_childIndex_tbl JTF_NUMBER_TABLE;

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;
778:
779: l_sub_return_status varchar2(1);
780: l_sub_return_status_text varchar2(30);
781:

Line 1025: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1021: ,x_status_code OUT NOCOPY varchar2
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();

Line 1027: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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

Line 1028: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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();
1031:
1032: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1032: l_parentIndex_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();
1034:
1035: --gzhang 01/21/01, model bundle cache
1036: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 1033: l_childIndex_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();
1034:
1035: --gzhang 01/21/01, model bundle cache
1036: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1037:

Line 1112: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1108: ,x_status_code OUT NOCOPY varchar2
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();

Line 1114: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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

Line 1115: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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();
1118:
1119: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1119: l_parentIndex_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();
1121:
1122: --gzhang 01/21/01, model bundle cache
1123: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 1120: l_childIndex_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();
1121:
1122: --gzhang 01/21/01, model bundle cache
1123: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1124:

Line 1202: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1198: ,x_status_code OUT NOCOPY varchar2
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();

Line 1204: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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

Line 1205: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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();
1208:
1209: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1209: l_parentIndex_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();
1211:
1212: --gzhang 01/21/01, model bundle cache
1213: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 1210: l_childIndex_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();
1211:
1212: --gzhang 01/21/01, model bundle cache
1213: l_modelbundle_flag_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1214:

Line 1302: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1298: ,x_related_status_code OUT NOCOPY varchar2
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();

Line 1304: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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

Line 1305: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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();
1308:
1309: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1309: l_parentIndex_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();
1311:
1312: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1313: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1310: l_childIndex_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();
1311:
1312: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1313: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1314:

Line 1312: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1308:
1309: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1310: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1311:
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();

Line 1313: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1309: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1310: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1311:
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:

Line 1420: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1416: ,x_related_status_code OUT NOCOPY varchar2
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();

Line 1422: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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

Line 1423: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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();
1426:
1427: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1427: l_parentIndex_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();
1429:
1430: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1431: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1428: l_childIndex_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();
1429:
1430: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1431: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1432:

Line 1430: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1426:
1427: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1428: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1429:
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();

Line 1431: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1427: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1428: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1429:
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:

Line 1541: l_item_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1537: ,x_related_status_code OUT NOCOPY varchar2
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();

Line 1543: l_listprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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

Line 1544: l_bestprice_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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();
1547:
1548: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1548: l_parentIndex_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();
1550:
1551: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1552: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1549: l_childIndex_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();
1550:
1551: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1552: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1553:

Line 1551: lx_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1547:
1548: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1549: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1550:
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();

Line 1552: lx_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1548: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1549: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1550:
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:

Line 1637: ,p_item_tbl IN JTF_NUMBER_TABLE

1633: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
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

Line 1646: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

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
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

Line 1647: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1643:
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

Line 1657: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1653: )
1654: IS
1655: l_version VARCHAR2(240);
1656:
1657: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1658: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1659:
1660: BEGIN
1661: --gzhang 08/08/2002, bug#2488246

Line 1658: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1654: IS
1655: l_version VARCHAR2(240);
1656:
1657: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1658: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1659:
1660: BEGIN
1661: --gzhang 08/08/2002, bug#2488246
1662: --ibe_util.enable_debug;

Line 1702: ,p_item_tbl IN JTF_NUMBER_TABLE

1698: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
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

Line 1711: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

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
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

Line 1712: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1708:
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

Line 1720: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1716: ,x_return_status_text out nocopy varchar2
1717:
1718: )
1719: IS
1720: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1721: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1722:
1723: BEGIN
1724: --gzhang 08/08/2002, bug#2488246

Line 1721: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1717:
1718: )
1719: IS
1720: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1721: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1722:
1723: BEGIN
1724: --gzhang 08/08/2002, bug#2488246
1725: --ibe_util.enable_debug;

Line 1769: ,p_item_tbl IN JTF_NUMBER_TABLE

1765: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
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

Line 1778: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

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
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

Line 1779: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1775:
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

Line 1787: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1783: ,x_return_status_text out nocopy varchar2
1784:
1785: )
1786: IS
1787: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1788: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1789:
1790: BEGIN
1791: --gzhang 08/08/2002, bug#2488246

Line 1788: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1784:
1785: )
1786: IS
1787: l_parentIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1788: l_childIndex_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1789:
1790: BEGIN
1791: --gzhang 08/08/2002, bug#2488246
1792: --ibe_util.enable_debug;

Line 1835: ,p_item_tbl IN JTF_NUMBER_TABLE

1831: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
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'

Line 1837: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE

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:
1841: --gzhang 01/21/01, model bundle cache

Line 1838: ,p_childIndex_tbl IN JTF_NUMBER_TABLE

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:
1841: --gzhang 01/21/01, model bundle cache
1842: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

Line 1846: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

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
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

Line 1847: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1843:
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

Line 1850: ,x_parentIndex_tbl out nocopy JTF_NUMBER_TABLE

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
1853: ,x_return_status_text out nocopy varchar2
1854: )

Line 1851: ,x_childIndex_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
1853: ,x_return_status_text out nocopy varchar2
1854: )
1855: IS

Line 1904: ,p_item_tbl IN JTF_NUMBER_TABLE

1900: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
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'

Line 1906: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE

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:
1910: --gzhang 01/21/01, model bundle cache

Line 1907: ,p_childIndex_tbl IN JTF_NUMBER_TABLE

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:
1910: --gzhang 01/21/01, model bundle cache
1911: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

Line 1915: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

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
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

Line 1916: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1912:
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

Line 1919: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

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

Line 1920: ,x_childIndex_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
1922: ,x_return_status_text out nocopy varchar2
1923:
1924: )

Line 1975: ,p_item_tbl IN JTF_NUMBER_TABLE

1971: ,p_model_id IN NUMBER := FND_API.G_MISS_NUM
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'

Line 1977: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE

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:
1981: --gzhang 01/21/01, model bundle cache

Line 1978: ,p_childIndex_tbl IN JTF_NUMBER_TABLE

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:
1981: --gzhang 01/21/01, model bundle cache
1982: ,p_model_bundle_flag_tbl IN JTF_VARCHAR2_TABLE_100 := NULL

Line 1986: ,x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE

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
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

Line 1987: ,x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE

1983:
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

Line 1990: ,x_parentIndex_tbl OUT NOCOPY JTF_NUMBER_TABLE

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

Line 1991: ,x_childIndex_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
1993: ,x_return_status_text out nocopy varchar2
1994:
1995: )

Line 2044: ,p_model_id_tbl IN JTF_NUMBER_TABLE

2040: ,p_currency_code IN VARCHAR2
2041: ,p_minisite_id IN NUMBER := NULL
2042: ,p_item_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2043: ,p_uom_code_tbl IN OUT NOCOPY QP_PREQ_GRP.VARCHAR_TYPE
2044: ,p_model_id_tbl IN JTF_NUMBER_TABLE
2045: ,p_line_quantity_tbl IN OUT NOCOPY QP_PREQ_GRP.NUMBER_TYPE
2046: ,p_parentIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2047: ,p_childIndex_tbl IN QP_PREQ_GRP.NUMBER_TYPE
2048: ,p_request_type_code IN VARCHAR2 := 'ASO'

Line 2514: ,p_item_tbl IN JTF_NUMBER_TABLE

2510: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
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

Line 2516: ,p_model_id_tbl IN JTF_NUMBER_TABLE

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
2520: ,p_request_type_code IN VARCHAR2 := 'ASO'

Line 2517: ,p_line_quantity_tbl IN JTF_NUMBER_TABLE

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
2520: ,p_request_type_code IN VARCHAR2 := 'ASO'
2521: ,p_pricing_event IN VARCHAR2

Line 2518: ,p_parentIndex_tbl IN JTF_NUMBER_TABLE := 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
2520: ,p_request_type_code IN VARCHAR2 := 'ASO'
2521: ,p_pricing_event IN VARCHAR2
2522: ,x_price_csr OUT NOCOPY PRICE_REFCURSOR_TYPE

Line 2519: ,p_childIndex_tbl IN JTF_NUMBER_TABLE := NULL

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
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