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 239: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_attribute_groups';

235: IF (FND_INSTALLATION.GET_APP_INFO('QP', l_status, l_industry, l_qp_schema))
236: THEN
237: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_pattern_phases';
238: EXECUTE IMMEDIATE l_stmt;
239: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_attribute_groups';
240: EXECUTE IMMEDIATE l_stmt;
241: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.qp_patterns';
242: EXECUTE IMMEDIATE l_stmt;
243: END IF;

Line 248: delete from qp_attribute_groups

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

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

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

Line 323: delete from qp_attribute_groups

319:
320: else
321: -- refresh only for the passed list_header_id
322:
323: delete from qp_attribute_groups
324: where list_header_id = p_list_header_id
325: and list_line_id <> -1;
326:
327: update qp_list_lines

Line 356: delete from qp_attribute_groups

352: and list_line_id between p_low_list_line_id and p_high_list_line_id;
353: else
354: -- refresh only for the passed list_header_id
355:
356: delete from qp_attribute_groups
357: where list_header_id = p_list_header_id
358: and list_line_id between p_low_list_line_id and p_high_list_line_id;
359:
360: update /*+ index_asc(lines QP_LIST_LINES_PK) */ qp_list_lines lines

Line 1144: -- insert into qp_attribute_groups from final tables

1140:
1141: -- move data for last pair of header and line id
1142: Move_data_from_tmp_to_final(p_pattern_type);
1143:
1144: -- insert into qp_attribute_groups from final tables
1145: populate_atgrps;
1146:
1147: -- for line pattern, qp_list_lines.cache_key need to be populated as well
1148: if p_pattern_type = 'LP' then

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

1401: elsif p_pattern_type = 'HP' then
1402: Populate_Pattern_Phases(g_list_header_id_tmp_tbl(grp_no_index), null, l_pattern_id);
1403: end if;
1404:
1405: -- move the data from tmp tables to final tables for qp_attribute_groups
1406: /*
1407: if g_call_from_setup = 'Y' then
1408: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
1409: else

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

1404:
1405: -- move the data from tmp tables to final tables for qp_attribute_groups
1406: /*
1407: if g_call_from_setup = 'Y' then
1408: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
1409: else
1410: fnd_file.put_line(FND_FILE.LOG, 'move the data from tmp tables to final tables for qp_attribute_groups');
1411: end if;
1412: */

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

1406: /*
1407: if g_call_from_setup = 'Y' then
1408: oe_debug_pub.add('move the data from tmp tables to final tables for qp_attribute_groups');
1409: else
1410: fnd_file.put_line(FND_FILE.LOG, 'move the data from tmp tables to final tables for qp_attribute_groups');
1411: end if;
1412: */
1413:
1414: l_atgrp_final_index := g_list_header_id_final_tbl.count + 1;

Line 1634: INSERT INTO qp_attribute_groups

1630: is
1631: BEGIN
1632:
1633: FORALL i in 1 .. g_list_header_id_final_tbl.count
1634: INSERT INTO qp_attribute_groups
1635: (list_header_id,
1636: list_line_id,
1637: active_flag,
1638: list_type_code,

Line 2083: -- delete from qp_attribute_groups first

2079:
2080: -- when called while set up of modifier/price list
2081: if p_setup_action <> 'UD' then
2082: -- No need to delete pattern in case of update in denormalized columns in header
2083: -- delete from qp_attribute_groups first
2084: if p_qualifier_group is null then
2085: delete from qp_attribute_groups
2086: where list_header_id = p_list_header_id
2087: and list_line_id = -1;

Line 2085: delete from qp_attribute_groups

2081: if p_setup_action <> 'UD' then
2082: -- No need to delete pattern in case of update in denormalized columns in header
2083: -- delete from qp_attribute_groups first
2084: if p_qualifier_group is null then
2085: delete from qp_attribute_groups
2086: where list_header_id = p_list_header_id
2087: and list_line_id = -1;
2088: elsif p_qualifier_group is not null then
2089: delete from qp_attribute_groups

Line 2089: delete from qp_attribute_groups

2085: delete from qp_attribute_groups
2086: where list_header_id = p_list_header_id
2087: and list_line_id = -1;
2088: elsif p_qualifier_group is not null then
2089: delete from qp_attribute_groups
2090: where list_header_id = p_list_header_id
2091: and list_line_id = -1
2092: and GROUPING_NO in (-1, p_qualifier_group);
2093: end if;

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

2095: -- update the segment_id columns for qualifiers
2096: Update_Qual_Segment_id(p_list_header_id, p_qualifier_group, -1, -1);
2097: end if;
2098:
2099: -- populate the records in qp_attribute_groups afresh for p_list_header_id, list_line_id -1
2100: -- and p_qualifier_group
2101: if p_setup_action = 'I' then
2102: -- insert case
2103: generate_hp_atgrps(p_list_header_id, p_qualifier_group);

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

2149: end;
2150:
2151: if l_qual_exists = 'N' then
2152: -- no qualifiers exist other than -1 qualifier_grouping_no
2153: -- this may insert in qp_attribute_groups with HDR_QUAL_GROUPING_NO = -1, if any
2154: -- qualifiers exist with qualifier_grouping_no = -1
2155: generate_hp_atgrps(p_list_header_id, p_qualifier_group);
2156: end if; -- l_qual_exists = 'N'
2157: end if; -- l_qual_exists = 'Y'

Line 2177: update qp_attribute_groups

2173: from qp_list_headers_b
2174: where list_header_id = p_list_header_id;
2175:
2176: -- update header pattern records
2177: update qp_attribute_groups
2178: set ACTIVE_FLAG = l_ACTIVE_FLAG,
2179: LIST_TYPE_CODE = l_LIST_TYPE_CODE,
2180: CURRENCY_CODE = l_CURRENCY_CODE,
2181: ASK_FOR_FLAG = l_ASK_FOR_FLAG,

Line 2188: update qp_attribute_groups

2184: where list_header_id = p_list_header_id
2185: and list_line_id = -1;
2186:
2187: -- update line pattern records
2188: update qp_attribute_groups
2189: set ACTIVE_FLAG = l_ACTIVE_FLAG,
2190: LIST_TYPE_CODE = l_LIST_TYPE_CODE,
2191: CURRENCY_CODE = l_CURRENCY_CODE,
2192: ASK_FOR_FLAG = l_ASK_FOR_FLAG,

Line 2251: -- delete from qp_attribute_groups first

2247: end if;
2248:
2249: -- when called while set up of modifier
2250: if p_setup_action <> 'UD' then
2251: -- delete from qp_attribute_groups first
2252: if p_qualifier_group is null then
2253: delete from qp_attribute_groups
2254: where list_header_id = p_list_header_id
2255: and list_line_id = p_list_line_id;

Line 2253: delete from qp_attribute_groups

2249: -- when called while set up of modifier
2250: if p_setup_action <> 'UD' then
2251: -- delete from qp_attribute_groups first
2252: if p_qualifier_group is null then
2253: delete from qp_attribute_groups
2254: where list_header_id = p_list_header_id
2255: and list_line_id = p_list_line_id;
2256: elsif p_qualifier_group is not null then
2257: delete from qp_attribute_groups

Line 2257: delete from qp_attribute_groups

2253: delete from qp_attribute_groups
2254: where list_header_id = p_list_header_id
2255: and list_line_id = p_list_line_id;
2256: elsif p_qualifier_group is not null then
2257: delete from qp_attribute_groups
2258: where list_header_id = p_list_header_id
2259: and list_line_id = p_list_line_id
2260: and GROUPING_NO in (-1, p_qualifier_group);
2261: end if;

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

2266: -- update the product_segment_id and pricing_segment_id columns in qp_pricing_attributes
2267: Update_Prod_Pric_Segment_id(p_list_header_id, p_list_line_id, p_list_line_id );
2268: end if;
2269:
2270: -- populate the records in qp_attribute_groups afresh for p_list_header_id, p_list_line_id
2271: -- and p_qualifier_group
2272: if p_setup_action = 'I' then
2273: -- insert case
2274: generate_lp_atgrps(p_list_header_id, p_qualifier_group,

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

2323: end;
2324:
2325: if l_qual_exists = 'N' then
2326: -- no qualifiers exist other than -1 qualifier_grouping_no
2327: -- this may insert in qp_attribute_groups with LINE_QUAL_GROUPING_NO = -1, if any
2328: -- qualifiers exist with qualifier_grouping_no = -1
2329: update qp_list_lines
2330: set pattern_id = null,
2331: hash_key = null,

Line 2348: update qp_attribute_groups

2344: from qp_list_lines
2345: where list_line_id = p_list_line_id;
2346:
2347: -- update line pattern records
2348: update qp_attribute_groups
2349: set LIMIT_EXISTS = l_line_LIMIT_EXISTS
2350: where list_header_id = p_list_header_id
2351: and list_line_id = p_list_line_id;
2352:

Line 2374: from qp_attribute_groups

2370: -- line qualifier delete case
2371: begin
2372: select 'Y'
2373: into l_qual_exists
2374: from qp_attribute_groups
2375: where list_header_id = p_list_header_id
2376: and list_line_id = p_list_line_id
2377: and rownum = 1;
2378: exception

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

2379: when no_data_found then
2380: l_qual_exists := 'N';
2381: end;
2382: else
2383: -- line qualifier insert/update case, assume there will be record in qp_attribute_groups
2384: l_qual_exists := 'Y';
2385: end if;
2386:
2387: if p_setup_action = 'I' then