DBA Data[Home] [Help]

APPS.IEC_RETURNS_UTIL_PVT dependencies on FND_GLOBAL

Line 75: l_user_id := nvl( FND_GLOBAL.user_id, -1 );

71: l_user_id NUMBER;
72: l_login_id NUMBER;
73: BEGIN
74:
75: l_user_id := nvl( FND_GLOBAL.user_id, -1 );
76: l_login_id := nvl( FND_GLOBAL.conc_login_id, -1 );
77: IF( ( P_LIST_ENTRY_ID is null )
78: OR( P_LIST_HEADER_ID is null )
79: OR( P_CPN_SCHEDULE_ID is null ) )

Line 76: l_login_id := nvl( FND_GLOBAL.conc_login_id, -1 );

72: l_login_id NUMBER;
73: BEGIN
74:
75: l_user_id := nvl( FND_GLOBAL.user_id, -1 );
76: l_login_id := nvl( FND_GLOBAL.conc_login_id, -1 );
77: IF( ( P_LIST_ENTRY_ID is null )
78: OR( P_LIST_HEADER_ID is null )
79: OR( P_CPN_SCHEDULE_ID is null ) )
80: THEN

Line 162: l_user_id := nvl( FND_GLOBAL.user_id, -1 );

158: l_user_id NUMBER;
159: l_callback_flag VARCHAR2(1);
160:
161: BEGIN
162: l_user_id := nvl( FND_GLOBAL.user_id, -1 );
163: l_callback_flag := 'N';
164: IF( ( P_RETURNS_ID is null ) )
165: THEN
166: raise_application_error

Line 279: l_user_id := nvl( FND_GLOBAL.user_id, -1 );

275: AS
276: l_user_id NUMBER;
277:
278: BEGIN
279: l_user_id := nvl( FND_GLOBAL.user_id, -1 );
280: IF( ( P_RETURNS_ID is null ) )
281: THEN
282: raise_application_error
283: ( -20000

Line 336: l_user_id := nvl( FND_GLOBAL.user_id, -1 );

332: )
333: AS
334: l_user_id NUMBER;
335: BEGIN
336: l_user_id := nvl( FND_GLOBAL.user_id, -1 );
337:
338: IF( ( P_LIST_ENTRY_ID is null )
339: OR( P_LIST_HEADER_ID is null )
340: OR( P_CPN_SCHEDULE_ID is null ) )

Line 382: l_user_id := nvl( FND_GLOBAL.user_id, -1 );

378: l_call_attempt NUMBER;
379: l_outcome_ids t_outcome;
380: l_times t_time;
381: BEGIN
382: l_user_id := nvl( FND_GLOBAL.user_id, -1 );
383: l_login_id := nvl( FND_GLOBAL.conc_login_id, -1 );
384: l_outcome_ids := t_outcome(null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
385: l_times := t_time(null,null,null,null,null,null,null,null,null,null,null,null,
386: null,null,null,null,null,null,null,null,null);

Line 383: l_login_id := nvl( FND_GLOBAL.conc_login_id, -1 );

379: l_outcome_ids t_outcome;
380: l_times t_time;
381: BEGIN
382: l_user_id := nvl( FND_GLOBAL.user_id, -1 );
383: l_login_id := nvl( FND_GLOBAL.conc_login_id, -1 );
384: l_outcome_ids := t_outcome(null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
385: l_times := t_time(null,null,null,null,null,null,null,null,null,null,null,null,
386: null,null,null,null,null,null,null,null,null);
387: BEGIN

Line 496: nvl(FND_GLOBAL.USER_ID,-1),

492: 1,
493: null,
494: P_OUTCOME_ID,
495: P_TIME,
496: nvl(FND_GLOBAL.USER_ID,-1),
497: sysdate,
498: nvl(FND_GLOBAL.USER_ID,-1),
499: sysdate,
500: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)

Line 498: nvl(FND_GLOBAL.USER_ID,-1),

494: P_OUTCOME_ID,
495: P_TIME,
496: nvl(FND_GLOBAL.USER_ID,-1),
497: sysdate,
498: nvl(FND_GLOBAL.USER_ID,-1),
499: sysdate,
500: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)
501: );
502:

Line 500: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)

496: nvl(FND_GLOBAL.USER_ID,-1),
497: sysdate,
498: nvl(FND_GLOBAL.USER_ID,-1),
499: sysdate,
500: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)
501: );
502:
503: INSERT INTO iec_o_rcy_call_histories
504: (

Line 525: nvl(FND_GLOBAL.USER_ID,-1),

521: 1,
522: P_CONTACT_POINT,
523: P_OUTCOME_ID,
524: P_TIME,
525: nvl(FND_GLOBAL.USER_ID,-1),
526: sysdate,
527: nvl(FND_GLOBAL.USER_ID,-1),
528: sysdate,
529: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)

Line 527: nvl(FND_GLOBAL.USER_ID,-1),

523: P_OUTCOME_ID,
524: P_TIME,
525: nvl(FND_GLOBAL.USER_ID,-1),
526: sysdate,
527: nvl(FND_GLOBAL.USER_ID,-1),
528: sysdate,
529: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)
530: );
531:

Line 529: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)

525: nvl(FND_GLOBAL.USER_ID,-1),
526: sysdate,
527: nvl(FND_GLOBAL.USER_ID,-1),
528: sysdate,
529: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)
530: );
531:
532: END; -- END INSERT BLOCK
533: RETURN;

Line 648: nvl(FND_GLOBAL.USER_ID,-1),

644: 1,
645: P_CONTACT_POINT,
646: P_OUTCOME_ID,
647: P_TIME,
648: nvl(FND_GLOBAL.USER_ID,-1),
649: sysdate,
650: nvl(FND_GLOBAL.USER_ID,-1),
651: sysdate,
652: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)

Line 650: nvl(FND_GLOBAL.USER_ID,-1),

646: P_OUTCOME_ID,
647: P_TIME,
648: nvl(FND_GLOBAL.USER_ID,-1),
649: sysdate,
650: nvl(FND_GLOBAL.USER_ID,-1),
651: sysdate,
652: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)
653: );
654:

Line 652: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)

648: nvl(FND_GLOBAL.USER_ID,-1),
649: sysdate,
650: nvl(FND_GLOBAL.USER_ID,-1),
651: sysdate,
652: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1)
653: );
654:
655: END; -- END INSERT BLOCK
656: RETURN;