APPS.ASP_ALERTS_INVOICE dependencies on FND_PROFILE

Line 106: l_REQUEST_ID := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));

102: end if;
103:
104: save_threshold := wf_engine.threshold;
105: l_PROGRAM_START_DATE := sysdate;
106: l_REQUEST_ID := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
107: l_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
108: l_PROGRAM_ID := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));
109: l_PROGRAM_LOGIN_ID := TO_NUMBER(fnd_profile.value('USER_ID'));
110: l_CREATED_BY := l_PROGRAM_LOGIN_ID;

Line 108: l_PROGRAM_ID := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));

104: save_threshold := wf_engine.threshold;
105: l_PROGRAM_START_DATE := sysdate;
106: l_REQUEST_ID := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
107: l_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
108: l_PROGRAM_ID := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));
109: l_PROGRAM_LOGIN_ID := TO_NUMBER(fnd_profile.value('USER_ID'));
110: l_CREATED_BY := l_PROGRAM_LOGIN_ID;
111: l_LAST_UPDATED_BY := l_PROGRAM_LOGIN_ID;
112: l_LAST_UPDATE_LOGIN := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));

Line 109: l_PROGRAM_LOGIN_ID := TO_NUMBER(fnd_profile.value('USER_ID'));

105: l_PROGRAM_START_DATE := sysdate;
106: l_REQUEST_ID := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
107: l_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
108: l_PROGRAM_ID := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));
109: l_PROGRAM_LOGIN_ID := TO_NUMBER(fnd_profile.value('USER_ID'));
110: l_CREATED_BY := l_PROGRAM_LOGIN_ID;
111: l_LAST_UPDATED_BY := l_PROGRAM_LOGIN_ID;
112: l_LAST_UPDATE_LOGIN := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));
113:

Line 112: l_LAST_UPDATE_LOGIN := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));

108: l_PROGRAM_ID := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));
109: l_PROGRAM_LOGIN_ID := TO_NUMBER(fnd_profile.value('USER_ID'));
110: l_CREATED_BY := l_PROGRAM_LOGIN_ID;
111: l_LAST_UPDATED_BY := l_PROGRAM_LOGIN_ID;
112: l_LAST_UPDATE_LOGIN := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));
113:
114: open getLastRunDate;
115: fetch getLastRunDate into l_program_ref_date;
116: close getLastRunDate;