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.AS_IMPORT_SL_PVT dependencies on FND_GLOBAL

Line 94: nvl(FND_GLOBAL.User_id, -1),

90: program_update_date
91: )
92: values (
93: as_lead_import_errors_s.nextval,
94: nvl(FND_GLOBAL.User_id, -1),
95: sysdate,
96: sysdate,
97: nvl(FND_GLOBAL.User_id, -1),
98: nvl(FND_GLOBAL.Login_id, -1),

Line 97: nvl(FND_GLOBAL.User_id, -1),

93: as_lead_import_errors_s.nextval,
94: nvl(FND_GLOBAL.User_id, -1),
95: sysdate,
96: sysdate,
97: nvl(FND_GLOBAL.User_id, -1),
98: nvl(FND_GLOBAL.Login_id, -1),
99: pI.import_interface_id,
100: nvl(pI.batch_id,-1),
101: l_msg_data,

Line 98: nvl(FND_GLOBAL.Login_id, -1),

94: nvl(FND_GLOBAL.User_id, -1),
95: sysdate,
96: sysdate,
97: nvl(FND_GLOBAL.User_id, -1),
98: nvl(FND_GLOBAL.Login_id, -1),
99: pI.import_interface_id,
100: nvl(pI.batch_id,-1),
101: l_msg_data,
102: pI.request_id,

Line 130: nvl(FND_GLOBAL.User_id, -1),

126: program_update_date
127: )
128: values (
129: as_lead_import_errors_s.nextval,
130: nvl(FND_GLOBAL.User_id, -1),
131: sysdate,
132: sysdate,
133: nvl(FND_GLOBAL.User_id, -1),
134: nvl(FND_GLOBAL.Login_id, -1),

Line 133: nvl(FND_GLOBAL.User_id, -1),

129: as_lead_import_errors_s.nextval,
130: nvl(FND_GLOBAL.User_id, -1),
131: sysdate,
132: sysdate,
133: nvl(FND_GLOBAL.User_id, -1),
134: nvl(FND_GLOBAL.Login_id, -1),
135: pI.import_interface_id,
136: nvl(pI.batch_id,-1),
137: l_msg_data,

Line 134: nvl(FND_GLOBAL.Login_id, -1),

130: nvl(FND_GLOBAL.User_id, -1),
131: sysdate,
132: sysdate,
133: nvl(FND_GLOBAL.User_id, -1),
134: nvl(FND_GLOBAL.Login_id, -1),
135: pI.import_interface_id,
136: nvl(pI.batch_id,-1),
137: l_msg_data,
138: pI.request_id,

Line 178: last_updated_by = nvl(FND_GLOBAL.User_id, -1),

174: -- ffang 102301, bug 2071826, write new_con_flag back.
175: new_con_flag = pI.new_con_flag,
176: -- end 102301
177: last_update_date = sysdate,
178: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
179: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
180: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
181: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
182: program_id = nvl(FND_GLOBAL.conc_program_id, -1),

Line 179: last_update_login = nvl(FND_GLOBAL.Login_id, -1),

175: new_con_flag = pI.new_con_flag,
176: -- end 102301
177: last_update_date = sysdate,
178: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
179: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
180: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
181: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
182: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
183: program_update_date = sysdate,

Line 180: request_id = nvl(FND_GLOBAL.conc_request_id, -1),

176: -- end 102301
177: last_update_date = sysdate,
178: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
179: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
180: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
181: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
182: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
183: program_update_date = sysdate,
184: -- ffang 101601, bug 2053591, populate promotion_id / promotion_code

Line 181: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),

177: last_update_date = sysdate,
178: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
179: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
180: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
181: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
182: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
183: program_update_date = sysdate,
184: -- ffang 101601, bug 2053591, populate promotion_id / promotion_code
185: promotion_id = pI.promotion_id,

Line 182: program_id = nvl(FND_GLOBAL.conc_program_id, -1),

178: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
179: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
180: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
181: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
182: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
183: program_update_date = sysdate,
184: -- ffang 101601, bug 2053591, populate promotion_id / promotion_code
185: promotion_id = pI.promotion_id,
186: -- swkhanna 05/28/02 2385197

Line 207: last_updated_by = nvl(FND_GLOBAL.User_id, -1),

203: -- new_loc_flag = pI.new_loc_flag,
204: -- new_ps_flag = pI.new_ps_flag,
205: -- new_rel_flag = pI.new_rel_flag,
206: last_update_date = sysdate,
207: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
208: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
209: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
210: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
211: program_id = nvl(FND_GLOBAL.conc_program_id, -1),

Line 208: last_update_login = nvl(FND_GLOBAL.Login_id, -1),

204: -- new_ps_flag = pI.new_ps_flag,
205: -- new_rel_flag = pI.new_rel_flag,
206: last_update_date = sysdate,
207: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
208: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
209: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
210: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
211: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
212: program_update_date = sysdate

Line 209: request_id = nvl(FND_GLOBAL.conc_request_id, -1),

205: -- new_rel_flag = pI.new_rel_flag,
206: last_update_date = sysdate,
207: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
208: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
209: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
210: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
211: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
212: program_update_date = sysdate
213: where import_interface_id = pI.import_interface_id;

Line 210: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),

206: last_update_date = sysdate,
207: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
208: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
209: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
210: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
211: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
212: program_update_date = sysdate
213: where import_interface_id = pI.import_interface_id;
214: --where rowid = pI.rowid;

Line 211: program_id = nvl(FND_GLOBAL.conc_program_id, -1),

207: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
208: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
209: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
210: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
211: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
212: program_update_date = sysdate
213: where import_interface_id = pI.import_interface_id;
214: --where rowid = pI.rowid;
215: elsif (pI.load_status = G_LOAD_STATUS_UNEXP_ERR) then

Line 230: last_updated_by = nvl(FND_GLOBAL.User_id, -1),

226: -- new_loc_flag = pI.new_loc_flag,
227: -- new_ps_flag = pI.new_ps_flag,
228: -- new_rel_flag = pI.new_rel_flag,
229: last_update_date = sysdate,
230: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
231: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
232: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
233: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
234: program_id = nvl(FND_GLOBAL.conc_program_id, -1),

Line 231: last_update_login = nvl(FND_GLOBAL.Login_id, -1),

227: -- new_ps_flag = pI.new_ps_flag,
228: -- new_rel_flag = pI.new_rel_flag,
229: last_update_date = sysdate,
230: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
231: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
232: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
233: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
234: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
235: program_update_date = sysdate

Line 232: request_id = nvl(FND_GLOBAL.conc_request_id, -1),

228: -- new_rel_flag = pI.new_rel_flag,
229: last_update_date = sysdate,
230: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
231: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
232: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
233: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
234: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
235: program_update_date = sysdate
236: where import_interface_id = pI.import_interface_id;

Line 233: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),

229: last_update_date = sysdate,
230: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
231: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
232: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
233: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
234: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
235: program_update_date = sysdate
236: where import_interface_id = pI.import_interface_id;
237: --where rowid = pI.rowid;

Line 234: program_id = nvl(FND_GLOBAL.conc_program_id, -1),

230: last_updated_by = nvl(FND_GLOBAL.User_id, -1),
231: last_update_login = nvl(FND_GLOBAL.Login_id, -1),
232: request_id = nvl(FND_GLOBAL.conc_request_id, -1),
233: program_application_id = nvl(FND_GLOBAL.Prog_appl_id, -1),
234: program_id = nvl(FND_GLOBAL.conc_program_id, -1),
235: program_update_date = sysdate
236: where import_interface_id = pI.import_interface_id;
237: --where rowid = pI.rowid;
238: elsif (pI.load_status = 'DUPLICATE') then

Line 3041: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

3037:
3038: l_note_context_rec.NOTE_CONTEXT_TYPE := 'LEAD';
3039: l_note_context_rec.NOTE_CONTEXT_TYPE_ID := pI.sales_lead_id;
3040: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
3041: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3042: l_note_context_rec.CREATION_DATE := SYSDATE;
3043: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
3044: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
3045:

Line 3043: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;

3039: l_note_context_rec.NOTE_CONTEXT_TYPE_ID := pI.sales_lead_id;
3040: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
3041: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3042: l_note_context_rec.CREATION_DATE := SYSDATE;
3043: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
3044: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
3045:
3046: l_note_context_rec_tbl(1) := l_note_context_rec;
3047:

Line 3044: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;

3040: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
3041: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3042: l_note_context_rec.CREATION_DATE := SYSDATE;
3043: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
3044: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
3045:
3046: l_note_context_rec_tbl(1) := l_note_context_rec;
3047:
3048: -- SOLIN, bug 4227632, use 'PARTY' always

Line 3057: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

3053: --end if;
3054:
3055: l_note_context_rec.NOTE_CONTEXT_TYPE_ID := pI.party_id;
3056: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
3057: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3058: l_note_context_rec.CREATION_DATE := SYSDATE;
3059: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
3060: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
3061:

Line 3059: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;

3055: l_note_context_rec.NOTE_CONTEXT_TYPE_ID := pI.party_id;
3056: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
3057: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3058: l_note_context_rec.CREATION_DATE := SYSDATE;
3059: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
3060: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
3061:
3062: l_note_context_rec_tbl(2) := l_note_context_rec;
3063:

Line 3060: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;

3056: l_note_context_rec.LAST_UPDATE_DATE := SYSDATE;
3057: l_note_context_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3058: l_note_context_rec.CREATION_DATE := SYSDATE;
3059: l_note_context_rec.CREATED_BY := FND_GLOBAL.USER_ID;
3060: l_note_context_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.USER_ID;
3061:
3062: l_note_context_rec_tbl(2) := l_note_context_rec;
3063:
3064: -- Call Jtf_notes_pub.create_note()

Line 3082: , p_entered_by => FND_GLOBAL.USER_ID

3078: , p_source_object_code => 'LEAD'
3079: , p_notes => pI.lead_note
3080: , p_notes_detail => NULL --EMPTY_CLOB()
3081: , p_note_status => NULL
3082: , p_entered_by => FND_GLOBAL.USER_ID
3083: , p_entered_date => SYSDATE
3084: , x_jtf_note_id => l_jtf_note_id
3085: , p_last_update_date => SYSDATE
3086: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 3086: , p_last_updated_by => FND_GLOBAL.USER_ID

3082: , p_entered_by => FND_GLOBAL.USER_ID
3083: , p_entered_date => SYSDATE
3084: , x_jtf_note_id => l_jtf_note_id
3085: , p_last_update_date => SYSDATE
3086: , p_last_updated_by => FND_GLOBAL.USER_ID
3087: , p_creation_date => SYSDATE
3088: , p_created_by => FND_GLOBAL.USER_ID
3089: , p_last_update_login => FND_GLOBAL.USER_ID
3090: , p_attribute1 => NULL

Line 3088: , p_created_by => FND_GLOBAL.USER_ID

3084: , x_jtf_note_id => l_jtf_note_id
3085: , p_last_update_date => SYSDATE
3086: , p_last_updated_by => FND_GLOBAL.USER_ID
3087: , p_creation_date => SYSDATE
3088: , p_created_by => FND_GLOBAL.USER_ID
3089: , p_last_update_login => FND_GLOBAL.USER_ID
3090: , p_attribute1 => NULL
3091: , p_attribute2 => NULL
3092: , p_attribute3 => NULL

Line 3089: , p_last_update_login => FND_GLOBAL.USER_ID

3085: , p_last_update_date => SYSDATE
3086: , p_last_updated_by => FND_GLOBAL.USER_ID
3087: , p_creation_date => SYSDATE
3088: , p_created_by => FND_GLOBAL.USER_ID
3089: , p_last_update_login => FND_GLOBAL.USER_ID
3090: , p_attribute1 => NULL
3091: , p_attribute2 => NULL
3092: , p_attribute3 => NULL
3093: , p_attribute4 => NULL

Line 4162: OPEN C_Get_SLAESFORCE(fnd_global.user_id);

4158: THEN
4159: G_SL_SALESFORCE_ID := p_resource_id;
4160: l_group_id := p_group_id;
4161: ELSE
4162: OPEN C_Get_SLAESFORCE(fnd_global.user_id);
4163: FETCH C_Get_SLAESFORCE INTO G_SL_SALESFORCE_ID;
4164: CLOSE C_Get_SLAESFORCE;
4165:
4166: If (G_SL_SALESFORCE_ID is null) then

Line 4816: l_request_id := nvl(FND_GLOBAL.conc_request_id, -1);

4812: -- delete from AS_LEAD_IMPORT_ERRORS;
4813: END IF;
4814:
4815: --Get conc_request_id
4816: l_request_id := nvl(FND_GLOBAL.conc_request_id, -1);
4817:
4818: --Get the batch size for each thread from profile
4819: l_batch_size := nvl(to_number(FND_PROFILE.value('AS_MIN_REC_PARALLEL_FOR_IMPORT')),0);
4820: