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 1928: l_uomCodeListSRV JTF_VARCHAR2_TABLE_100 := NULL;

1924:
1925: l_svcIndex number;
1926: l_chkPrevRefLine number := NULL;
1927: l_itemIdListSRV jtf_number_table := NULL;
1928: l_uomCodeListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1929: l_periodListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1930: l_durationListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1931:
1932: l_isCartEmpty varchar2(1) := 'N';

Line 1929: l_periodListSRV JTF_VARCHAR2_TABLE_100 := NULL;

1925: l_svcIndex number;
1926: l_chkPrevRefLine number := NULL;
1927: l_itemIdListSRV jtf_number_table := NULL;
1928: l_uomCodeListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1929: l_periodListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1930: l_durationListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1931:
1932: l_isCartEmpty varchar2(1) := 'N';
1933: l_isCartSupp varchar2(1) := 'N';

Line 1930: l_durationListSRV JTF_VARCHAR2_TABLE_100 := NULL;

1926: l_chkPrevRefLine number := NULL;
1927: l_itemIdListSRV jtf_number_table := NULL;
1928: l_uomCodeListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1929: l_periodListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1930: l_durationListSRV JTF_VARCHAR2_TABLE_100 := NULL;
1931:
1932: l_isCartEmpty varchar2(1) := 'N';
1933: l_isCartSupp varchar2(1) := 'N';
1934: l_line_level_services varchar2(1) := 'N';

Line 2304: l_uomCodeListSRV := JTF_VARCHAR2_TABLE_100();

2300: */
2301:
2302: -- for performance reasons we can keep track of values that have already been queried from mtl_system_items_vl table
2303: IF (l_uomCodeListSRV is null) THEN
2304: l_uomCodeListSRV := JTF_VARCHAR2_TABLE_100();
2305: l_periodListSRV := JTF_VARCHAR2_TABLE_100();
2306: l_durationListSRV := JTF_VARCHAR2_TABLE_100();
2307: ELSE
2308: l_hasQueriedItems := 'Y';

Line 2305: l_periodListSRV := JTF_VARCHAR2_TABLE_100();

2301:
2302: -- for performance reasons we can keep track of values that have already been queried from mtl_system_items_vl table
2303: IF (l_uomCodeListSRV is null) THEN
2304: l_uomCodeListSRV := JTF_VARCHAR2_TABLE_100();
2305: l_periodListSRV := JTF_VARCHAR2_TABLE_100();
2306: l_durationListSRV := JTF_VARCHAR2_TABLE_100();
2307: ELSE
2308: l_hasQueriedItems := 'Y';
2309: END IF;

Line 2306: l_durationListSRV := JTF_VARCHAR2_TABLE_100();

2302: -- for performance reasons we can keep track of values that have already been queried from mtl_system_items_vl table
2303: IF (l_uomCodeListSRV is null) THEN
2304: l_uomCodeListSRV := JTF_VARCHAR2_TABLE_100();
2305: l_periodListSRV := JTF_VARCHAR2_TABLE_100();
2306: l_durationListSRV := JTF_VARCHAR2_TABLE_100();
2307: ELSE
2308: l_hasQueriedItems := 'Y';
2309: END IF;
2310:

Line 7929: px_svc_period_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

7925: -- p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
7926: p_sva_line_id IN NUMBER,
7927: p_sva_line_qty IN NUMBER,
7928: p_svc_item_id_tbl IN JTF_NUMBER_TABLE,
7929: px_svc_period_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
7930: px_svc_duration_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
7931: px_svc_uom_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
7932:
7933: px_quote_line_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type,

Line 7931: px_svc_uom_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

7927: p_sva_line_qty IN NUMBER,
7928: p_svc_item_id_tbl IN JTF_NUMBER_TABLE,
7929: px_svc_period_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
7930: px_svc_duration_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
7931: px_svc_uom_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
7932:
7933: px_quote_line_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type,
7934: px_line_rec_index IN OUT NOCOPY PLS_INTEGER,
7935: px_quote_line_dtl_tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_dtl_Tbl_Type,

Line 7956: px_svc_period_tbl := JTF_VARCHAR2_TABLE_100();

7952: IBE_UTIL.debug('enter ADD_CART_LEVEL_SERVICES');
7953: END IF;
7954:
7955: IF px_svc_period_tbl IS NULL THEN
7956: px_svc_period_tbl := JTF_VARCHAR2_TABLE_100();
7957: px_svc_duration_tbl := JTF_NUMBER_TABLE();
7958: px_svc_uom_tbl := JTF_VARCHAR2_TABLE_100();
7959: l_load_svc_detail := TRUE;
7960: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 7958: px_svc_uom_tbl := JTF_VARCHAR2_TABLE_100();

7954:
7955: IF px_svc_period_tbl IS NULL THEN
7956: px_svc_period_tbl := JTF_VARCHAR2_TABLE_100();
7957: px_svc_duration_tbl := JTF_NUMBER_TABLE();
7958: px_svc_uom_tbl := JTF_VARCHAR2_TABLE_100();
7959: l_load_svc_detail := TRUE;
7960: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
7961: IBE_UTIL.debug('l_load_svc_detail is true');
7962: END IF;

Line 8073: l_new_service_period_tbl JTF_VARCHAR2_TABLE_100 := NULL;

8069:
8070: l_quote_line_id_tbl JTF_NUMBER_TABLE := p_quote_line_id_tbl;
8071: l_line_quantity_tbl JTF_NUMBER_TABLE := p_line_quantity_tbl;
8072: l_new_service_id_tbl JTF_NUMBER_TABLE := p_new_service_id_tbl;
8073: l_new_service_period_tbl JTF_VARCHAR2_TABLE_100 := NULL;
8074: l_new_service_duration_tbl JTF_NUMBER_TABLE := NULL;
8075: l_new_service_uom_tbl JTF_VARCHAR2_TABLE_100 := NULL;
8076:
8077: l_sva_line_size PLS_INTEGER := 0;

Line 8075: l_new_service_uom_tbl JTF_VARCHAR2_TABLE_100 := NULL;

8071: l_line_quantity_tbl JTF_NUMBER_TABLE := p_line_quantity_tbl;
8072: l_new_service_id_tbl JTF_NUMBER_TABLE := p_new_service_id_tbl;
8073: l_new_service_period_tbl JTF_VARCHAR2_TABLE_100 := NULL;
8074: l_new_service_duration_tbl JTF_NUMBER_TABLE := NULL;
8075: l_new_service_uom_tbl JTF_VARCHAR2_TABLE_100 := NULL;
8076:
8077: l_sva_line_size PLS_INTEGER := 0;
8078: l_curr_sva_line_id NUMBER := NULL;
8079: l_curr_line_qty NUMBER := NULL;

Line 8090: l_deleted_svc_map_tbl JTF_VARCHAR2_TABLE_100 := NULL;

8086: l_dtl_rec_index PLS_INTEGER := 1;
8087: i PLS_INTEGER := 1;
8088:
8089: l_map_index PLS_INTEGER := 1;
8090: l_deleted_svc_map_tbl JTF_VARCHAR2_TABLE_100 := NULL;
8091:
8092: l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;
8093: l_quote_header_rec ASO_Quote_Pub.Qte_Header_Rec_Type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;
8094: l_quote_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL;

Line 8334: l_deleted_svc_map_tbl := JTF_VARCHAR2_TABLE_100();

8330: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
8331: IBE_UTIL.debug('The first SVA line detected');
8332: END IF;
8333: IF l_deleted_svc_map_tbl IS NULL THEN
8334: l_deleted_svc_map_tbl := JTF_VARCHAR2_TABLE_100();
8335: END IF;
8336: l_deleted_svc_map_tbl.EXTEND;
8337: l_deleted_svc_map_tbl(l_map_index) := 'DELETE';
8338: IF l_new_service_id_tbl IS NOT NULL AND l_new_service_id_tbl.count >0 THEN