eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_ADV_MOD_PRODUCTS

Line 2474: -- update QP_ADV_MOD_PRODUCTS for changed lines

2470: END Check_Line_for_Header_Qual;
2471:
2472:
2473: --hw
2474: -- update QP_ADV_MOD_PRODUCTS for changed lines
2475:
2476: procedure update_changed_lines_add (
2477: p_list_line_id in number,
2478: p_list_header_id in number,

Line 2497: insert into qp_adv_mod_products (

2493: --update_changed_lines_act,update_changed_lines_del/_add/_ph
2494:
2495: begin
2496:
2497: insert into qp_adv_mod_products (
2498: product_attribute,
2499: product_attr_value,
2500: pricing_phase_id) (
2501: select distinct qpa.product_attribute,

Line 2507: select 'Y' from qp_adv_mod_products

2503: p_pricing_phase_id
2504: from qp_pricing_attributes qpa
2505: where qpa.list_line_id = p_list_line_id
2506: and not exists (
2507: select 'Y' from qp_adv_mod_products
2508: where pricing_phase_id = p_pricing_phase_id
2509: and product_attribute = qpa.product_attribute
2510: and product_attr_value = qpa.product_attr_value));
2511:

Line 2545: delete from qp_adv_mod_products

2541: --update_changed_lines_act,update_changed_lines_del/_add/_ph
2542:
2543: begin
2544:
2545: delete from qp_adv_mod_products
2546: where pricing_phase_id = p_pricing_phase_id
2547: and product_attribute = p_product_attribute
2548: and product_attr_value = p_product_attr_value
2549: and not exists (

Line 2616: insert into qp_adv_mod_products (

2612: --update_changed_lines_act,update_changed_lines_del/_add/_ph
2613: begin
2614:
2615: -- process new phase id
2616: insert into qp_adv_mod_products (
2617: product_attribute,
2618: product_attr_value,
2619: pricing_phase_id) (
2620: select distinct qpa.product_attribute,

Line 2626: select 'Y' from qp_adv_mod_products

2622: p_pricing_phase_id
2623: from qp_pricing_attributes qpa
2624: where qpa.list_line_id = p_list_line_id
2625: and not exists (
2626: select 'Y' from qp_adv_mod_products
2627: where pricing_phase_id = p_pricing_phase_id
2628: and product_attribute = qpa.product_attribute
2629: and product_attr_value = qpa.product_attr_value));
2630:

Line 2642: delete from qp_adv_mod_products

2638: from qp_pricing_attributes
2639: where list_line_id = p_list_line_id;
2640:
2641: --tuned SQl to avoid cartesian join
2642: delete from qp_adv_mod_products
2643: where pricing_phase_id = p_old_pricing_phase_id
2644: and product_attribute = l_product_attribute
2645: and product_attr_value = l_product_attr_value
2646: and not exists (

Line 2734: insert into qp_adv_mod_products (

2730: if p_active_flag = 'Y' then
2731:
2732: for line_cursor in l_get_line_csr loop
2733:
2734: insert into qp_adv_mod_products (
2735: pricing_phase_id,
2736: product_attribute,
2737: product_attr_value
2738: ) (

Line 2744: select 'Y' from qp_adv_mod_products

2740: line_cursor.product_attribute,
2741: line_cursor.product_attr_value
2742: from dual
2743: where not exists (
2744: select 'Y' from qp_adv_mod_products
2745: where pricing_phase_id = line_cursor.pricing_phase_id
2746: and product_attribute = line_cursor.product_attribute
2747: and product_attr_value = line_cursor.product_attr_value));
2748:

Line 2756: delete from qp_adv_mod_products

2752:
2753: for line_cursor in l_get_line_csr loop
2754:
2755: --tuned SQl to avoid cartesian join
2756: delete from qp_adv_mod_products
2757: where pricing_phase_id = line_cursor.pricing_phase_id
2758: and product_attribute = line_cursor.product_attribute
2759: and product_attr_value = line_cursor.product_attr_value
2760: and not exists (