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 ) )
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
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
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
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 ) )
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);
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
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)
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:
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: (
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)
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:
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;
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)
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:
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;