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_QUOTE_SAVE_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 1909: l_uomCodeListSRV JTF_VARCHAR2_TABLE_100 := NULL;

1905:
1906: l_svcIndex number;
1907: l_chkPrevRefLine number := NULL;
1908: l_itemIdListSRV jtf_number_table := NULL;
1909: l_uomCodeListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1910: l_periodListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1911: l_durationListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1912:
1913: l_isCartEmpty varchar2(1) := 'N';

Line 1910: l_periodListSRV JTF_VARCHAR2_TABLE_100 := NULL;

1906: l_svcIndex number;
1907: l_chkPrevRefLine number := NULL;
1908: l_itemIdListSRV jtf_number_table := NULL;
1909: l_uomCodeListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1910: l_periodListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1911: l_durationListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1912:
1913: l_isCartEmpty varchar2(1) := 'N';
1914: l_isCartSupp varchar2(1) := 'N';

Line 1911: l_durationListSRV JTF_VARCHAR2_TABLE_100 := NULL;

1907: l_chkPrevRefLine number := NULL;
1908: l_itemIdListSRV jtf_number_table := NULL;
1909: l_uomCodeListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1910: l_periodListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1911: l_durationListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1912:
1913: l_isCartEmpty varchar2(1) := 'N';
1914: l_isCartSupp varchar2(1) := 'N';
1915: l_line_level_services varchar2(1) := 'N';

Line 2285: l_uomCodeListSRV := JTF_VARCHAR2_TABLE_100();

2281: */
2282:
2283: -- for performance reasons we can keep track of values that have already been queried from mtl_system_items_vl table
2284: IF (l_uomCodeListSRV is null) THEN
2285: l_uomCodeListSRV := JTF_VARCHAR2_TABLE_100();
2286: l_periodListSRV := JTF_VARCHAR2_TABLE_100();
2287: l_durationListSRV := JTF_VARCHAR2_TABLE_100();
2288: ELSE
2289: l_hasQueriedItems := 'Y';

Line 2286: l_periodListSRV := JTF_VARCHAR2_TABLE_100();

2282:
2283: -- for performance reasons we can keep track of values that have already been queried from mtl_system_items_vl table
2284: IF (l_uomCodeListSRV is null) THEN
2285: l_uomCodeListSRV := JTF_VARCHAR2_TABLE_100();
2286: l_periodListSRV := JTF_VARCHAR2_TABLE_100();
2287: l_durationListSRV := JTF_VARCHAR2_TABLE_100();
2288: ELSE
2289: l_hasQueriedItems := 'Y';
2290: END IF;

Line 2287: l_durationListSRV := JTF_VARCHAR2_TABLE_100();

2283: -- for performance reasons we can keep track of values that have already been queried from mtl_system_items_vl table
2284: IF (l_uomCodeListSRV is null) THEN
2285: l_uomCodeListSRV := JTF_VARCHAR2_TABLE_100();
2286: l_periodListSRV := JTF_VARCHAR2_TABLE_100();
2287: l_durationListSRV := JTF_VARCHAR2_TABLE_100();
2288: ELSE
2289: l_hasQueriedItems := 'Y';
2290: END IF;
2291:

Line 7787: px_svc_period_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

7783: -- p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
7784: p_sva_line_id IN NUMBER,
7785: p_sva_line_qty IN NUMBER,
7786: p_svc_item_id_tbl IN JTF_NUMBER_TABLE,
7787: px_svc_period_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
7788: px_svc_duration_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
7789: px_svc_uom_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
7790:
7791: px_quote_line_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type,

Line 7789: px_svc_uom_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

7785: p_sva_line_qty IN NUMBER,
7786: p_svc_item_id_tbl IN JTF_NUMBER_TABLE,
7787: px_svc_period_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
7788: px_svc_duration_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
7789: px_svc_uom_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
7790:
7791: px_quote_line_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type,
7792: px_line_rec_index IN OUT NOCOPY PLS_INTEGER,
7793: px_quote_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_dtl_Tbl_Type,

Line 7814: px_svc_period_tbl := JTF_VARCHAR2_TABLE_100();

7810: IBE_UTIL.debug('enter ADD_CART_LEVEL_SERVICES');
7811: END IF;
7812:
7813: IF px_svc_period_tbl IS NULL THEN
7814: px_svc_period_tbl := JTF_VARCHAR2_TABLE_100();
7815: px_svc_duration_tbl := JTF_NUMBER_TABLE();
7816: px_svc_uom_tbl := JTF_VARCHAR2_TABLE_100();
7817: l_load_svc_detail := TRUE;
7818: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 7816: px_svc_uom_tbl := JTF_VARCHAR2_TABLE_100();

7812:
7813: IF px_svc_period_tbl IS NULL THEN
7814: px_svc_period_tbl := JTF_VARCHAR2_TABLE_100();
7815: px_svc_duration_tbl := JTF_NUMBER_TABLE();
7816: px_svc_uom_tbl := JTF_VARCHAR2_TABLE_100();
7817: l_load_svc_detail := TRUE;
7818: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
7819: IBE_UTIL.debug('l_load_svc_detail is true');
7820: END IF;

Line 7931: l_new_service_period_tbl JTF_VARCHAR2_TABLE_100 := NULL;

7927:
7928: l_quote_line_id_tbl JTF_NUMBER_TABLE := p_quote_line_id_tbl;
7929: l_line_quantity_tbl JTF_NUMBER_TABLE := p_line_quantity_tbl;
7930: l_new_service_id_tbl JTF_NUMBER_TABLE := p_new_service_id_tbl;
7931: l_new_service_period_tbl JTF_VARCHAR2_TABLE_100 := NULL;
7932: l_new_service_duration_tbl JTF_NUMBER_TABLE := NULL;
7933: l_new_service_uom_tbl JTF_VARCHAR2_TABLE_100 := NULL;
7934:
7935: l_sva_line_size PLS_INTEGER := 0;

Line 7933: l_new_service_uom_tbl JTF_VARCHAR2_TABLE_100 := NULL;

7929: l_line_quantity_tbl JTF_NUMBER_TABLE := p_line_quantity_tbl;
7930: l_new_service_id_tbl JTF_NUMBER_TABLE := p_new_service_id_tbl;
7931: l_new_service_period_tbl JTF_VARCHAR2_TABLE_100 := NULL;
7932: l_new_service_duration_tbl JTF_NUMBER_TABLE := NULL;
7933: l_new_service_uom_tbl JTF_VARCHAR2_TABLE_100 := NULL;
7934:
7935: l_sva_line_size PLS_INTEGER := 0;
7936: l_curr_sva_line_id NUMBER := NULL;
7937: l_curr_line_qty NUMBER := NULL;

Line 7948: l_deleted_svc_map_tbl JTF_VARCHAR2_TABLE_100 := NULL;

7944: l_dtl_rec_index PLS_INTEGER := 1;
7945: i PLS_INTEGER := 1;
7946:
7947: l_map_index PLS_INTEGER := 1;
7948: l_deleted_svc_map_tbl JTF_VARCHAR2_TABLE_100 := NULL;
7949:
7950: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
7951: l_quote_header_rec ASO_Quote_Pub.Qte_Header_Rec_Type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
7952: l_quote_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

Line 8192: l_deleted_svc_map_tbl := JTF_VARCHAR2_TABLE_100();

8188: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
8189: IBE_UTIL.debug('The first SVA line detected');
8190: END IF;
8191: IF l_deleted_svc_map_tbl IS NULL THEN
8192: l_deleted_svc_map_tbl := JTF_VARCHAR2_TABLE_100();
8193: END IF;
8194: l_deleted_svc_map_tbl.EXTEND;
8195: l_deleted_svc_map_tbl(l_map_index) := 'DELETE';
8196: IF l_new_service_id_tbl IS NOT NULL AND l_new_service_id_tbl.count >0 THEN