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_PS_ATTR_GRP_PVT dependencies on QP_ATTRIBUTE_GROUPS

Line 24: FROM qp_attribute_groups

20: FROM
21: ( -- Modifier Lines
22: SELECT pricing_phase_id, pattern_id, START_DATE_ACTIVE_L sda,
23: END_DATE_ACTIVE_L eda, active_flag
24: FROM qp_attribute_groups
25: WHERE list_line_id <> -1
26: UNION ALL
27: -- Modifier Headers
28: SELECT /*+ ordered USE_NL(qplhp qpag) */

Line 31: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag

27: -- Modifier Headers
28: SELECT /*+ ordered USE_NL(qplhp qpag) */
29: qplhp.pricing_phase_id, qpag.pattern_id,
30: qpag.START_DATE_ACTIVE_H sda, qpag.END_DATE_ACTIVE_H eda, qpag.active_flag
31: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag
32: WHERE qpag.list_header_id = qplhp.list_header_id
33: AND qpag.list_line_id = -1
34: UNION ALL
35: -- Price List Lines

Line 46: FROM qp_attribute_groups

42: UNION ALL
43: -- Price List headers
44: SELECT pricing_phase_id, pattern_id,
45: START_DATE_ACTIVE_H sda, END_DATE_ACTIVE_H eda, active_flag
46: FROM qp_attribute_groups
47: WHERE pricing_phase_id = 1
48: AND list_line_id = -1
49: )b
50: GROUP BY pricing_phase_id, pattern_id;

Line 61: FROM qp_attribute_groups

57: FROM
58: ( -- Modifier Lines
59: SELECT pricing_phase_id, pattern_id, START_DATE_ACTIVE_L sda,
60: END_DATE_ACTIVE_L eda, active_flag
61: FROM qp_attribute_groups
62: WHERE list_line_id <> -1
63: AND list_header_id = p_list_header_id
64: UNION ALL
65: -- Modifier Headers

Line 69: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag

65: -- Modifier Headers
66: SELECT /*+ ordered USE_NL(qplhp qpag) */
67: qplhp.pricing_phase_id, qpag.pattern_id,
68: qpag.START_DATE_ACTIVE_H sda, qpag.END_DATE_ACTIVE_H eda, qpag.active_flag
69: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag
70: WHERE qplhp.list_header_id = p_list_header_id
71: AND qpag.list_header_id = qplhp.list_header_id
72: AND qpag.list_line_id = -1
73: )b

Line 96: FROM qp_attribute_groups

92: UNION ALL
93: -- Price List headers
94: SELECT pricing_phase_id, pattern_id,
95: START_DATE_ACTIVE_H sda, END_DATE_ACTIVE_H eda, active_flag
96: FROM qp_attribute_groups
97: WHERE pricing_phase_id = 1
98: AND list_header_id = p_list_header_id
99: AND list_line_id = -1
100: )b

Line 112: FROM qp_attribute_groups

108: FROM
109: ( -- Modifier Lines
110: SELECT pricing_phase_id, pattern_id, START_DATE_ACTIVE_L sda,
111: END_DATE_ACTIVE_L eda, active_flag
112: FROM qp_attribute_groups
113: WHERE list_line_id <> -1
114: UNION ALL
115: -- Modifier Headers
116: SELECT /*+ ordered */

Line 119: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag

115: -- Modifier Headers
116: SELECT /*+ ordered */
117: qplhp.pricing_phase_id, qpag.pattern_id,
118: qpag.START_DATE_ACTIVE_H sda, qpag.END_DATE_ACTIVE_H eda, qpag.active_flag
119: FROM qp_list_header_phases qplhp, qp_attribute_groups qpag
120: WHERE qpag.list_line_id = -1
121: AND qpag.list_header_id = qplhp.list_header_id
122: )b
123: GROUP BY pricing_phase_id, pattern_id;

Line 144: FROM qp_attribute_groups

140: UNION ALL
141: -- Price List headers
142: SELECT pricing_phase_id, pattern_id,
143: START_DATE_ACTIVE_H sda, END_DATE_ACTIVE_H eda, active_flag
144: FROM qp_attribute_groups
145: WHERE pricing_phase_id = 1
146: AND list_line_id = -1
147: )b
148: GROUP BY pricing_phase_id, pattern_id;

Line 218: FROM qp_attribute_groups qpg

214: l_start_date_tbl,
215: l_end_date_tbl,
216: l_active_flag_tbl
217: --bug 9594320 start
218: FROM qp_attribute_groups qpg
219: WHERE qpg.list_line_id = p_min_list_line_id;
220:
221: END IF; -- IF 1.1
222:

Line 591: update qp_attribute_groups

587: from qp_patterns c
588: where c.pattern_type = g_pattern_pat_type_final_tbl(i)
589: and c.pattern_string = g_pattern_pat_string_final_tbl(i);
590: IF g_qp_pattern_search = 'M' THEN
591: update qp_attribute_groups
592: set pattern_id = l_min_pattern_id
593: where pattern_id = g_pattern_pattern_id_final_tbl(i);
594: ELSIF g_pattern_pat_type_final_tbl(i) = 'PP' then
595: update /*+ index(lines QP_LIST_LINES_N9) */ qp_list_lines lines

Line 599: update qp_attribute_groups

595: update /*+ index(lines QP_LIST_LINES_N9) */ qp_list_lines lines
596: set pattern_id = l_min_pattern_id
597: where pattern_id = g_pattern_pattern_id_final_tbl(i);
598: else
599: update qp_attribute_groups
600: set pattern_id = l_min_pattern_id
601: where pattern_id = g_pattern_pattern_id_final_tbl(i);
602: end if;
603:

Line 636: from qp_attribute_groups

632: nvl(max(active_flag),'N') active_flag
633: from
634: ( -- Modifier Lines
635: select pricing_phase_id, pattern_id, START_DATE_ACTIVE_L sda, END_DATE_ACTIVE_L eda, active_flag
636: from qp_attribute_groups
637: where list_line_id <> -1
638: UNION ALL
639: -- Modifier Headers
640: select /*+ ordered */ qplhp.pricing_phase_id, qpag.pattern_id, qpag.START_DATE_ACTIVE_H sda,

Line 642: from qp_list_header_phases qplhp, qp_attribute_groups qpag

638: UNION ALL
639: -- Modifier Headers
640: select /*+ ordered */ qplhp.pricing_phase_id, qpag.pattern_id, qpag.START_DATE_ACTIVE_H sda,
641: qpag.END_DATE_ACTIVE_H eda, qpag.active_flag
642: from qp_list_header_phases qplhp, qp_attribute_groups qpag
643: where qpag.list_header_id = qplhp.list_header_id
644: and qpag.list_line_id = -1
645: union all
646: -- Price List Lines

Line 656: from qp_attribute_groups

652: union ALL
653: -- Price List headers
654: select pricing_phase_id, pattern_id, START_DATE_ACTIVE_H sda,
655: END_DATE_ACTIVE_H eda, active_flag
656: from qp_attribute_groups
657: where pricing_phase_id = 1
658: and list_line_id = -1
659: ) b
660: where b.pricing_phase_id = a.pricing_phase_id

Line 776: select list_line_id from qp_attribute_groups where eq_flag = 'N'

772: AND segment_id in
773: (select pricing_segment_id
774: from qp_pricing_attributes
775: where /*list_line_id in (
776: select list_line_id from qp_attribute_groups where eq_flag = 'N'
777: UNION
778: select list_line_id from qp_list_lines where eq_flag = 'N')
779: and */
780: --list_header_id = nvl(p_list_header_id, list_header_id)

Line 787: select list_line_id from qp_attribute_groups where eq_flag = 'N'

783: UNION all
784: select segment_id
785: from qp_qualifiers
786: where /*list_line_id in (
787: select list_line_id from qp_attribute_groups where eq_flag = 'N'
788: UNION
789: select list_line_id from qp_list_lines where eq_flag = 'N')
790: and */
791: --list_header_id = nvl(p_list_header_id, list_header_id)

Line 802: select list_line_id from qp_attribute_groups where eq_flag = 'N'

798: AND segment_id in
799: (select pricing_segment_id
800: from qp_pricing_attributes
801: where /*list_line_id in (
802: select list_line_id from qp_attribute_groups where eq_flag = 'N'
803: UNION
804: select list_line_id from qp_list_lines where eq_flag = 'N')
805: and */
806: list_header_id = p_list_header_id

Line 813: select list_line_id from qp_attribute_groups where eq_flag = 'N'

809: UNION all
810: select segment_id
811: from qp_qualifiers
812: where /*list_line_id in (
813: select list_line_id from qp_attribute_groups where eq_flag = 'N'
814: UNION
815: select list_line_id from qp_list_lines where eq_flag = 'N')
816: and */
817: list_header_id = p_list_header_id

Line 886: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_attribute_groups';

882: THEN
883:
884: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_pattern_phases';
885: EXECUTE IMMEDIATE l_stmt;
886: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_attribute_groups';
887: EXECUTE IMMEDIATE l_stmt;
888: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_patterns';
889: EXECUTE IMMEDIATE l_stmt;
890:

Line 896: delete from qp_attribute_groups

892:
893: write_log( 'Deleted all records from 3 Pattern Master tables');
894: else
895: -- refresh only for the passed list_header_id
896: delete from qp_attribute_groups
897: where list_header_id = p_list_header_id
898: and list_line_id = -1;
899: write_log( 'Deleted records from qp_attribute_groups for HP for list_header_id:'||p_list_header_id);
900:

Line 899: write_log( 'Deleted records from qp_attribute_groups for HP for list_header_id:'||p_list_header_id);

895: -- refresh only for the passed list_header_id
896: delete from qp_attribute_groups
897: where list_header_id = p_list_header_id
898: and list_line_id = -1;
899: write_log( 'Deleted records from qp_attribute_groups for HP for list_header_id:'||p_list_header_id);
900:
901: end if;
902: Update_Qual_Segment_id(p_list_header_id, null, -1, -1);
903: generate_hp_atgrps(p_list_header_id, null);

Line 972: delete from qp_attribute_groups

968:
969: else
970: -- refresh only for the passed list_header_id */
971:
972: delete from qp_attribute_groups
973: where list_header_id = p_list_header_id
974: and list_line_id <> -1;
975:
976: /* update qp_list_lines

Line 1007: delete from qp_attribute_groups

1003: -- END IF;
1004: -- else
1005: -- refresh only for the passed list_header_id
1006:
1007: delete from qp_attribute_groups
1008: where list_header_id = p_list_header_id
1009: and list_line_id between p_low_list_line_id and p_high_list_line_id;
1010: --IF g_qp_pattern_search <> 'M' THEN
1011: /*update /*+ index_asc(lines QP_LIST_LINES_N18) *//* qp_list_lines lines

Line 2848: -- insert into qp_attribute_groups from final tables

2844:
2845: -- move data for last pair of header and line id
2846: Move_data_from_tmp_to_final(p_pattern_type);
2847:
2848: -- insert into qp_attribute_groups from final tables
2849: populate_atgrps;
2850:
2851: -- for line pattern, qp_list_lines.cache_key need to be populated as well
2852: IF g_qp_pattern_search <> 'M' THEN ----

Line 3233: -- move the data from tmp tables to final tables for qp_attribute_groups

3229: Populate_Pattern_Phases(null, g_pricing_phase_id_tmp_tbl(grp_no_index), l_pattern_id);
3230: elsif p_pattern_type = 'HP' THEN
3231: Populate_Pattern_Phases(g_list_header_id_tmp_tbl(grp_no_index), null, l_pattern_id);
3232: end if;
3233: -- move the data from tmp tables to final tables for qp_attribute_groups
3234: /*
3235: if g_call_from_setup = 'Y' then
3236: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
3237: else

Line 3236: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');

3232: end if;
3233: -- move the data from tmp tables to final tables for qp_attribute_groups
3234: /*
3235: if g_call_from_setup = 'Y' then
3236: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
3237: else
3238: write_log( 'move the data from tmp tables to final tables for qp_attribute_groups');
3239: end if;
3240: */

Line 3238: write_log( 'move the data from tmp tables to final tables for qp_attribute_groups');

3234: /*
3235: if g_call_from_setup = 'Y' then
3236: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
3237: else
3238: write_log( 'move the data from tmp tables to final tables for qp_attribute_groups');
3239: end if;
3240: */
3241:
3242: l_atgrp_final_index := g_list_header_id_final_tbl.count + 1;

Line 3523: INSERT INTO qp_attribute_groups

3519: BEGIN
3520:
3521: oe_debug_pub.add('total count - ' || g_list_line_id_final_tbl.COUNT);
3522: FORALL i in 1 .. g_list_line_id_final_tbl.COUNT
3523: INSERT INTO qp_attribute_groups
3524:
3525: (list_header_id,
3526: list_line_id,
3527: pattern_id,

Line 3662: INSERT INTO qp_attribute_groups

3658: is
3659: BEGIN
3660:
3661: FORALL i in 1 .. g_list_header_id_final_tbl.count
3662: INSERT INTO qp_attribute_groups
3663: (list_header_id,
3664: list_line_id,
3665: active_flag,
3666: list_type_code,

Line 4345: -- delete from qp_attribute_groups first

4341:
4342: -- when called while set up of modifier/price list
4343: if p_setup_action <> 'UD' then
4344: -- No need to delete pattern in case of update in denormalized columns in header
4345: -- delete from qp_attribute_groups first
4346: if p_qualifier_group is null then
4347: delete from qp_attribute_groups
4348: where list_header_id = p_list_header_id
4349: and list_line_id = -1;

Line 4347: delete from qp_attribute_groups

4343: if p_setup_action <> 'UD' then
4344: -- No need to delete pattern in case of update in denormalized columns in header
4345: -- delete from qp_attribute_groups first
4346: if p_qualifier_group is null then
4347: delete from qp_attribute_groups
4348: where list_header_id = p_list_header_id
4349: and list_line_id = -1;
4350: elsif p_qualifier_group is not null then
4351: delete from qp_attribute_groups

Line 4351: delete from qp_attribute_groups

4347: delete from qp_attribute_groups
4348: where list_header_id = p_list_header_id
4349: and list_line_id = -1;
4350: elsif p_qualifier_group is not null then
4351: delete from qp_attribute_groups
4352: where list_header_id = p_list_header_id
4353: and list_line_id = -1
4354: and GROUPING_NO in (-1, p_qualifier_group);
4355: end if;

Line 4361: -- populate the records in qp_attribute_groups afresh for p_list_header_id, list_line_id -1

4357: -- update the segment_id columns for qualifiers
4358: Update_Qual_Segment_id(p_list_header_id, p_qualifier_group, -1, -1);
4359: end if;
4360:
4361: -- populate the records in qp_attribute_groups afresh for p_list_header_id, list_line_id -1
4362: -- and p_qualifier_group
4363: if p_setup_action = 'I' then
4364: -- insert case
4365: generate_hp_atgrps(p_list_header_id, p_qualifier_group);

Line 4415: -- this may insert in qp_attribute_groups with HDR_QUAL_GROUPING_NO = -1, if any

4411: end;
4412:
4413: if l_qual_exists = 'N' then
4414: -- no qualifiers exist other than -1 qualifier_grouping_no
4415: -- this may insert in qp_attribute_groups with HDR_QUAL_GROUPING_NO = -1, if any
4416: -- qualifiers exist with qualifier_grouping_no = -1
4417: generate_hp_atgrps(p_list_header_id, p_qualifier_group);
4418: end if; -- l_qual_exists = 'N'
4419: end if; -- l_qual_exists = 'Y'

Line 4458: update qp_attribute_groups

4454: from qp_list_headers_all_b
4455: where list_header_id = p_list_header_id;
4456:
4457: -- update header pattern records
4458: update qp_attribute_groups
4459: set ACTIVE_FLAG = l_ACTIVE_FLAG,
4460: LIST_TYPE_CODE = l_LIST_TYPE_CODE,
4461: CURRENCY_CODE = l_CURRENCY_CODE,
4462: ASK_FOR_FLAG = l_ASK_FOR_FLAG,

Line 4479: /* update qp_attribute_groups

4475: where list_header_id = p_list_header_id;
4476: -- and list_line_id = -1;
4477:
4478: -- update line pattern records
4479: /* update qp_attribute_groups
4480: set ACTIVE_FLAG = l_ACTIVE_FLAG,
4481: LIST_TYPE_CODE = l_LIST_TYPE_CODE,
4482: CURRENCY_CODE = l_CURRENCY_CODE,
4483: ASK_FOR_FLAG = l_ASK_FOR_FLAG,

Line 4521: update qp_attribute_groups

4517: when no_data_found then
4518: l_qual_exists := 'N';
4519: end;
4520:
4521: update qp_attribute_groups
4522:
4523: set HEADER_QUALS_EXIST_FLAG = l_QUAL_EXISTS
4524: where list_header_id = p_list_header_id;
4525:

Line 4548: select list_line_id from qp_attribute_groups where eq_flag = 'N'

4544: AND segment_id in
4545: (select pricing_segment_id
4546: from qp_pricing_attributes
4547: where /*list_line_id in (
4548: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4549: UNION
4550: select list_line_id from qp_list_lines where eq_flag = 'N')
4551: and */list_header_id = nvl(p_list_header_id, list_header_id)
4552: --AND comparison_operator_code <> '='

Line 4558: select list_line_id from qp_attribute_groups where eq_flag = 'N'

4554: UNION all
4555: select segment_id
4556: from qp_qualifiers
4557: where /*list_line_id in (
4558: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4559: UNION
4560: select list_line_id from qp_list_lines where eq_flag = 'N')
4561: and */list_header_id = nvl(p_list_header_id, list_header_id)
4562: --AND comparison_operator_code <> '='

Line 4620: -- delete from qp_attribute_groups first

4616: END IF;
4617:
4618: -- when called while set up of modifier
4619: if p_setup_action <> 'UD' then
4620: -- delete from qp_attribute_groups first
4621: if p_qualifier_group is null then
4622: delete from qp_attribute_groups
4623: where list_header_id = p_list_header_id
4624: and list_line_id = p_list_line_id;

Line 4622: delete from qp_attribute_groups

4618: -- when called while set up of modifier
4619: if p_setup_action <> 'UD' then
4620: -- delete from qp_attribute_groups first
4621: if p_qualifier_group is null then
4622: delete from qp_attribute_groups
4623: where list_header_id = p_list_header_id
4624: and list_line_id = p_list_line_id;
4625: elsif p_qualifier_group is not null then
4626: delete from qp_attribute_groups

Line 4626: delete from qp_attribute_groups

4622: delete from qp_attribute_groups
4623: where list_header_id = p_list_header_id
4624: and list_line_id = p_list_line_id;
4625: elsif p_qualifier_group is not null then
4626: delete from qp_attribute_groups
4627: where list_header_id = p_list_header_id
4628: and list_line_id = p_list_line_id
4629: and GROUPING_NO in (-1, p_qualifier_group);
4630: end if;

Line 4639: -- populate the records in qp_attribute_groups afresh for p_list_header_id, p_list_line_id

4635: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes
4636: Update_Prod_Pric_Segment_id(p_list_header_id, p_list_line_id, p_list_line_id );
4637: end if;
4638:
4639: -- populate the records in qp_attribute_groups afresh for p_list_header_id, p_list_line_id
4640: -- and p_qualifier_group
4641: if p_setup_action = 'I' then
4642: -- insert case
4643: generate_lp_atgrps(p_list_header_id, p_qualifier_group,

Line 4696: -- this may insert in qp_attribute_groups with LINE_QUAL_GROUPING_NO = -1, if any

4692: end;
4693:
4694: if l_qual_exists = 'N' then
4695: -- no qualifiers exist other than -1 qualifier_grouping_no
4696: -- this may insert in qp_attribute_groups with LINE_QUAL_GROUPING_NO = -1, if any
4697: -- qualifiers exist with qualifier_grouping_no = -1
4698: update qp_list_lines
4699: set pattern_id = DECODE(qualification_ind,0,-2,-3),
4700: hash_key = null,

Line 4717: update qp_attribute_groups

4713: from qp_list_lines
4714: where list_line_id = p_list_line_id;
4715:
4716: -- update line pattern records
4717: update qp_attribute_groups
4718: set LINE_LIMIT_EXISTS = l_line_LIMIT_EXISTS
4719: where list_header_id = p_list_header_id
4720: and list_line_id = p_list_line_id;
4721:

Line 4743: from qp_attribute_groups

4739: -- line qualifier delete case
4740: begin
4741: select 'Y'
4742: into l_qual_exists
4743: from qp_attribute_groups
4744: where list_header_id = p_list_header_id
4745: and list_line_id = p_list_line_id
4746: and rownum = 1;
4747: exception

Line 4752: -- line qualifier insert/update case, assume there will be record in qp_attribute_groups

4748: when no_data_found then
4749: l_qual_exists := 'N';
4750: end;
4751: else
4752: -- line qualifier insert/update case, assume there will be record in qp_attribute_groups
4753: l_qual_exists := 'Y';
4754: end if;
4755:
4756: /* if p_setup_action = 'I' then

Line 4798: select list_line_id from qp_attribute_groups where eq_flag = 'N'

4794: AND segment_id in
4795: (select pricing_segment_id
4796: from qp_pricing_attributes
4797: where /*list_line_id in (
4798: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4799: UNION
4800: select list_line_id from qp_list_lines where eq_flag = 'N')
4801: and */list_header_id = nvl(p_list_header_id, list_header_id)
4802: --AND comparison_operator_code <> '='

Line 4808: select list_line_id from qp_attribute_groups where eq_flag = 'N'

4804: UNION all
4805: select segment_id
4806: from qp_qualifiers
4807: where /*list_line_id in (
4808: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4809: UNION
4810: select list_line_id from qp_list_lines where eq_flag = 'N')
4811: and */list_header_id = nvl(p_list_header_id, list_header_id)
4812: --AND comparison_operator_code <> '='

Line 4932: delete from qp_attribute_groups

4928:
4929: update_pp_lines(p_list_header_id, p_list_line_id, p_list_line_id);
4930: -- to generate blind row for the price list which does not have any qualifier
4931: -- IF (g_list_type IN ('PRL','AGR') )THEN
4932: delete from qp_attribute_groups
4933: where list_header_id = p_list_header_id
4934: AND list_line_id = -1;
4935: generate_hp_atgrps(p_list_header_id, null);
4936: -- END IF;

Line 4965: select list_line_id from qp_attribute_groups where eq_flag = 'N'

4961: AND segment_id in
4962: (select pricing_segment_id
4963: from qp_pricing_attributes
4964: where /*list_line_id in (
4965: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4966: UNION
4967: select list_line_id from qp_list_lines where eq_flag = 'N')
4968: and */list_header_id = nvl(p_list_header_id, list_header_id)
4969: --AND comparison_operator_code <> '='

Line 4975: select list_line_id from qp_attribute_groups where eq_flag = 'N'

4971: UNION all
4972: select segment_id
4973: from qp_qualifiers
4974: where /*list_line_id in (
4975: select list_line_id from qp_attribute_groups where eq_flag = 'N'
4976: UNION
4977: select list_line_id from qp_list_lines where eq_flag = 'N')
4978: and */list_header_id = nvl(p_list_header_id, list_header_id)
4979: --AND comparison_operator_code <> '='

Line 5012: delete from qp_attribute_groups

5008: and pattern_id is not null;*/
5009:
5010: ------ Added for PL/SQL Pattern Search
5011:
5012: delete from qp_attribute_groups
5013:
5014: where list_line_id = p_list_line_id;
5015:
5016: if g_call_from_setup = 'Y' then

Line 5017: oe_debug_pub.add('Deleted records from qp_attribute_groups for PP for list_line_id:'||p_list_line_id);

5013:
5014: where list_line_id = p_list_line_id;
5015:
5016: if g_call_from_setup = 'Y' then
5017: oe_debug_pub.add('Deleted records from qp_attribute_groups for PP for list_line_id:'||p_list_line_id);
5018: else
5019: write_log( 'Deleted records from qp_attribute_groups for PP for list_line_id:'||p_list_line_id);
5020: end if;
5021:

Line 5019: write_log( 'Deleted records from qp_attribute_groups for PP for list_line_id:'||p_list_line_id);

5015:
5016: if g_call_from_setup = 'Y' then
5017: oe_debug_pub.add('Deleted records from qp_attribute_groups for PP for list_line_id:'||p_list_line_id);
5018: else
5019: write_log( 'Deleted records from qp_attribute_groups for PP for list_line_id:'||p_list_line_id);
5020: end if;
5021:
5022:
5023: ------ Added for PL/SQL Pattern Search