APPS.CSTPOMLD dependencies on FND_DATE

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

102:
103: -- DBMS_OUTPUT.PUT_LINE('l_last_load_date = ' || to_char(l_last_load_date));
104: -- DBMS_OUTPUT.PUT_LINE('l_first_build = ' || to_char(l_first_build));
105:
106: l_from_date := fnd_date.canonical_to_date(i_from_date);
107: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
108:
109:
110: if (l_first_build = 1) then

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

103: -- DBMS_OUTPUT.PUT_LINE('l_last_load_date = ' || to_char(l_last_load_date));
104: -- DBMS_OUTPUT.PUT_LINE('l_first_build = ' || to_char(l_first_build));
105:
106: l_from_date := fnd_date.canonical_to_date(i_from_date);
107: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
108:
109:
110: if (l_first_build = 1) then
111:

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

108:
109:
110: if (l_first_build = 1) then
111:
112: select NVL(fnd_date.canonical_to_date(i_from_date),to_date('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')),
113: NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE)
114: into l_from_date,
115: l_to_date
116: from dual;

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

109:
110: if (l_first_build = 1) then
111:
112: select NVL(fnd_date.canonical_to_date(i_from_date),to_date('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')),
113: NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE)
114: into l_from_date,
115: l_to_date
116: from dual;
117:

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

117:
118: elsif (i_from_date is NULL) then
119: if (i_load_option = 1) then
120: l_from_date := to_date('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS');
121: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
122: else
123: l_from_date := l_last_load_date - i_overlap_days;
124: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
125: end if;

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

120: l_from_date := to_date('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS');
121: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
122: else
123: l_from_date := l_last_load_date - i_overlap_days;
124: l_to_date := NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE);
125: end if;
126: end if;
127:
128: