APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_ADV_MOD_PRODUCTS

Line 2463: -- update QP_ADV_MOD_PRODUCTS for changed lines

2459: END Check_Line_for_Header_Qual;
2460:
2461:
2462: --hw
2463: -- update QP_ADV_MOD_PRODUCTS for changed lines
2464:
2465: procedure update_changed_lines_add (
2466: p_list_line_id in number,
2467: p_list_header_id in number,

Line 2486: insert into qp_adv_mod_products (

2482: --update_changed_lines_act,update_changed_lines_del/_add/_ph
2483:
2484: begin
2485:
2486: insert into qp_adv_mod_products (
2487: product_attribute,
2488: product_attr_value,
2489: pricing_phase_id) (
2490: select distinct qpa.product_attribute,

Line 2496: select 'Y' from qp_adv_mod_products

2492: p_pricing_phase_id
2493: from qp_pricing_attributes qpa
2494: where qpa.list_line_id = p_list_line_id
2495: and not exists (
2496: select 'Y' from qp_adv_mod_products
2497: where pricing_phase_id = p_pricing_phase_id
2498: and product_attribute = qpa.product_attribute
2499: and product_attr_value = qpa.product_attr_value));
2500:

Line 2534: delete from qp_adv_mod_products

2530: --update_changed_lines_act,update_changed_lines_del/_add/_ph
2531:
2532: begin
2533:
2534: delete from qp_adv_mod_products
2535: where pricing_phase_id = p_pricing_phase_id
2536: and product_attribute = p_product_attribute
2537: and product_attr_value = p_product_attr_value
2538: and not exists (

Line 2605: insert into qp_adv_mod_products (

2601: --update_changed_lines_act,update_changed_lines_del/_add/_ph
2602: begin
2603:
2604: -- process new phase id
2605: insert into qp_adv_mod_products (
2606: product_attribute,
2607: product_attr_value,
2608: pricing_phase_id) (
2609: select distinct qpa.product_attribute,

Line 2615: select 'Y' from qp_adv_mod_products

2611: p_pricing_phase_id
2612: from qp_pricing_attributes qpa
2613: where qpa.list_line_id = p_list_line_id
2614: and not exists (
2615: select 'Y' from qp_adv_mod_products
2616: where pricing_phase_id = p_pricing_phase_id
2617: and product_attribute = qpa.product_attribute
2618: and product_attr_value = qpa.product_attr_value));
2619:

Line 2631: delete from qp_adv_mod_products

2627: from qp_pricing_attributes
2628: where list_line_id = p_list_line_id;
2629:
2630: --tuned SQl to avoid cartesian join
2631: delete from qp_adv_mod_products
2632: where pricing_phase_id = p_old_pricing_phase_id
2633: and product_attribute = l_product_attribute
2634: and product_attr_value = l_product_attr_value
2635: and not exists (

Line 2723: insert into qp_adv_mod_products (

2719: if p_active_flag = 'Y' then
2720:
2721: for line_cursor in l_get_line_csr loop
2722:
2723: insert into qp_adv_mod_products (
2724: pricing_phase_id,
2725: product_attribute,
2726: product_attr_value
2727: ) (

Line 2733: select 'Y' from qp_adv_mod_products

2729: line_cursor.product_attribute,
2730: line_cursor.product_attr_value
2731: from dual
2732: where not exists (
2733: select 'Y' from qp_adv_mod_products
2734: where pricing_phase_id = line_cursor.pricing_phase_id
2735: and product_attribute = line_cursor.product_attribute
2736: and product_attr_value = line_cursor.product_attr_value));
2737:

Line 2745: delete from qp_adv_mod_products

2741:
2742: for line_cursor in l_get_line_csr loop
2743:
2744: --tuned SQl to avoid cartesian join
2745: delete from qp_adv_mod_products
2746: where pricing_phase_id = line_cursor.pricing_phase_id
2747: and product_attribute = line_cursor.product_attribute
2748: and product_attr_value = line_cursor.product_attr_value
2749: and not exists (