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 3183: x_item_exists OUT NOCOPY jtf_number_Table,

3179: p_data => x_msg_data);
3180: END Update_Config_Item_Lines;
3181:
3182: procedure Validate_Items(
3183: x_item_exists OUT NOCOPY jtf_number_Table,
3184: p_cust_account_id IN NUMBER,
3185: p_minisite_id IN NUMBER,
3186: p_merchant_item_ids IN JTF_NUMBER_TABLE,
3187: p_org_id IN NUMBER

Line 3186: p_merchant_item_ids IN JTF_NUMBER_TABLE,

3182: procedure Validate_Items(
3183: x_item_exists OUT NOCOPY jtf_number_Table,
3184: p_cust_account_id IN NUMBER,
3185: p_minisite_id IN NUMBER,
3186: p_merchant_item_ids IN JTF_NUMBER_TABLE,
3187: p_org_id IN NUMBER
3188: ) IS
3189: l_item_exists NUMBER;
3190: l_count NUMBER;

Line 3193: x_item_exists := JTF_NUMBER_TABLE();

3189: l_item_exists NUMBER;
3190: l_count NUMBER;
3191: BEGIN
3192: l_count := p_merchant_item_ids.COUNT;
3193: x_item_exists := JTF_NUMBER_TABLE();
3194: x_item_exists.extend(l_count);
3195:
3196:
3197: FOR i IN 1..l_count LOOP

Line 3225: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE

3221: x_msg_count OUT NOCOPY NUMBER,
3222: x_msg_data OUT NOCOPY VARCHAR2,
3223: p_organization_id IN NUMBER := NULL,
3224: p_product_item_id IN NUMBER,
3225: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE
3226: ) IS
3227: l_warranty_tbl ASO_SERVICE_CONTRACTS_INT.War_tbl_type;
3228: l_count NUMBER;
3229: BEGIN

Line 3258: x_service_item_ids := JTF_NUMBER_TABLE();

3254: IBE_UTIL.Debug(' ASO_SERVICE_CONTRACTS_INT.Get_Warranty Finishes ' || x_return_status ||
3255: ' x_warranty_tbl.COUNT=' || l_count);
3256: END IF;
3257:
3258: x_service_item_ids := JTF_NUMBER_TABLE();
3259:
3260: IF l_count > 0 THEN
3261: x_service_item_ids.extend(l_count);
3262: FOR i in 1..l_count LOOP

Line 3285: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE

3281: p_product_item_id IN NUMBER,
3282: p_customer_id IN NUMBER,
3283: p_product_revision IN VARCHAR2,
3284: p_request_date IN DATE,
3285: x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE
3286: ) IS
3287: l_avail_service_rec ASO_SERVICE_CONTRACTS_INT.Avail_Service_Rec_Type;
3288: l_orderable_Service_tbl ASO_SERVICE_CONTRACTS_INT.order_service_tbl_type;
3289: l_count NUMBER;

Line 3331: x_service_item_ids := JTF_NUMBER_TABLE();

3327: IBE_UTIL.Debug(' ASO_SERVICE_CONTRACTS_INT.Available_Services Finishes ' || x_return_status || ' ' ||
3328: 'x_orderable_service_tbl.COUNT=' || l_count);
3329: END IF;
3330:
3331: x_service_item_ids := JTF_NUMBER_TABLE();
3332:
3333: IF l_count > 0 THEN
3334: x_service_item_ids.extend(l_count);
3335: FOR i IN 1..l_count LOOP

Line 3852: ,p_quantities IN jtf_number_table

3848: ,X_Msg_Count OUT NOCOPY NUMBER
3849: ,X_Msg_Data OUT NOCOPY VARCHAR2
3850: ,p_quote_header_id IN NUMBER
3851: ,p_qte_line_id IN NUMBER
3852: ,p_quantities IN jtf_number_table
3853: ,p_last_update_date IN OUT NOCOPY DATE
3854: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
3855: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
3856: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM