DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on JTF_NUMBER_TABLE

Line 2338: x_inventory_item_id_tbl OUT NOCOPY jtf_number_table ,

2334: p_cust_id IN NUMBER ,
2335: p_cust_item_number_tbl IN jtf_varchar2_table_100 ,
2336: p_organization_id IN NUMBER ,
2337: p_minisite_id IN NUMBER ,
2338: x_inventory_item_id_tbl OUT NOCOPY jtf_number_table ,
2339: x_return_status OUT NOCOPY VARCHAR2 ,
2340: x_msg_count OUT NOCOPY NUMBER ,
2341: x_msg_data OUT NOCOPY VARCHAR2
2342: )

Line 2384: x_inventory_item_id_Tbl := JTF_NUMBER_TABLE();

2380: END IF;
2381:
2382: l_count := p_cust_item_number_tbl.COUNT;
2383:
2384: x_inventory_item_id_Tbl := JTF_NUMBER_TABLE();
2385: x_inventory_item_id_Tbl.extend(l_count);
2386:
2387:
2388: FOR i IN 1..l_count LOOP

Line 2478: x_inventory_item_id_tbl IN OUT NOCOPY jtf_number_table ,

2474: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2475: p_cust_id IN NUMBER ,
2476: p_organization_id IN NUMBER ,
2477: p_minisite_id IN NUMBER ,
2478: x_inventory_item_id_tbl IN OUT NOCOPY jtf_number_table ,
2479: x_return_status OUT NOCOPY VARCHAR2 ,
2480: x_msg_count OUT NOCOPY NUMBER ,
2481: x_msg_data OUT NOCOPY VARCHAR2
2482: )

Line 3301: x_item_exists OUT NOCOPY jtf_number_Table,

3297: p_data => x_msg_data);
3298: END Update_Config_Item_Lines;
3299:
3300: procedure Validate_Items(
3301: x_item_exists OUT NOCOPY jtf_number_Table,
3302: p_cust_account_id IN NUMBER,
3303: p_minisite_id IN NUMBER,
3304: p_merchant_item_ids IN JTF_NUMBER_TABLE,
3305: p_org_id IN NUMBER

Line 3304: p_merchant_item_ids IN JTF_NUMBER_TABLE,

3300: procedure Validate_Items(
3301: x_item_exists OUT NOCOPY jtf_number_Table,
3302: p_cust_account_id IN NUMBER,
3303: p_minisite_id IN NUMBER,
3304: p_merchant_item_ids IN JTF_NUMBER_TABLE,
3305: p_org_id IN NUMBER
3306: ) IS
3307: l_item_exists NUMBER;
3308: l_count NUMBER;

Line 3311: x_item_exists := JTF_NUMBER_TABLE();

3307: l_item_exists NUMBER;
3308: l_count NUMBER;
3309: BEGIN
3310: l_count := p_merchant_item_ids.COUNT;
3311: x_item_exists := JTF_NUMBER_TABLE();
3312: x_item_exists.extend(l_count);
3313:
3314:
3315: FOR i IN 1..l_count LOOP

Line 3343: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE

3339: x_msg_count OUT NOCOPY NUMBER,
3340: x_msg_data OUT NOCOPY VARCHAR2,
3341: p_organization_id IN NUMBER := NULL,
3342: p_product_item_id IN NUMBER,
3343: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE
3344: ) IS
3345: l_warranty_tbl ASO_SERVICE_CONTRACTS_INT.War_tbl_type;
3346: l_count NUMBER;
3347: BEGIN

Line 3376: x_service_item_ids := JTF_NUMBER_TABLE();

3372: IBE_UTIL.Debug(' ASO_SERVICE_CONTRACTS_INT.Get_Warranty Finishes ' || x_return_status ||
3373: ' x_warranty_tbl.COUNT=' || l_count);
3374: END IF;
3375:
3376: x_service_item_ids := JTF_NUMBER_TABLE();
3377:
3378: IF l_count > 0 THEN
3379: x_service_item_ids.extend(l_count);
3380: FOR i in 1..l_count LOOP

Line 3403: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE

3399: p_product_item_id IN NUMBER,
3400: p_customer_id IN NUMBER,
3401: p_product_revision IN VARCHAR2,
3402: p_request_date IN DATE,
3403: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE
3404: ) IS
3405: l_avail_service_rec ASO_SERVICE_CONTRACTS_INT.Avail_Service_Rec_Type;
3406: l_orderable_Service_tbl ASO_SERVICE_CONTRACTS_INT.order_service_tbl_type;
3407: l_count NUMBER;

Line 3449: x_service_item_ids := JTF_NUMBER_TABLE();

3445: IBE_UTIL.Debug(' ASO_SERVICE_CONTRACTS_INT.Available_Services Finishes ' || x_return_status || ' ' ||
3446: 'x_orderable_service_tbl.COUNT=' || l_count);
3447: END IF;
3448:
3449: x_service_item_ids := JTF_NUMBER_TABLE();
3450:
3451: IF l_count > 0 THEN
3452: x_service_item_ids.extend(l_count);
3453: FOR i IN 1..l_count LOOP

Line 3970: ,p_quantities IN jtf_number_table

3966: ,X_Msg_Count OUT NOCOPY NUMBER
3967: ,X_Msg_Data OUT NOCOPY VARCHAR2
3968: ,p_quote_header_id IN NUMBER
3969: ,p_qte_line_id IN NUMBER
3970: ,p_quantities IN jtf_number_table
3971: ,p_last_update_date IN OUT NOCOPY DATE
3972: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
3973: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
3974: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM