APPS.QP_ATTR_GRP_PVT dependencies on QP_PATTERNS

Line 93: from qp_patterns a, qp_patterns b

89: l_min_pattern_id number;
90:
91: cursor c_dupl_pattern is
92: select distinct b.pattern_type, b.pattern_string, b.pattern_id
93: from qp_patterns a, qp_patterns b
94: where a.pattern_type = b.pattern_type
95: and a.pattern_string = b.pattern_string
96: and a.pattern_id <> b.pattern_id
97: and b.pattern_id >(select min(c.pattern_id)

Line 98: from qp_patterns c

94: where a.pattern_type = b.pattern_type
95: and a.pattern_string = b.pattern_string
96: and a.pattern_id <> b.pattern_id
97: and b.pattern_id >(select min(c.pattern_id)
98: from qp_patterns c
99: where c.pattern_type = a.pattern_type
100: and c.pattern_string = a.pattern_string);
101: begin
102:

Line 124: from qp_patterns c

120: for i in 1..g_pattern_pattern_id_final_tbl.count
121: loop
122: select min(c.pattern_id)
123: into l_min_pattern_id
124: from qp_patterns c
125: where c.pattern_type = g_pattern_pat_type_final_tbl(i)
126: and c.pattern_string = g_pattern_pat_string_final_tbl(i);
127:
128: if g_pattern_pat_type_final_tbl(i) = 'PP' then

Line 153: DELETE qp_patterns

149: end loop;
150: end if;
151:
152: FORALL i in 1 .. G_pattern_pattern_id_final_tbl.count
153: DELETE qp_patterns
154: where pattern_id = g_pattern_pattern_id_final_tbl(i);
155:
156: g_pattern_pattern_id_final_tbl.delete;
157: g_pattern_pat_type_final_tbl.delete;

Line 246: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_patterns';

242: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_pattern_phases';
243: EXECUTE IMMEDIATE l_stmt;
244: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_attribute_groups';
245: EXECUTE IMMEDIATE l_stmt;
246: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_patterns';
247: EXECUTE IMMEDIATE l_stmt;
248: END IF;
249:
250: fnd_file.put_line(FND_FILE.LOG, 'Deleted all records from 3 Pattern Master tables');

Line 1505: -- bulk insert patterns into qp_patterns table

1501: end if;
1502:
1503: END Move_data_from_tmp_to_final;
1504:
1505: -- bulk insert patterns into qp_patterns table
1506: PROCEDURE Populate_Patterns
1507: is
1508: BEGIN
1509:

Line 1519: INSERT INTO qp_patterns

1515: end if;
1516: */
1517:
1518: FORALL i in 1 .. G_pattern_pattern_id_final_tbl.count
1519: INSERT INTO qp_patterns
1520: (
1521: pattern_id,
1522: segment_id,
1523: pattern_type,

Line 1634: -- bulk insert patterns into qp_patterns table

1630: end if;
1631:
1632: end update_list_lines_cache_key;
1633:
1634: -- bulk insert patterns into qp_patterns table
1635: PROCEDURE Populate_Atgrps
1636: is
1637: BEGIN
1638:

Line 1758: select /*+ index(qp_pat QP_PATTERNS_N1) */ pattern_id

1754: end if;
1755: */
1756: begin
1757: l_pattern_to_be_created := 'N';
1758: select /*+ index(qp_pat QP_PATTERNS_N1) */ pattern_id
1759: into l_pattern_id
1760: from qp_patterns qp_pat
1761: where pattern_string = p_pat_string
1762: and pattern_type = p_pattern_type

Line 1760: from qp_patterns qp_pat

1756: begin
1757: l_pattern_to_be_created := 'N';
1758: select /*+ index(qp_pat QP_PATTERNS_N1) */ pattern_id
1759: into l_pattern_id
1760: from qp_patterns qp_pat
1761: where pattern_string = p_pat_string
1762: and pattern_type = p_pattern_type
1763: and rownum = 1;
1764: exception

Line 1766: select qp_patterns_s.nextval into l_pattern_id from dual;

1762: and pattern_type = p_pattern_type
1763: and rownum = 1;
1764: exception
1765: when no_data_found then
1766: select qp_patterns_s.nextval into l_pattern_id from dual;
1767: l_pattern_to_be_created := 'Y';
1768:
1769: when others then
1770: raise;

Line 1781: -- move the data from temp tables to final tables for qp_patterns, if new pattern to be created

1777: fnd_file.put_line(FND_FILE.LOG, 'l_pattern_to_be_created='||l_pattern_to_be_created);
1778: end if;
1779: */
1780:
1781: -- move the data from temp tables to final tables for qp_patterns, if new pattern to be created
1782: if l_pattern_to_be_created = 'Y' then
1783: for k in 1..g_pattern_grouping_no_tmp_tbl.count
1784: loop
1785: if (g_pattern_grouping_no_tmp_tbl(k) = -1 or g_pattern_grouping_no_tmp_tbl(k) = p_grp_no) then