DBA Data[Home] [Help]

APPS.IGS_AS_SS_DOC_REQUEST dependencies on FND_GLOBAL

Line 283: || fnd_global.newline ();

279: || 'Item Type: '
280: || cur_dtl.doc_type
281: || '
'
282: || '
'
283: || fnd_global.newline ();
284: ELSE
285: lvdocdetails := lvdocdetails
286: || 'Document No: '
287: || TO_CHAR (cur_item%ROWCOUNT)

Line 296: || fnd_global.newline ();

292: || 'Item Type: '
293: || cur_dtl.doc_type
294: || '
'
295: || '
'
296: || fnd_global.newline ();
297: END IF;
298: END LOOP;
299: IF RTRIM (LTRIM (lvdocdetails)) IS NULL THEN
300: RETURN fnd_message.get_string ('IGS', 'IGS_SS_AS_NO_ITEM');

Line 354: || fnd_global.newline ();

350: || 'Item Type: '
351: || cur_dtl.doc_type
352: || '
'
353: || '
'
354: || fnd_global.newline ();
355: ELSE
356: lvdocdetails := lvdocdetails
357: || 'Document No: '
358: || TO_CHAR (cur_item%ROWCOUNT)

Line 370: || fnd_global.newline ();

366: || 'Item Type: '
367: || cur_dtl.doc_type
368: || '
'
369: || '
'
370: || fnd_global.newline ();
371: END IF;
372: END LOOP;
373: IF RTRIM (LTRIM (lvdocdetails)) IS NULL THEN
374: RETURN fnd_message.get_string ('IGS', 'IGS_SS_AS_NO_ITEM');

Line 3246: NULL, NULL, SYSDATE, fnd_global.user_id, SYSDATE,

3242: NULL, NULL, NULL, NULL,
3243: NULL, NULL, NULL,
3244: NULL, NULL, NULL, NULL,
3245: NULL, NULL, NULL, NULL, NULL,
3246: NULL, NULL, SYSDATE, fnd_global.user_id, SYSDATE,
3247: fnd_global.user_id, fnd_global.user_id, NULL, NULL, NULL,
3248: NULL, c_prsn_info_rec.email_address);
3249: --End of creation of order and int item
3250: -- Change the concat string to substr for the bext loop--------

Line 3247: fnd_global.user_id, fnd_global.user_id, NULL, NULL, NULL,

3243: NULL, NULL, NULL,
3244: NULL, NULL, NULL, NULL,
3245: NULL, NULL, NULL, NULL, NULL,
3246: NULL, NULL, SYSDATE, fnd_global.user_id, SYSDATE,
3247: fnd_global.user_id, fnd_global.user_id, NULL, NULL, NULL,
3248: NULL, c_prsn_info_rec.email_address);
3249: --End of creation of order and int item
3250: -- Change the concat string to substr for the bext loop--------
3251: l_person_ids := SUBSTR (l_person_ids, INSTR (l_person_ids, l_seperator, 1) + 1); -- Person Id string reduced