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.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_DAY_TRANS

Line 123: /* Populate DDR_R_DAY_TRANS table */

119: )
120: AS
121: BEGIN
122:
123: /* Populate DDR_R_DAY_TRANS table */
124: delete from DDR_R_DAY_TRANS
125: where (DAY_CD,CLNDR_CD) in (
126: select DAY_CD,CLNDR_CD
127: from DDR_TIME_BSNS_DAY_V

Line 124: delete from DDR_R_DAY_TRANS

120: AS
121: BEGIN
122:
123: /* Populate DDR_R_DAY_TRANS table */
124: delete from DDR_R_DAY_TRANS
125: where (DAY_CD,CLNDR_CD) in (
126: select DAY_CD,CLNDR_CD
127: from DDR_TIME_BSNS_DAY_V
128: where ORG_CD = p_org_cd

Line 132: insert into DDR_R_DAY_TRANS (

128: where ORG_CD = p_org_cd
129: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
130: );
131:
132: insert into DDR_R_DAY_TRANS (
133: MFG_ORG_CD,
134: DAY_TRANS_ID,
135: DAY_CD,
136: CLNDR_CD,

Line 162: DDR_R_DAY_TRANS_SEQ.NEXTVAL,

158: LAST_UPDATE_LOGIN
159: )
160: select
161: BDAY.MFG_ORG_CD,
162: DDR_R_DAY_TRANS_SEQ.NEXTVAL,
163: BDAY.DAY_CD,
164: BDAY.CLNDR_CD,
165: 'BSNS',
166: PDAY.DAY_CD,

Line 855: /* Populate DDR_R_DAY_TRANS table */

851: as
852: v_yr_timespn number;
853: v_start_year number;
854: BEGIN
855: /* Populate DDR_R_DAY_TRANS table */
856: v_start_year:= p_start_year;
857: DELETE
858: FROM DDR_R_DAY_TRANS
859: WHERE (DAY_CD,CLNDR_CD) IN

Line 858: FROM DDR_R_DAY_TRANS

854: BEGIN
855: /* Populate DDR_R_DAY_TRANS table */
856: v_start_year:= p_start_year;
857: DELETE
858: FROM DDR_R_DAY_TRANS
859: WHERE (DAY_CD,CLNDR_CD) IN
860: (SELECT DAY_CD,
861: CLNDR_CD
862: FROM DDR_TIME_CLNDR_DAY_V

Line 875: INTO DDR_R_DAY_TRANS

871:
872: IF (mod(v_start_year,4)=0 ) THEN
873:
874: INSERT
875: INTO DDR_R_DAY_TRANS
876: (
877: MFG_ORG_CD,
878: DAY_TRANS_ID,
879: DAY_CD,

Line 905: DDR_R_DAY_TRANS_SEQ.NEXTVAL,

901: LAST_UPDATE_DATE,
902: LAST_UPDATE_LOGIN
903: )
904: SELECT BDAY.ORG_CD,
905: DDR_R_DAY_TRANS_SEQ.NEXTVAL,
906: BDAY.DAY_CD,
907: BDAY.CLNDR_CD,
908: BDAY.CLNDR_TYP,
909: PDAY.DAY_CD,

Line 965: INTO DDR_R_DAY_TRANS

961: and NYR.DAY_CD(+) = ADD_DAY(BDAY.DAY_CD,V_YR_TIMESPN)
962: and BDAY.DAY_CD < V_START_YEAR||'0229';
963:
964: INSERT
965: INTO DDR_R_DAY_TRANS
966: (
967: MFG_ORG_CD,
968: DAY_TRANS_ID,
969: DAY_CD,

Line 995: DDR_R_DAY_TRANS_SEQ.NEXTVAL,

991: LAST_UPDATE_DATE,
992: LAST_UPDATE_LOGIN
993: )
994: SELECT BDAY.ORG_CD,
995: DDR_R_DAY_TRANS_SEQ.NEXTVAL,
996: BDAY.DAY_CD,
997: BDAY.CLNDR_CD,
998: BDAY.CLNDR_TYP,
999: PDAY.DAY_CD,

Line 1055: INTO DDR_R_DAY_TRANS

1051: and NYR.DAY_CD(+) = ADD_DAY(BDAY.DAY_CD,V_YR_TIMESPN)
1052: and BDAY.DAY_CD = V_START_YEAR||'0229';
1053:
1054: INSERT
1055: INTO DDR_R_DAY_TRANS
1056: (
1057: MFG_ORG_CD,
1058: DAY_TRANS_ID,
1059: DAY_CD,

Line 1085: DDR_R_DAY_TRANS_SEQ.NEXTVAL,

1081: LAST_UPDATE_DATE,
1082: LAST_UPDATE_LOGIN
1083: )
1084: SELECT BDAY.ORG_CD,
1085: DDR_R_DAY_TRANS_SEQ.NEXTVAL,
1086: BDAY.DAY_CD,
1087: BDAY.CLNDR_CD,
1088: BDAY.CLNDR_TYP,
1089: PDAY.DAY_CD,

Line 1146: INTO DDR_R_DAY_TRANS

1142: and BDAY.DAY_CD > V_START_YEAR||'0229';
1143:
1144: elsif (mod(v_start_year-1,4)=0) THEN
1145: INSERT
1146: INTO DDR_R_DAY_TRANS
1147: (
1148: MFG_ORG_CD,
1149: DAY_TRANS_ID,
1150: DAY_CD,

Line 1176: DDR_R_DAY_TRANS_SEQ.NEXTVAL,

1172: LAST_UPDATE_DATE,
1173: LAST_UPDATE_LOGIN
1174: )
1175: SELECT BDAY.ORG_CD,
1176: DDR_R_DAY_TRANS_SEQ.NEXTVAL,
1177: BDAY.DAY_CD,
1178: BDAY.CLNDR_CD,
1179: BDAY.CLNDR_TYP,
1180: PDAY.DAY_CD,

Line 1236: INTO DDR_R_DAY_TRANS

1232: and NYR.DAY_CD(+) = ADD_DAY(BDAY.DAY_CD,V_YR_TIMESPN)
1233: and BDAY.DAY_CD <= V_START_YEAR||'0228';
1234:
1235: INSERT
1236: INTO DDR_R_DAY_TRANS
1237: (
1238: MFG_ORG_CD,
1239: DAY_TRANS_ID,
1240: DAY_CD,

Line 1266: DDR_R_DAY_TRANS_SEQ.NEXTVAL,

1262: LAST_UPDATE_DATE,
1263: LAST_UPDATE_LOGIN
1264: )
1265: SELECT BDAY.ORG_CD,
1266: DDR_R_DAY_TRANS_SEQ.NEXTVAL,
1267: BDAY.DAY_CD,
1268: BDAY.CLNDR_CD,
1269: BDAY.CLNDR_TYP,
1270: PDAY.DAY_CD,

Line 1328: INTO DDR_R_DAY_TRANS

1324:
1325: ELSE
1326:
1327: INSERT
1328: INTO DDR_R_DAY_TRANS
1329: (
1330: MFG_ORG_CD,
1331: DAY_TRANS_ID,
1332: DAY_CD,

Line 1358: DDR_R_DAY_TRANS_SEQ.NEXTVAL,

1354: LAST_UPDATE_DATE,
1355: LAST_UPDATE_LOGIN
1356: )
1357: SELECT BDAY.ORG_CD,
1358: DDR_R_DAY_TRANS_SEQ.NEXTVAL,
1359: BDAY.DAY_CD,
1360: BDAY.CLNDR_CD,
1361: BDAY.CLNDR_TYP,
1362: PDAY.DAY_CD,