DBA Data[Home] [Help]

APPS.PMI_LOT_GENEALOGY_PKG dependencies on FND_PROFILE

Line 69: lv_date := TO_DATE(fnd_profile.value('PMI$LOTGEN_REFRESH_DATE'), datetime_format);

65: IS
66: lv_date DATE;
67: BEGIN
68: BEGIN
69: lv_date := TO_DATE(fnd_profile.value('PMI$LOTGEN_REFRESH_DATE'), datetime_format);
70: EXCEPTION
71: WHEN OTHERS THEN
72: SELECT MIN(trans_date) into lv_date
73: FROM ic_tran_vw1

Line 98: l_err := fnd_profile.save('PMI$LOTGEN_REFRESH_DATE', TO_CHAR(pp_last_refresh_date, datetime_format), 'SITE');

94: )
95: IS
96: l_err BOOLEAN;
97: BEGIN
98: l_err := fnd_profile.save('PMI$LOTGEN_REFRESH_DATE', TO_CHAR(pp_last_refresh_date, datetime_format), 'SITE');
99: /* Commit must follow calls to this procedure */
100: END;
101:
102: