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_ARCHIVE_ENTITY_PVT dependencies on QP_RLTD_MODIFIERS

Line 29: FROM qp_rltd_modifiers

25:
26: CURSOR coupon_line_cur(a_list_line_id NUMBER)
27: IS
28: SELECT to_rltd_modifier_id
29: FROM qp_rltd_modifiers
30: WHERE to_rltd_modifier_id = a_list_line_id
31: AND rltd_modifier_grp_type = 'COUPON';
32:
33: BEGIN

Line 880: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)

876: where a.list_header_id =q.list_header_id
877: And a.list_type_code = 'PRL')
878: );
879:
880: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
881: IS
882: SELECT *
883: FROM qp_rltd_modifiers
884: WHERE from_rltd_modifier_id = a_list_line_id;

Line 883: FROM qp_rltd_modifiers

879:
880: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
881: IS
882: SELECT *
883: FROM qp_rltd_modifiers
884: WHERE from_rltd_modifier_id = a_list_line_id;
885:
886: BEGIN
887:

Line 1308: FROM qp_rltd_modifiers a

1304: WHERE a.list_line_id = q.list_line_id)';
1305: END IF; -- Product_context end
1306: ELSE
1307: l_select_stmt := l_select_stmt || 'AND q.list_line_id not in (SELECT DISTINCT a.to_rltd_modifier_id
1308: FROM qp_rltd_modifiers a
1309: WHERE a.to_rltd_modifier_id = q.list_line_id)';
1310: END IF; --all_lines end
1311:
1312: OPEN qp_list_lines_cv FOR l_select_stmt USING p_entity,p_start_date_active,p_end_date_active,p_created_by,p_creation_date;

Line 2337: /* Archive the qp_rltd_modifiers for the Price Break Parent list_lines chosen

2333: AND list_header_id = p_entity;
2334: ---bug#13045009
2335: CLOSE qp_list_lines_cv;
2336:
2337: /* Archive the qp_rltd_modifiers for the Price Break Parent list_lines chosen
2338: above which are stored in the mapping table */
2339:
2340: IF l_mapping_tbl.COUNT > 0 THEN
2341: FOR l_count IN 1..l_mapping_tbl.COUNT

Line 2347: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(l_mapping_tbl(l_count).list_line_id)

2343: IF l_mapping_tbl(l_count).list_line_type_code = 'PBH' OR
2344: l_mapping_tbl(l_count).list_line_type_code = 'OID' OR
2345: l_mapping_tbl(l_count).list_line_type_code = 'PRG' THEN
2346:
2347: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(l_mapping_tbl(l_count).list_line_id)
2348: LOOP
2349: INSERT INTO QP_ARCH_RLTD_MODIFIERS
2350: (
2351: creation_date,

Line 2381: l_qp_rltd_modifiers_rec.creation_date,

2377: ARCH_PURG_REQUEST_ID
2378: )
2379: VALUES
2380: (
2381: l_qp_rltd_modifiers_rec.creation_date,
2382: l_qp_rltd_modifiers_rec.created_by,
2383: l_qp_rltd_modifiers_rec.last_update_date,
2384: l_qp_rltd_modifiers_rec.last_updated_by,
2385: l_qp_rltd_modifiers_rec.last_update_login,

Line 2382: l_qp_rltd_modifiers_rec.created_by,

2378: )
2379: VALUES
2380: (
2381: l_qp_rltd_modifiers_rec.creation_date,
2382: l_qp_rltd_modifiers_rec.created_by,
2383: l_qp_rltd_modifiers_rec.last_update_date,
2384: l_qp_rltd_modifiers_rec.last_updated_by,
2385: l_qp_rltd_modifiers_rec.last_update_login,
2386: l_qp_rltd_modifiers_rec.context,

Line 2383: l_qp_rltd_modifiers_rec.last_update_date,

2379: VALUES
2380: (
2381: l_qp_rltd_modifiers_rec.creation_date,
2382: l_qp_rltd_modifiers_rec.created_by,
2383: l_qp_rltd_modifiers_rec.last_update_date,
2384: l_qp_rltd_modifiers_rec.last_updated_by,
2385: l_qp_rltd_modifiers_rec.last_update_login,
2386: l_qp_rltd_modifiers_rec.context,
2387: l_qp_rltd_modifiers_rec.attribute1,

Line 2384: l_qp_rltd_modifiers_rec.last_updated_by,

2380: (
2381: l_qp_rltd_modifiers_rec.creation_date,
2382: l_qp_rltd_modifiers_rec.created_by,
2383: l_qp_rltd_modifiers_rec.last_update_date,
2384: l_qp_rltd_modifiers_rec.last_updated_by,
2385: l_qp_rltd_modifiers_rec.last_update_login,
2386: l_qp_rltd_modifiers_rec.context,
2387: l_qp_rltd_modifiers_rec.attribute1,
2388: l_qp_rltd_modifiers_rec.attribute2,

Line 2385: l_qp_rltd_modifiers_rec.last_update_login,

2381: l_qp_rltd_modifiers_rec.creation_date,
2382: l_qp_rltd_modifiers_rec.created_by,
2383: l_qp_rltd_modifiers_rec.last_update_date,
2384: l_qp_rltd_modifiers_rec.last_updated_by,
2385: l_qp_rltd_modifiers_rec.last_update_login,
2386: l_qp_rltd_modifiers_rec.context,
2387: l_qp_rltd_modifiers_rec.attribute1,
2388: l_qp_rltd_modifiers_rec.attribute2,
2389: l_qp_rltd_modifiers_rec.attribute3,

Line 2386: l_qp_rltd_modifiers_rec.context,

2382: l_qp_rltd_modifiers_rec.created_by,
2383: l_qp_rltd_modifiers_rec.last_update_date,
2384: l_qp_rltd_modifiers_rec.last_updated_by,
2385: l_qp_rltd_modifiers_rec.last_update_login,
2386: l_qp_rltd_modifiers_rec.context,
2387: l_qp_rltd_modifiers_rec.attribute1,
2388: l_qp_rltd_modifiers_rec.attribute2,
2389: l_qp_rltd_modifiers_rec.attribute3,
2390: l_qp_rltd_modifiers_rec.attribute4,

Line 2387: l_qp_rltd_modifiers_rec.attribute1,

2383: l_qp_rltd_modifiers_rec.last_update_date,
2384: l_qp_rltd_modifiers_rec.last_updated_by,
2385: l_qp_rltd_modifiers_rec.last_update_login,
2386: l_qp_rltd_modifiers_rec.context,
2387: l_qp_rltd_modifiers_rec.attribute1,
2388: l_qp_rltd_modifiers_rec.attribute2,
2389: l_qp_rltd_modifiers_rec.attribute3,
2390: l_qp_rltd_modifiers_rec.attribute4,
2391: l_qp_rltd_modifiers_rec.attribute5,

Line 2388: l_qp_rltd_modifiers_rec.attribute2,

2384: l_qp_rltd_modifiers_rec.last_updated_by,
2385: l_qp_rltd_modifiers_rec.last_update_login,
2386: l_qp_rltd_modifiers_rec.context,
2387: l_qp_rltd_modifiers_rec.attribute1,
2388: l_qp_rltd_modifiers_rec.attribute2,
2389: l_qp_rltd_modifiers_rec.attribute3,
2390: l_qp_rltd_modifiers_rec.attribute4,
2391: l_qp_rltd_modifiers_rec.attribute5,
2392: l_qp_rltd_modifiers_rec.attribute6,

Line 2389: l_qp_rltd_modifiers_rec.attribute3,

2385: l_qp_rltd_modifiers_rec.last_update_login,
2386: l_qp_rltd_modifiers_rec.context,
2387: l_qp_rltd_modifiers_rec.attribute1,
2388: l_qp_rltd_modifiers_rec.attribute2,
2389: l_qp_rltd_modifiers_rec.attribute3,
2390: l_qp_rltd_modifiers_rec.attribute4,
2391: l_qp_rltd_modifiers_rec.attribute5,
2392: l_qp_rltd_modifiers_rec.attribute6,
2393: l_qp_rltd_modifiers_rec.attribute7,

Line 2390: l_qp_rltd_modifiers_rec.attribute4,

2386: l_qp_rltd_modifiers_rec.context,
2387: l_qp_rltd_modifiers_rec.attribute1,
2388: l_qp_rltd_modifiers_rec.attribute2,
2389: l_qp_rltd_modifiers_rec.attribute3,
2390: l_qp_rltd_modifiers_rec.attribute4,
2391: l_qp_rltd_modifiers_rec.attribute5,
2392: l_qp_rltd_modifiers_rec.attribute6,
2393: l_qp_rltd_modifiers_rec.attribute7,
2394: l_qp_rltd_modifiers_rec.attribute8,

Line 2391: l_qp_rltd_modifiers_rec.attribute5,

2387: l_qp_rltd_modifiers_rec.attribute1,
2388: l_qp_rltd_modifiers_rec.attribute2,
2389: l_qp_rltd_modifiers_rec.attribute3,
2390: l_qp_rltd_modifiers_rec.attribute4,
2391: l_qp_rltd_modifiers_rec.attribute5,
2392: l_qp_rltd_modifiers_rec.attribute6,
2393: l_qp_rltd_modifiers_rec.attribute7,
2394: l_qp_rltd_modifiers_rec.attribute8,
2395: l_qp_rltd_modifiers_rec.attribute9,

Line 2392: l_qp_rltd_modifiers_rec.attribute6,

2388: l_qp_rltd_modifiers_rec.attribute2,
2389: l_qp_rltd_modifiers_rec.attribute3,
2390: l_qp_rltd_modifiers_rec.attribute4,
2391: l_qp_rltd_modifiers_rec.attribute5,
2392: l_qp_rltd_modifiers_rec.attribute6,
2393: l_qp_rltd_modifiers_rec.attribute7,
2394: l_qp_rltd_modifiers_rec.attribute8,
2395: l_qp_rltd_modifiers_rec.attribute9,
2396: l_qp_rltd_modifiers_rec.attribute10,

Line 2393: l_qp_rltd_modifiers_rec.attribute7,

2389: l_qp_rltd_modifiers_rec.attribute3,
2390: l_qp_rltd_modifiers_rec.attribute4,
2391: l_qp_rltd_modifiers_rec.attribute5,
2392: l_qp_rltd_modifiers_rec.attribute6,
2393: l_qp_rltd_modifiers_rec.attribute7,
2394: l_qp_rltd_modifiers_rec.attribute8,
2395: l_qp_rltd_modifiers_rec.attribute9,
2396: l_qp_rltd_modifiers_rec.attribute10,
2397: l_qp_rltd_modifiers_rec.attribute11,

Line 2394: l_qp_rltd_modifiers_rec.attribute8,

2390: l_qp_rltd_modifiers_rec.attribute4,
2391: l_qp_rltd_modifiers_rec.attribute5,
2392: l_qp_rltd_modifiers_rec.attribute6,
2393: l_qp_rltd_modifiers_rec.attribute7,
2394: l_qp_rltd_modifiers_rec.attribute8,
2395: l_qp_rltd_modifiers_rec.attribute9,
2396: l_qp_rltd_modifiers_rec.attribute10,
2397: l_qp_rltd_modifiers_rec.attribute11,
2398: l_qp_rltd_modifiers_rec.attribute12,

Line 2395: l_qp_rltd_modifiers_rec.attribute9,

2391: l_qp_rltd_modifiers_rec.attribute5,
2392: l_qp_rltd_modifiers_rec.attribute6,
2393: l_qp_rltd_modifiers_rec.attribute7,
2394: l_qp_rltd_modifiers_rec.attribute8,
2395: l_qp_rltd_modifiers_rec.attribute9,
2396: l_qp_rltd_modifiers_rec.attribute10,
2397: l_qp_rltd_modifiers_rec.attribute11,
2398: l_qp_rltd_modifiers_rec.attribute12,
2399: l_qp_rltd_modifiers_rec.attribute13,

Line 2396: l_qp_rltd_modifiers_rec.attribute10,

2392: l_qp_rltd_modifiers_rec.attribute6,
2393: l_qp_rltd_modifiers_rec.attribute7,
2394: l_qp_rltd_modifiers_rec.attribute8,
2395: l_qp_rltd_modifiers_rec.attribute9,
2396: l_qp_rltd_modifiers_rec.attribute10,
2397: l_qp_rltd_modifiers_rec.attribute11,
2398: l_qp_rltd_modifiers_rec.attribute12,
2399: l_qp_rltd_modifiers_rec.attribute13,
2400: l_qp_rltd_modifiers_rec.attribute14,

Line 2397: l_qp_rltd_modifiers_rec.attribute11,

2393: l_qp_rltd_modifiers_rec.attribute7,
2394: l_qp_rltd_modifiers_rec.attribute8,
2395: l_qp_rltd_modifiers_rec.attribute9,
2396: l_qp_rltd_modifiers_rec.attribute10,
2397: l_qp_rltd_modifiers_rec.attribute11,
2398: l_qp_rltd_modifiers_rec.attribute12,
2399: l_qp_rltd_modifiers_rec.attribute13,
2400: l_qp_rltd_modifiers_rec.attribute14,
2401: l_qp_rltd_modifiers_rec.attribute15,

Line 2398: l_qp_rltd_modifiers_rec.attribute12,

2394: l_qp_rltd_modifiers_rec.attribute8,
2395: l_qp_rltd_modifiers_rec.attribute9,
2396: l_qp_rltd_modifiers_rec.attribute10,
2397: l_qp_rltd_modifiers_rec.attribute11,
2398: l_qp_rltd_modifiers_rec.attribute12,
2399: l_qp_rltd_modifiers_rec.attribute13,
2400: l_qp_rltd_modifiers_rec.attribute14,
2401: l_qp_rltd_modifiers_rec.attribute15,
2402: l_qp_rltd_modifiers_rec.rltd_modifier_id,

Line 2399: l_qp_rltd_modifiers_rec.attribute13,

2395: l_qp_rltd_modifiers_rec.attribute9,
2396: l_qp_rltd_modifiers_rec.attribute10,
2397: l_qp_rltd_modifiers_rec.attribute11,
2398: l_qp_rltd_modifiers_rec.attribute12,
2399: l_qp_rltd_modifiers_rec.attribute13,
2400: l_qp_rltd_modifiers_rec.attribute14,
2401: l_qp_rltd_modifiers_rec.attribute15,
2402: l_qp_rltd_modifiers_rec.rltd_modifier_id,
2403: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

Line 2400: l_qp_rltd_modifiers_rec.attribute14,

2396: l_qp_rltd_modifiers_rec.attribute10,
2397: l_qp_rltd_modifiers_rec.attribute11,
2398: l_qp_rltd_modifiers_rec.attribute12,
2399: l_qp_rltd_modifiers_rec.attribute13,
2400: l_qp_rltd_modifiers_rec.attribute14,
2401: l_qp_rltd_modifiers_rec.attribute15,
2402: l_qp_rltd_modifiers_rec.rltd_modifier_id,
2403: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2404: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,

Line 2401: l_qp_rltd_modifiers_rec.attribute15,

2397: l_qp_rltd_modifiers_rec.attribute11,
2398: l_qp_rltd_modifiers_rec.attribute12,
2399: l_qp_rltd_modifiers_rec.attribute13,
2400: l_qp_rltd_modifiers_rec.attribute14,
2401: l_qp_rltd_modifiers_rec.attribute15,
2402: l_qp_rltd_modifiers_rec.rltd_modifier_id,
2403: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2404: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2405: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,

Line 2402: l_qp_rltd_modifiers_rec.rltd_modifier_id,

2398: l_qp_rltd_modifiers_rec.attribute12,
2399: l_qp_rltd_modifiers_rec.attribute13,
2400: l_qp_rltd_modifiers_rec.attribute14,
2401: l_qp_rltd_modifiers_rec.attribute15,
2402: l_qp_rltd_modifiers_rec.rltd_modifier_id,
2403: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2404: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2405: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2406: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type,

Line 2403: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

2399: l_qp_rltd_modifiers_rec.attribute13,
2400: l_qp_rltd_modifiers_rec.attribute14,
2401: l_qp_rltd_modifiers_rec.attribute15,
2402: l_qp_rltd_modifiers_rec.rltd_modifier_id,
2403: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2404: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2405: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2406: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type,
2407: l_conc_request_id

Line 2404: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,

2400: l_qp_rltd_modifiers_rec.attribute14,
2401: l_qp_rltd_modifiers_rec.attribute15,
2402: l_qp_rltd_modifiers_rec.rltd_modifier_id,
2403: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2404: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2405: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2406: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type,
2407: l_conc_request_id
2408: );

Line 2405: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,

2401: l_qp_rltd_modifiers_rec.attribute15,
2402: l_qp_rltd_modifiers_rec.rltd_modifier_id,
2403: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2404: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2405: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2406: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type,
2407: l_conc_request_id
2408: );
2409: g_count_rldt:=g_count_rldt+sql%rowcount;

Line 2406: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type,

2402: l_qp_rltd_modifiers_rec.rltd_modifier_id,
2403: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
2404: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
2405: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
2406: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type,
2407: l_conc_request_id
2408: );
2409: g_count_rldt:=g_count_rldt+sql%rowcount;
2410:

Line 2411: DELETE_CHILD(l_qp_rltd_modifiers_rec.to_rltd_modifier_id,l_conc_request_id);

2407: l_conc_request_id
2408: );
2409: g_count_rldt:=g_count_rldt+sql%rowcount;
2410:
2411: DELETE_CHILD(l_qp_rltd_modifiers_rec.to_rltd_modifier_id,l_conc_request_id);
2412:
2413: DELETE FROM QP_RLTD_MODIFIERS
2414: WHERE rltd_modifier_id = l_qp_rltd_modifiers_rec.rltd_modifier_id;
2415: END LOOP; -- Loop through rltd modifiers records

Line 2413: DELETE FROM QP_RLTD_MODIFIERS

2409: g_count_rldt:=g_count_rldt+sql%rowcount;
2410:
2411: DELETE_CHILD(l_qp_rltd_modifiers_rec.to_rltd_modifier_id,l_conc_request_id);
2412:
2413: DELETE FROM QP_RLTD_MODIFIERS
2414: WHERE rltd_modifier_id = l_qp_rltd_modifiers_rec.rltd_modifier_id;
2415: END LOOP; -- Loop through rltd modifiers records
2416: END IF; --For lines that are Parent Price Break lines
2417: END LOOP; --Loop through l_mapping_tbl

Line 2414: WHERE rltd_modifier_id = l_qp_rltd_modifiers_rec.rltd_modifier_id;

2410:
2411: DELETE_CHILD(l_qp_rltd_modifiers_rec.to_rltd_modifier_id,l_conc_request_id);
2412:
2413: DELETE FROM QP_RLTD_MODIFIERS
2414: WHERE rltd_modifier_id = l_qp_rltd_modifiers_rec.rltd_modifier_id;
2415: END LOOP; -- Loop through rltd modifiers records
2416: END IF; --For lines that are Parent Price Break lines
2417: END LOOP; --Loop through l_mapping_tbl
2418: END IF; --If l_mapping_tbl has any records