APPS.GHR_GHRCPDFO_XMLP_PKG dependencies on GHR_CPDF_TEMP

Line 9: DELETE FROM GHR_CPDF_TEMP

5: IF FILENAME IS NOT NULL THEN
6: --DESNAME := FILENAME;
7: null;
8: END IF;
9: DELETE FROM GHR_CPDF_TEMP
10: WHERE REPORT_TYPE = 'GHRCPDFO'
11: AND SESSION_ID = USERENV('sessionid');
12: POPULATE_DATA;
13: RETURN (TRUE);

Line 171: INSERT INTO GHR_CPDF_TEMP

167: 3;
168: BEGIN
169: FOR R_CHILD IN C_CHILD(P_PARENT_ID,P_ORG_STR_VERSION_ID) LOOP
170: L_COUNT := L_COUNT + 1;
171: INSERT INTO GHR_CPDF_TEMP
172: (REPORT_TYPE
173: ,SESSION_ID
174: ,AWARD_AMOUNT
175: ,BENEFIT_AMOUNT

Line 222: INSERT INTO GHR_CPDF_TEMP

218: ,VER.DATE_TO);
219: L_COUNT := 1;
220: FOR R_PARENT IN C_PARENT LOOP
221: FOR R_DETAIL IN C_DETAIL(R_PARENT.ID) LOOP
222: INSERT INTO GHR_CPDF_TEMP
223: (REPORT_TYPE
224: ,SESSION_ID
225: ,AWARD_AMOUNT
226: ,BENEFIT_AMOUNT

Line 254: INSERT INTO GHR_CPDF_TEMP

250: ,2);
251: END LOOP;
252: ELSE
253: FOR R_REGULAR IN C_REGULAR LOOP
254: INSERT INTO GHR_CPDF_TEMP
255: (REPORT_TYPE
256: ,SESSION_ID
257: ,AWARD_AMOUNT
258: ,BENEFIT_AMOUNT