APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_WK_TRANS

Line 233: /* Populate DDR_R_WK_TRANS table */

229: and NYR.CLNDR_CD(+) = BDAY.CLNDR_CD
230: and NYR.DAY_CD(+) = add_day(BDAY.DAY_CD,364)
231: ;
232:
233: /* Populate DDR_R_WK_TRANS table */
234: delete from DDR_R_WK_TRANS
235: where (WK_CD,CLNDR_CD) in (
236: select WK_CD,CLNDR_CD
237: from DDR_TIME_BSNS_WK_V

Line 234: delete from DDR_R_WK_TRANS

230: and NYR.DAY_CD(+) = add_day(BDAY.DAY_CD,364)
231: ;
232:
233: /* Populate DDR_R_WK_TRANS table */
234: delete from DDR_R_WK_TRANS
235: where (WK_CD,CLNDR_CD) in (
236: select WK_CD,CLNDR_CD
237: from DDR_TIME_BSNS_WK_V
238: where ORG_CD = p_org_cd

Line 242: insert into DDR_R_WK_TRANS (

238: where ORG_CD = p_org_cd
239: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
240: );
241:
242: insert into DDR_R_WK_TRANS (
243: MFG_ORG_CD,
244: WK_TRANS_ID,
245: WK_ID,
246: WK_CD,

Line 281: DDR_R_WK_TRANS_SEQ.NEXTVAL,

277: LAST_UPDATE_LOGIN
278: )
279: select
280: WK.MFG_ORG_CD,
281: DDR_R_WK_TRANS_SEQ.NEXTVAL,
282: WK.WK_ID,
283: WK.WK_CD,
284: WK.CLNDR_CD,
285: 'BSNS',

Line 1420: /* Populate DDR_R_WK_TRANS table */

1416: END IF;
1417: V_START_YEAR:= V_START_YEAR+1;
1418: END LOOP;
1419:
1420: /* Populate DDR_R_WK_TRANS table */
1421: DELETE
1422: FROM DDR_R_WK_TRANS
1423: WHERE (WK_CD,CLNDR_CD) IN
1424: (SELECT WK_CD,

Line 1422: FROM DDR_R_WK_TRANS

1418: END LOOP;
1419:
1420: /* Populate DDR_R_WK_TRANS table */
1421: DELETE
1422: FROM DDR_R_WK_TRANS
1423: WHERE (WK_CD,CLNDR_CD) IN
1424: (SELECT WK_CD,
1425: CLNDR_CD
1426: FROM DDR_TIME_CLNDR_WK_V

Line 1430: INTO DDR_R_WK_TRANS

1426: FROM DDR_TIME_CLNDR_WK_V
1427: WHERE SUBSTR(WK_CD,1,4) BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1428: );
1429: INSERT
1430: INTO DDR_R_WK_TRANS
1431: (
1432: MFG_ORG_CD,
1433: WK_TRANS_ID,
1434: WK_ID,

Line 1469: DDR_R_WK_TRANS_SEQ.NEXTVAL,

1465: LAST_UPDATE_DATE,
1466: LAST_UPDATE_LOGIN
1467: )
1468: SELECT WK.ORG_CD,
1469: DDR_R_WK_TRANS_SEQ.NEXTVAL,
1470: WK.CLNDR_WK_ID,
1471: WK.WK_CD,
1472: WK.CLNDR_CD,
1473: WK.CLNDR_TYP,