APPS.CSTPMRGL dependencies on FND_DATE

Line 121: l_from_date := fnd_date.canonical_to_date(i_from_date);

117:
118: -- DBMS_OUTPUT.PUT_LINE('l_last_load_date = ' || to_char(l_last_load_date));
119: -- DBMS_OUTPUT.PUT_LINE('l_first_build = ' || to_char(l_first_build));
120:
121: l_from_date := fnd_date.canonical_to_date(i_from_date);
122: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
123:
124: if (l_first_build = 1) then
125:

Line 122: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);

118: -- DBMS_OUTPUT.PUT_LINE('l_last_load_date = ' || to_char(l_last_load_date));
119: -- DBMS_OUTPUT.PUT_LINE('l_first_build = ' || to_char(l_first_build));
120:
121: l_from_date := fnd_date.canonical_to_date(i_from_date);
122: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
123:
124: if (l_first_build = 1) then
125:
126: select NVL(fnd_date.canonical_to_date(i_from_date),to_date('1980/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')),

Line 126: select NVL(fnd_date.canonical_to_date(i_from_date),to_date('1980/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')),

122: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
123:
124: if (l_first_build = 1) then
125:
126: select NVL(fnd_date.canonical_to_date(i_from_date),to_date('1980/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')),
127: NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE)
128: into l_from_date,
129: l_to_date
130: from dual;

Line 127: NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE)

123:
124: if (l_first_build = 1) then
125:
126: select NVL(fnd_date.canonical_to_date(i_from_date),to_date('1980/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')),
127: NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE)
128: into l_from_date,
129: l_to_date
130: from dual;
131:

Line 135: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);

131:
132: elsif (i_from_date is NULL) then
133: if (i_load_option = 1) then
134: l_from_date := to_date('1980/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS');
135: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
136: else
137: l_from_date := l_last_load_date - i_overlap_days;
138: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
139: end if;

Line 138: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);

134: l_from_date := to_date('1980/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS');
135: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
136: else
137: l_from_date := l_last_load_date - i_overlap_days;
138: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
139: end if;
140: end if;
141:
142: Select trunc(l_from_date) , trunc(l_to_date)+ .99999