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_MAINTAIN_DENORMALIZED_DATA dependencies on QP_LIST_HEADER_PHASES

Line 768: cursor l_qp_list_header_phases_qual is

764: -- in the group
765: l_search_ind_1_set number := -1;
766:
767: --nhase/hw 07/29/02
768: cursor l_qp_list_header_phases_qual is
769: select list_header_id, pricing_phase_id from qp_list_header_phases
770: where list_header_id between
771: --for bug 5121471
772: p_List_Header_Id and p_List_Header_Id_high;

Line 769: select list_header_id, pricing_phase_id from qp_list_header_phases

765: l_search_ind_1_set number := -1;
766:
767: --nhase/hw 07/29/02
768: cursor l_qp_list_header_phases_qual is
769: select list_header_id, pricing_phase_id from qp_list_header_phases
770: where list_header_id between
771: --for bug 5121471
772: p_List_Header_Id and p_List_Header_Id_high;
773: cursor l_line_qual_exc (p_pricing_phase_id number,

Line 1129: Begin code to maintain qp_list_header_phases for modifierlist types only

1125:
1126: END IF; --IF update_type IN (ALL, QUAL_IND), (see matching (Qual Ind))
1127:
1128: /************************************************************************
1129: Begin code to maintain qp_list_header_phases for modifierlist types only
1130: ************************************************************************/
1131: IF P_UPDATE_TYPE IN ('BATCH','HEADER_PHASE','ALL')
1132: THEN
1133:

Line 1150: delete from qp_list_header_phases

1146: END IF;
1147:
1148: FOR l_rec in list_headers_cur(l_list_header_id_low,l_list_header_id_high)
1149: LOOP
1150: delete from qp_list_header_phases
1151: where list_header_id = l_rec.list_header_id;
1152:
1153: insert into qp_list_header_phases (list_header_id,pricing_phase_id) /* Added column names for 2236671 */
1154: (select distinct list_header_id, pricing_phase_id

Line 1153: insert into qp_list_header_phases (list_header_id,pricing_phase_id) /* Added column names for 2236671 */

1149: LOOP
1150: delete from qp_list_header_phases
1151: where list_header_id = l_rec.list_header_id;
1152:
1153: insert into qp_list_header_phases (list_header_id,pricing_phase_id) /* Added column names for 2236671 */
1154: (select distinct list_header_id, pricing_phase_id
1155: from qp_list_lines
1156: where pricing_phase_id > 1
1157: and qualification_ind in (2,6,8,10,12,14,22,28,30)

Line 1168: End code to maintain qp_list_header_phases -rchellam. Moved this code

1164: put_line('Completed Maintain List Header Phases');
1165: END IF;
1166:
1167: /************************************************************************
1168: End code to maintain qp_list_header_phases -rchellam. Moved this code
1169: to below the qualification_ind code (05/29/01) -rchellam
1170: ************************************************************************/
1171:
1172: ELSE

Line 1455: update qp_list_header_phases set qualifier_flag = null;

1451:
1452: -- This procedure update the qualifier flag to Y if all the lines of the header have line level qualifiers.
1453: -- set the flag to null for all records
1454: IF P_UPDATE_TYPE IN ('ALL','DENORMALIZED','QUAL_IND','HEADER PHASE','UPD_QUAL', 'BATCH') THEN --BATCH added for bug 5121471
1455: update qp_list_header_phases set qualifier_flag = null;
1456: for i in l_qp_list_header_phases_qual
1457: loop
1458: l_list_line_id := Null;
1459: open l_line_qual_exc(i.pricing_phase_id, i.list_header_id);

Line 1456: for i in l_qp_list_header_phases_qual

1452: -- This procedure update the qualifier flag to Y if all the lines of the header have line level qualifiers.
1453: -- set the flag to null for all records
1454: IF P_UPDATE_TYPE IN ('ALL','DENORMALIZED','QUAL_IND','HEADER PHASE','UPD_QUAL', 'BATCH') THEN --BATCH added for bug 5121471
1455: update qp_list_header_phases set qualifier_flag = null;
1456: for i in l_qp_list_header_phases_qual
1457: loop
1458: l_list_line_id := Null;
1459: open l_line_qual_exc(i.pricing_phase_id, i.list_header_id);
1460: fetch l_line_qual_exc into l_list_line_id;

Line 1463: update qp_list_header_phases

1459: open l_line_qual_exc(i.pricing_phase_id, i.list_header_id);
1460: fetch l_line_qual_exc into l_list_line_id;
1461: close l_line_qual_exc;
1462: if l_list_line_id is null then
1463: update qp_list_header_phases
1464: set qualifier_flag = 'Y'
1465: where list_header_id = i.list_header_id
1466: and pricing_phase_id = i.pricing_phase_id;
1467: end if;