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

Line 133: update qp_attribute_groups

129: update /*+ index(lines QP_LIST_LINES_N9) */ qp_list_lines lines
130: set pattern_id = l_min_pattern_id
131: where pattern_id = g_pattern_pattern_id_final_tbl(i);
132: else
133: update qp_attribute_groups
134: set pattern_id = l_min_pattern_id
135: where pattern_id = g_pattern_pattern_id_final_tbl(i);
136: end if;
137:

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

240: IF (FND_INSTALLATION.GET_APP_INFO('QP', l_status, l_industry, l_qp_schema))
241: THEN
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;

Line 253: delete from qp_attribute_groups

249:
250: fnd_file.put_line(FND_FILE.LOG, 'Deleted all records from 3 Pattern Master tables');
251: else
252: -- refresh only for the passed list_header_id
253: delete from qp_attribute_groups
254: where list_header_id = p_list_header_id
255: and list_line_id = -1;
256: fnd_file.put_line(FND_FILE.LOG, 'Deleted records from qp_attribute_groups for HP for list_header_id:'||p_list_header_id);
257:

Line 256: fnd_file.put_line(FND_FILE.LOG, 'Deleted records from qp_attribute_groups for HP for list_header_id:'||p_list_header_id);

252: -- refresh only for the passed list_header_id
253: delete from qp_attribute_groups
254: where list_header_id = p_list_header_id
255: and list_line_id = -1;
256: fnd_file.put_line(FND_FILE.LOG, 'Deleted records from qp_attribute_groups for HP for list_header_id:'||p_list_header_id);
257:
258: end if;
259: Update_Qual_Segment_id(p_list_header_id, null, -1, -1);
260: generate_hp_atgrps(p_list_header_id, null);

Line 329: delete from qp_attribute_groups

325:
326: else
327: -- refresh only for the passed list_header_id
328:
329: delete from qp_attribute_groups
330: where list_header_id = p_list_header_id
331: and list_line_id <> -1;
332:
333: update qp_list_lines

Line 362: delete from qp_attribute_groups

358: and list_line_id between p_low_list_line_id and p_high_list_line_id;
359: else
360: -- refresh only for the passed list_header_id
361:
362: delete from qp_attribute_groups
363: where list_header_id = p_list_header_id
364: and list_line_id between p_low_list_line_id and p_high_list_line_id;
365:
366: update /*+ index_asc(lines QP_LIST_LINES_PK) */ qp_list_lines lines

Line 1150: -- insert into qp_attribute_groups from final tables

1146:
1147: -- move data for last pair of header and line id
1148: Move_data_from_tmp_to_final(p_pattern_type);
1149:
1150: -- insert into qp_attribute_groups from final tables
1151: populate_atgrps;
1152:
1153: -- for line pattern, qp_list_lines.cache_key need to be populated as well
1154: if p_pattern_type = 'LP' then

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

1407: elsif p_pattern_type = 'HP' then
1408: Populate_Pattern_Phases(g_list_header_id_tmp_tbl(grp_no_index), null, l_pattern_id);
1409: end if;
1410:
1411: -- move the data from tmp tables to final tables for qp_attribute_groups
1412: /*
1413: if g_call_from_setup = 'Y' then
1414: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
1415: else

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

1410:
1411: -- move the data from tmp tables to final tables for qp_attribute_groups
1412: /*
1413: if g_call_from_setup = 'Y' then
1414: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
1415: else
1416: fnd_file.put_line(FND_FILE.LOG, 'move the data from tmp tables to final tables for qp_attribute_groups');
1417: end if;
1418: */

Line 1416: fnd_file.put_line(FND_FILE.LOG, 'move the data from tmp tables to final tables for qp_attribute_groups');

1412: /*
1413: if g_call_from_setup = 'Y' then
1414: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
1415: else
1416: fnd_file.put_line(FND_FILE.LOG, 'move the data from tmp tables to final tables for qp_attribute_groups');
1417: end if;
1418: */
1419:
1420: l_atgrp_final_index := g_list_header_id_final_tbl.count + 1;

Line 1640: INSERT INTO qp_attribute_groups

1636: is
1637: BEGIN
1638:
1639: FORALL i in 1 .. g_list_header_id_final_tbl.count
1640: INSERT INTO qp_attribute_groups
1641: (list_header_id,
1642: list_line_id,
1643: active_flag,
1644: list_type_code,

Line 2089: -- delete from qp_attribute_groups first

2085:
2086: -- when called while set up of modifier/price list
2087: if p_setup_action <> 'UD' then
2088: -- No need to delete pattern in case of update in denormalized columns in header
2089: -- delete from qp_attribute_groups first
2090: if p_qualifier_group is null then
2091: delete from qp_attribute_groups
2092: where list_header_id = p_list_header_id
2093: and list_line_id = -1;

Line 2091: delete from qp_attribute_groups

2087: if p_setup_action <> 'UD' then
2088: -- No need to delete pattern in case of update in denormalized columns in header
2089: -- delete from qp_attribute_groups first
2090: if p_qualifier_group is null then
2091: delete from qp_attribute_groups
2092: where list_header_id = p_list_header_id
2093: and list_line_id = -1;
2094: elsif p_qualifier_group is not null then
2095: delete from qp_attribute_groups

Line 2095: delete from qp_attribute_groups

2091: delete from qp_attribute_groups
2092: where list_header_id = p_list_header_id
2093: and list_line_id = -1;
2094: elsif p_qualifier_group is not null then
2095: delete from qp_attribute_groups
2096: where list_header_id = p_list_header_id
2097: and list_line_id = -1
2098: and GROUPING_NO in (-1, p_qualifier_group);
2099: end if;

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

2101: -- update the segment_id columns for qualifiers
2102: Update_Qual_Segment_id(p_list_header_id, p_qualifier_group, -1, -1);
2103: end if;
2104:
2105: -- populate the records in qp_attribute_groups afresh for p_list_header_id, list_line_id -1
2106: -- and p_qualifier_group
2107: if p_setup_action = 'I' then
2108: -- insert case
2109: generate_hp_atgrps(p_list_header_id, p_qualifier_group);

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

2155: end;
2156:
2157: if l_qual_exists = 'N' then
2158: -- no qualifiers exist other than -1 qualifier_grouping_no
2159: -- this may insert in qp_attribute_groups with HDR_QUAL_GROUPING_NO = -1, if any
2160: -- qualifiers exist with qualifier_grouping_no = -1
2161: generate_hp_atgrps(p_list_header_id, p_qualifier_group);
2162: end if; -- l_qual_exists = 'N'
2163: end if; -- l_qual_exists = 'Y'

Line 2183: update qp_attribute_groups

2179: from qp_list_headers_b
2180: where list_header_id = p_list_header_id;
2181:
2182: -- update header pattern records
2183: update qp_attribute_groups
2184: set ACTIVE_FLAG = l_ACTIVE_FLAG,
2185: LIST_TYPE_CODE = l_LIST_TYPE_CODE,
2186: CURRENCY_CODE = l_CURRENCY_CODE,
2187: ASK_FOR_FLAG = l_ASK_FOR_FLAG,

Line 2194: update qp_attribute_groups

2190: where list_header_id = p_list_header_id
2191: and list_line_id = -1;
2192:
2193: -- update line pattern records
2194: update qp_attribute_groups
2195: set ACTIVE_FLAG = l_ACTIVE_FLAG,
2196: LIST_TYPE_CODE = l_LIST_TYPE_CODE,
2197: CURRENCY_CODE = l_CURRENCY_CODE,
2198: ASK_FOR_FLAG = l_ASK_FOR_FLAG,

Line 2257: -- delete from qp_attribute_groups first

2253: end if;
2254:
2255: -- when called while set up of modifier
2256: if p_setup_action <> 'UD' then
2257: -- delete from qp_attribute_groups first
2258: if p_qualifier_group is null then
2259: delete from qp_attribute_groups
2260: where list_header_id = p_list_header_id
2261: and list_line_id = p_list_line_id;

Line 2259: delete from qp_attribute_groups

2255: -- when called while set up of modifier
2256: if p_setup_action <> 'UD' then
2257: -- delete from qp_attribute_groups first
2258: if p_qualifier_group is null then
2259: delete from qp_attribute_groups
2260: where list_header_id = p_list_header_id
2261: and list_line_id = p_list_line_id;
2262: elsif p_qualifier_group is not null then
2263: delete from qp_attribute_groups

Line 2263: delete from qp_attribute_groups

2259: delete from qp_attribute_groups
2260: where list_header_id = p_list_header_id
2261: and list_line_id = p_list_line_id;
2262: elsif p_qualifier_group is not null then
2263: delete from qp_attribute_groups
2264: where list_header_id = p_list_header_id
2265: and list_line_id = p_list_line_id
2266: and GROUPING_NO in (-1, p_qualifier_group);
2267: end if;

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

2272: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes
2273: Update_Prod_Pric_Segment_id(p_list_header_id, p_list_line_id, p_list_line_id );
2274: end if;
2275:
2276: -- populate the records in qp_attribute_groups afresh for p_list_header_id, p_list_line_id
2277: -- and p_qualifier_group
2278: if p_setup_action = 'I' then
2279: -- insert case
2280: generate_lp_atgrps(p_list_header_id, p_qualifier_group,

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

2329: end;
2330:
2331: if l_qual_exists = 'N' then
2332: -- no qualifiers exist other than -1 qualifier_grouping_no
2333: -- this may insert in qp_attribute_groups with LINE_QUAL_GROUPING_NO = -1, if any
2334: -- qualifiers exist with qualifier_grouping_no = -1
2335: update qp_list_lines
2336: set pattern_id = null,
2337: hash_key = null,

Line 2354: update qp_attribute_groups

2350: from qp_list_lines
2351: where list_line_id = p_list_line_id;
2352:
2353: -- update line pattern records
2354: update qp_attribute_groups
2355: set LIMIT_EXISTS = l_line_LIMIT_EXISTS
2356: where list_header_id = p_list_header_id
2357: and list_line_id = p_list_line_id;
2358:

Line 2380: from qp_attribute_groups

2376: -- line qualifier delete case
2377: begin
2378: select 'Y'
2379: into l_qual_exists
2380: from qp_attribute_groups
2381: where list_header_id = p_list_header_id
2382: and list_line_id = p_list_line_id
2383: and rownum = 1;
2384: exception

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

2385: when no_data_found then
2386: l_qual_exists := 'N';
2387: end;
2388: else
2389: -- line qualifier insert/update case, assume there will be record in qp_attribute_groups
2390: l_qual_exists := 'Y';
2391: end if;
2392:
2393: if p_setup_action = 'I' then