DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVE_PVT dependencies on JTF_NUMBER_TABLE

Line 1843: ,p_ql_line_codes IN jtf_number_table := NULL

1839: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
1840: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
1841: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
1842: := ASO_Quote_Pub.G_Miss_Control_Rec
1843: ,p_ql_line_codes IN jtf_number_table := NULL
1844: ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
1845: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec
1846:
1847: ,p_hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 1927: l_itemIdListSRV jtf_number_table := NULL;

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

Line 2192: l_itemIdListSRV := JTF_NUMBER_TABLE();

2188:
2189: FOR rec_service in c_getServiceInvId( p_Qte_Header_Rec.quote_header_id) LOOP
2190:
2191: IF(l_itemIdListSRV is NULL ) THEN
2192: l_itemIdListSRV := JTF_NUMBER_TABLE();
2193: END IF;
2194: IF (l_chkPrevRefLine is null) THEN -- if we're just starting
2195: --DBMS_OUTPUT.PUT_line('just starting: l_svcIndex ='||l_svcIndex);
2196: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2248: l_itemIdListSRV := JTF_NUMBER_TABLE();

2244: IF ((l_itemIdListSRV is null)
2245: and (l_suppLevelProfileValue is not null)
2246: and (l_suppLevelProfileValue <> 'NONE') and (l_hasSVA = 'N') ) THEN
2247: -- parse suppLevelProfileValue -- delimiter = ',' -> put in l_itemIdListSRV
2248: l_itemIdListSRV := JTF_NUMBER_TABLE();
2249: l_profValueSize := length(l_suppLevelProfileValue);
2250: l_startIndex := 1;
2251: --DBMS_OUTPUT.PUT_line(' start: l_profValueSize ='||l_profValueSize);
2252: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2867: ,p_ql_line_codes IN jtf_number_table := NULL

2863: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
2864: ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
2865: ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
2866: := ASO_Quote_Pub.G_Miss_Control_Rec
2867: ,p_ql_line_codes IN jtf_number_table := NULL
2868: ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
2869: := ASO_Quote_Pub.G_MISS_Qte_Header_Rec
2870: ,p_hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type
2871: := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl

Line 7665: ,p_instance_ids IN jtf_number_table := NULL

7661: ,p_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
7662: := ASO_QUOTE_PUB.G_Miss_Control_Rec
7663: ,p_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
7664: := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec
7665: ,p_instance_ids IN jtf_number_table := NULL
7666: ,x_config_line OUT NOCOPY ConfigCurTyp
7667: ,x_last_update_date OUT NOCOPY DATE
7668: ,x_return_status OUT NOCOPY VARCHAR2
7669: ,x_msg_count OUT NOCOPY NUMBER

Line 7928: p_svc_item_id_tbl IN JTF_NUMBER_TABLE,

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

Line 7930: px_svc_duration_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 7957: px_svc_duration_tbl := JTF_NUMBER_TABLE();

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

Line 8046: p_quote_line_id_tbl IN JTF_NUMBER_TABLE := NULL,

8042: x_msg_count OUT NOCOPY NUMBER,
8043: x_msg_data OUT NOCOPY VARCHAR2,
8044:
8045: p_quote_header_id IN NUMBER,
8046: p_quote_line_id_tbl IN JTF_NUMBER_TABLE := NULL,
8047: p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,
8048: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,
8049: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
8050:

Line 8047: p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,

8043: x_msg_data OUT NOCOPY VARCHAR2,
8044:
8045: p_quote_header_id IN NUMBER,
8046: p_quote_line_id_tbl IN JTF_NUMBER_TABLE := NULL,
8047: p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,
8048: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,
8049: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
8050:
8051: p_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 8048: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,

8044:
8045: p_quote_header_id IN NUMBER,
8046: p_quote_line_id_tbl IN JTF_NUMBER_TABLE := NULL,
8047: p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,
8048: p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,
8049: p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
8050:
8051: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
8052: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

Line 8070: l_quote_line_id_tbl JTF_NUMBER_TABLE := p_quote_line_id_tbl;

8066:
8067: l_sharee_party_id NUMBER := FND_API.G_MISS_NUM;
8068: l_sharee_cust_account_id NUMBER := FND_API.G_MISS_NUM;
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;

Line 8071: l_line_quantity_tbl JTF_NUMBER_TABLE := p_line_quantity_tbl;

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

Line 8072: l_new_service_id_tbl JTF_NUMBER_TABLE := p_new_service_id_tbl;

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

Line 8074: l_new_service_duration_tbl JTF_NUMBER_TABLE := NULL;

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