APPS.MRP_MRPRPPIT_XMLP_PKG dependencies on MRP_FORM_QUERY_S

Line 93: MRP_FORM_QUERY_S.NEXTVAL

89: WHERE LOOKUP_TYPE = 'MRP_DISPLAY_PERIODS'
90: AND LOOKUP_CODE = P_PERIODS;
91: P_PERIODS_ACTUAL := PERIODS;
92: SELECT
93: MRP_FORM_QUERY_S.NEXTVAL
94: INTO Q_ID
95: FROM
96: DUAL;
97: P_QUERY_ID := Q_ID;

Line 141: MRP_FORM_QUERY_S.NEXTVAL

137: FETCH C
138: INTO PLAN_NAME,SCHED_NAME,ORG_ID;
139: EXIT WHEN (C%NOTFOUND);
140: SELECT
141: MRP_FORM_QUERY_S.NEXTVAL
142: INTO Q_ID
143: FROM
144: DUAL;
145: MRP_WEEKS_MONTHS(Q_ID

Line 158: 'UPDATE mrp_form_query SET query_id = ' || TO_CHAR(P_QUERY_ID) || ' WHERE query_id = ' || TO_CHAR(Q_ID);

154: ,SCHED_NAME
155: ,P_COST_TYPE
156: ,DEF_COST_TYPE_ID);
157: EXECUTE IMMEDIATE
158: 'UPDATE mrp_form_query SET query_id = ' || TO_CHAR(P_QUERY_ID) || ' WHERE query_id = ' || TO_CHAR(Q_ID);
159: END LOOP;
160: CLOSE C;
161: SELECT
162: NAME,