DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVE_PVT dependencies on JTF_NUMBER_TABLE

Line 1824: ,p_ql_line_codes IN jtf_number_table := NULL

1820: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
1821: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
1822: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
1823: := ASO_Quote_Pub.G_Miss_Control_Rec
1824: ,p_ql_line_codes IN jtf_number_table := NULL
1825: ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
1826: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec
1827:
1828: ,p_hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 1908: l_itemIdListSRV jtf_number_table := NULL;

1904: l_quoteLineDetSize number;
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:

Line 2173: l_itemIdListSRV := JTF_NUMBER_TABLE();

2169:
2170: FOR rec_service in c_getServiceInvId( p_Qte_Header_Rec.quote_header_id) LOOP
2171:
2172: IF(l_itemIdListSRV is NULL ) THEN
2173: l_itemIdListSRV := JTF_NUMBER_TABLE();
2174: END IF;
2175: IF (l_chkPrevRefLine is null) THEN -- if we're just starting
2176: --DBMS_OUTPUT.PUT_line('just starting: l_svcIndex ='||l_svcIndex);
2177: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2229: l_itemIdListSRV := JTF_NUMBER_TABLE();

2225: IF ((l_itemIdListSRV is null)
2226: and (l_suppLevelProfileValue is not null)
2227: and (l_suppLevelProfileValue <> 'NONE') and (l_hasSVA = 'N') ) THEN
2228: -- parse suppLevelProfileValue -- delimiter = ',' -> put in l_itemIdListSRV
2229: l_itemIdListSRV := JTF_NUMBER_TABLE();
2230: l_profValueSize := length(l_suppLevelProfileValue);
2231: l_startIndex := 1;
2232: --DBMS_OUTPUT.PUT_line(' start: l_profValueSize ='||l_profValueSize);
2233: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2848: ,p_ql_line_codes IN jtf_number_table := NULL

2844: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
2845: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
2846: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
2847: := ASO_Quote_Pub.G_Miss_Control_Rec
2848: ,p_ql_line_codes IN jtf_number_table := NULL
2849: ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
2850: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec
2851: ,p_hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type
2852: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl

Line 7523: ,p_instance_ids IN jtf_number_table := NULL

7519: ,p_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
7520: := ASO_QUOTE_PUB.G_Miss_Control_Rec
7521: ,p_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
7522: := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec
7523: ,p_instance_ids IN jtf_number_table := NULL
7524: ,x_config_line OUT NOCOPY ConfigCurTyp
7525: ,x_last_update_date OUT NOCOPY DATE
7526: ,x_return_status OUT NOCOPY VARCHAR2
7527: ,x_msg_count OUT NOCOPY NUMBER

Line 7786: p_svc_item_id_tbl IN JTF_NUMBER_TABLE,

7782: p_organization_id IN NUMBER,
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:

Line 7788: px_svc_duration_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

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,
7792: px_line_rec_index IN OUT NOCOPY PLS_INTEGER,

Line 7815: px_svc_duration_tbl := JTF_NUMBER_TABLE();

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
7819: IBE_UTIL.debug('l_load_svc_detail is true');

Line 7904: p_quote_line_id_tbl IN JTF_NUMBER_TABLE := NULL,

7900: x_msg_count OUT NOCOPY NUMBER,
7901: x_msg_data OUT NOCOPY VARCHAR2,
7902:
7903: p_quote_header_id IN NUMBER,
7904: p_quote_line_id_tbl IN JTF_NUMBER_TABLE := NULL,
7905: p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,
7906: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,
7907: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
7908:

Line 7905: p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,

7901: x_msg_data OUT NOCOPY VARCHAR2,
7902:
7903: p_quote_header_id IN NUMBER,
7904: p_quote_line_id_tbl IN JTF_NUMBER_TABLE := NULL,
7905: p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,
7906: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,
7907: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
7908:
7909: p_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 7906: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,

7902:
7903: p_quote_header_id IN NUMBER,
7904: p_quote_line_id_tbl IN JTF_NUMBER_TABLE := NULL,
7905: p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,
7906: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,
7907: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
7908:
7909: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
7910: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

Line 7928: l_quote_line_id_tbl JTF_NUMBER_TABLE := p_quote_line_id_tbl;

7924:
7925: l_sharee_party_id NUMBER := FND_API.G_MISS_NUM;
7926: l_sharee_cust_account_id NUMBER := FND_API.G_MISS_NUM;
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;

Line 7929: l_line_quantity_tbl JTF_NUMBER_TABLE := p_line_quantity_tbl;

7925: l_sharee_party_id NUMBER := FND_API.G_MISS_NUM;
7926: l_sharee_cust_account_id NUMBER := FND_API.G_MISS_NUM;
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;

Line 7930: l_new_service_id_tbl JTF_NUMBER_TABLE := p_new_service_id_tbl;

7926: l_sharee_cust_account_id NUMBER := FND_API.G_MISS_NUM;
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:

Line 7932: l_new_service_duration_tbl JTF_NUMBER_TABLE := NULL;

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;
7936: l_curr_sva_line_id NUMBER := NULL;