[Home] [Help]
380:
381: CURSOR C_get_lines (c_import_interface_id number)
382: IS
383: select category_id, sum(budget_amount) budget_amount
384: from as_imp_lines_interface
385: where import_interface_id = c_import_interface_id
386: and category_id is not null
387: group by category_id;
388:
2381: AND status in ('ACTIVE','ONHOLD', 'COMPLETED');
2382:
2383: -- ffang 082401, for supporting multiple lines
2384: CURSOR c_get_lines (c_import_interface_id number) IS
2385: select * from as_imp_lines_interface
2386: where import_interface_id = c_import_interface_id;
2387:
2388: l_index NUMBER;
2389: -- end ffang 082401
2607: LL.source_promotion_id;
2608: l_sales_lead_line_tbl(l_index).offer_id := LL.offer_id;
2609: END LOOP;
2610:
2611: -- ffang 091201, support not only the lines in as_imp_lines_interface
2612: -- but also in as_import_interface
2613: -- Sales lead line 1 in as_import_interface
2614: G_SL_LINE_COUNT := 0;
2615: IF pI.category_id_1 IS NOT NULL OR (pI.inventory_item_id_1 IS NOT NULL AND pI.organization_id_1 IS NOT NULL) THEN
2889: l_interest_out_id NUMBER;
2890: l_msg_data VARCHAR2(2000) := NULL;
2891:
2892: CURSOR c_get_lines_1 (c_import_interface_id number) IS
2893: select * from as_imp_lines_interface
2894: where import_interface_id = c_import_interface_id;
2895: l_ll_index NUMBER;
2896:
2897: Begin
2971: p_msg_data => l_msg_data,
2972: p_interest_out_id => l_interest_out_id) ;
2973: End Loop;
2974:
2975: -- For the lines in as_imp_lines_interface
2976: l_ll_index := 0;
2977: FOR LL1 in c_get_lines_1(pI.import_interface_id) LOOP
2978: l_ll_index := l_ll_index + 1;
2979: