DBA Data[Home] [Help]

APPS.AS_LEADS_AUDIT_PKG dependencies on FND_PROFILE

Line 71: IF (UPPER(nvl(FND_PROFILE.VALUE('AS_OPP_ENABLE_LOG'), 'N')) = 'Y' ) THEN

67: -- dbms_output.put_line( 'p_trigger_mode = '|| p_trigger_mode );
68: -- dbms_output.put_line( 'p_old_last_update_date = '|| to_char(p_old_last_update_date, 'DD-MON-YYYY HH:MI:SSSSS') );
69: -- dbms_output.put_line( 'p_new_last_update_date = '|| to_char(p_new_last_update_date, 'DD-MON-YYYY HH:MI:SSSSS') );
70:
71: IF (UPPER(nvl(FND_PROFILE.VALUE('AS_OPP_ENABLE_LOG'), 'N')) = 'Y' ) THEN
72:
73: update as_leads_log
74: set object_version_number = nvl(object_version_number,0) + 1, log_end_date = p_new_last_update_date,
75: current_log = 0,

Line 837: TIMEFRAME := nvl(FND_PROFILE.VALUE('AS_OPP_LOG_TIMEFRAME'),'NONE');

833: AS_TIMEFRAME VARCHAR2(10);
834: BEGIN
835:
836: IsInsert := 1;
837: TIMEFRAME := nvl(FND_PROFILE.VALUE('AS_OPP_LOG_TIMEFRAME'),'NONE');
838: -- dbms_output.put_line('TIMEFRAME = ' || TIMEFRAME );
839: -- dbms_output.put_line('Old date is='|| to_char(p_old_last_update_date,'dd/mon/yyyy HH:MI:SS'));
840: -- dbms_output.put_line('Old date is='|| to_char(p_new_last_update_date,'dd/mon/yyyy HH:MI:SS'));
841: