[Home] [Help]
380: ,l_two_done_rsln(i) two_rsln_in_period
381: ,l_three_done_rsln(i) three_rsln_in_period
382: ,l_four_done_rsln(i) four_rsln_in_period
383: ,l_intr_thread(i) interaction_threads_in_period
384: FROM DUAL) change
385: ON (
386: bed.agent_id = change.agent_id
387: AND bed.party_id = change.party_id
388: AND bed.email_account_id = change.email_account_id
1227: nvl(p_acc_emails_one_day(i),0) accumulated_emails_one_day,
1228: nvl(p_acc_emails_three_days(i),0) accumulated_emails_three_days,
1229: nvl(p_acc_emails_week(i),0) accumulated_emails_week,
1230: nvl(p_acc_emails_week_plus(i),0) accumulated_emails_week_plus
1231: FROM dual) change
1232: ON (bed.email_account_id = change.email_account_id
1233: AND bed.email_classification_id = change.email_classification_id
1234: AND bed.agent_id = change.agent_id
1235: AND bed.party_id = change.party_id
1833: nvl(p_acc_emails_one_day(i),0) accumulated_emails_one_day,
1834: nvl(p_acc_emails_three_days(i),0) accumulated_emails_three_days,
1835: nvl(p_acc_emails_week(i),0) accumulated_emails_week,
1836: nvl(p_acc_emails_week_plus(i),0) accumulated_emails_week_plus
1837: FROM dual) change
1838: ON (bed.email_account_id = change.email_account_id
1839: AND bed.email_classification_id = change.email_classification_id
1840: AND bed.agent_id = change.agent_id
1841: AND bed.party_id = change.party_id
2968: WHERE report_date between trunc(p_start_date) and trunc(p_end_date);
2969:
2970: SELECT (trunc(p_end_date) - trunc(p_start_date)) + 1
2971: INTO l_count2
2972: FROM dual;
2973:
2974: IF (l_count1 < l_count2) THEN
2975: p_has_missing_date := TRUE;
2976: END IF;
3101: DECODE(SIGN(TO_NUMBER(TO_CHAR(l_start_date,'MI'))-29),0,'00:00',1,'30:00',-1,'00:00'),
3102: 'YYYY/MM/DD HH24:MI:SS')
3103: INTO
3104: l_start_date
3105: FROM DUAL;
3106:
3107: l_end_date := sysdate;
3108:
3109:
3115: DECODE(SIGN(TO_NUMBER(TO_CHAR(l_end_date,'MI'))-29),0,'00:00',1,'30:00',-1,'00:00'),
3116: 'YYYY/MM/DD HH24:MI:SS') - 1/86400
3117: INTO
3118: l_end_date
3119: FROM DUAL;
3120:
3121: --???? For Debugging Purposes
3122: --l_end_date := sysdate;
3123: