eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PERIODS_API dependencies on CN_PERIOD_STATUSES

Line 68: CURSOR cn_period_info(p_period_name cn_period_statuses.period_name%TYPE,

64: l_quarter_num NUMBER(15);
65: l_period_year NUMBER(15);
66:
67: -- Added as part of bug fix bug#2804029
68: CURSOR cn_period_info(p_period_name cn_period_statuses.period_name%TYPE,
69: p_period_year cn_period_statuses.period_year%TYPE) IS
70: SELECT cn.period_status
71: FROM cn_period_statuses cn
72: WHERE cn.period_name = p_period_name

Line 69: p_period_year cn_period_statuses.period_year%TYPE) IS

65: l_period_year NUMBER(15);
66:
67: -- Added as part of bug fix bug#2804029
68: CURSOR cn_period_info(p_period_name cn_period_statuses.period_name%TYPE,
69: p_period_year cn_period_statuses.period_year%TYPE) IS
70: SELECT cn.period_status
71: FROM cn_period_statuses cn
72: WHERE cn.period_name = p_period_name
73: AND cn.period_year = p_period_year

Line 71: FROM cn_period_statuses cn

67: -- Added as part of bug fix bug#2804029
68: CURSOR cn_period_info(p_period_name cn_period_statuses.period_name%TYPE,
69: p_period_year cn_period_statuses.period_year%TYPE) IS
70: SELECT cn.period_status
71: FROM cn_period_statuses cn
72: WHERE cn.period_name = p_period_name
73: AND cn.period_year = p_period_year
74: AND cn.org_id = x_org_id;
75:

Line 114: UPDATE cn_period_statuses

110: AND set_of_books_id = x_set_of_books_id ;
111:
112: -- 1979768
113: IF (x_closing_status = 'O' OR x_closing_status = 'F') THEN
114: UPDATE cn_period_statuses
115: SET period_status = x_closing_status,
116: forecast_flag = x_forecast_flag,
117: freeze_flag = x_freeze_flag,
118: last_update_date = x_last_update_date,

Line 126: UPDATE cn_period_statuses

122: processing_status_code = 'PROCESSING'
123: WHERE period_name = x_period_name
124: AND org_id = x_org_id;
125: ELSE
126: UPDATE cn_period_statuses
127: SET period_status = x_closing_status,
128: forecast_flag = x_forecast_flag,
129: freeze_flag = x_freeze_flag,
130: last_update_date = x_last_update_date,

Line 341: FROM cn_period_statuses

337: end_date,
338: quarter_num,
339: period_year,
340: period_status
341: FROM cn_period_statuses
342: WHERE processing_status_code = 'PROCESSING'
343: AND period_id between l_start_period_id and l_end_period_id
344: AND request_id is null
345: ORDER BY period_id;

Line 382: from cn_period_statuses

378:
379: -- determine the periods to process
380: select min(period_id), max(period_id), min(start_date), max(end_date)
381: into l_start_period_id, l_end_period_id, l_start_date, l_end_date
382: from cn_period_statuses
383: where processing_status_code = 'PROCESSING';
384:
385: ----------------------------------------------------------------------------------
386: fnd_file.put_line(fnd_file.Log, 'Step 1 : Period Information');

Line 431: cn_period_statuses cps

427: and rr.role_id = r.role_id
428: and r.role_type_code = 'SALES_COMP'
429: and (rr.end_date_active IS NULL OR rr.end_date_active >= l_start_date)
430: and rr.start_date_active <= l_end_date) v,
431: cn_period_statuses cps
432: where cps.processing_status_code = 'PROCESSING'
433: and cps.period_id between l_start_period_id and l_end_period_id
434: and not exists
435: (select 1

Line 438: from cn_period_statuses

434: and not exists
435: (select 1
436: from cn_process_batches
437: where logical_batch_id = (select logical_batch_id
438: from cn_period_statuses
439: where period_id = cps.period_id)
440: and salesrep_id = v.salesrep_id
441: and period_id = cps.period_id
442: and sales_lines_total = 1);

Line 505: UPDATE cn_period_statuses

501: END LOOP;
502: END LOOP;
503:
504: -- if affected quotas are updated successfully, then mark the periods with logical_batch_id
505: UPDATE cn_period_statuses
506: SET request_id = l_logical_batch_id
507: WHERE processing_status_code = 'PROCESSING'
508: AND period_id between l_start_period_id AND l_end_period_id;
509:

Line 544: UPDATE cn_period_statuses

540: -------------------------------------------------------------------
541: fnd_file.put_line(fnd_file.Log, 'Step 9 : Parallel Process Ends');
542: -------------------------------------------------------------------
543:
544: UPDATE cn_period_statuses
545: SET processing_status_code = 'CLEAN'
546: WHERE processing_status_code = 'PROCESSING'
547: AND period_id between l_start_period_id AND l_end_period_id;
548:

Line 568: UPDATE cn_period_statuses

564: retcode := 2;
565: errbuf := SQLCODE||' '||Sqlerrm;
566:
567: -- set status to ERROR
568: UPDATE cn_period_statuses
569: SET processing_status_code = 'FAILED'
570: WHERE processing_status_code = 'PROCESSING';
571:
572: IF l_org_id IS NOT NULL THEN

Line 631: FROM cn_period_statuses

627: and qa.quota_id = q.quota_id;
628:
629: CURSOR get_pd_info(l_period_id IN NUMBER) IS
630: SELECT start_date, end_date, period_status
631: FROM cn_period_statuses
632: WHERE period_id = l_period_id;
633:
634: CURSOR srp_payee_info(l_salesrep_id in number) IS
635: SELECT spay.quota_id, spay.start_date, spay.end_date, spa.comp_plan_id

Line 878: cn_message_pkg.debug('Update cn_period_statuses.processing_status_code');

874:
875: COMMIT; -- commit for each srp and period
876: END LOOP; -- main srp loop
877:
878: cn_message_pkg.debug('Update cn_period_statuses.processing_status_code');
879: cn_message_pkg.debug('Populate SRP tables runner <<');
880: cn_message_pkg.end_batch(l_proc_audit_id);
881: EXCEPTION
882: WHEN payee_pop_failed THEN

Line 887: UPDATE cn_period_statuses

883: --ROLLBACK TO populate_srp_tables;
884: retcode := 2;
885:
886: -- change status to FAILED
887: UPDATE cn_period_statuses
888: SET processing_status_code = 'FAILED'
889: WHERE processing_status_code = 'PROCESSING'
890: AND period_id = l_curr_pd_id;
891: -- commit status change

Line 903: UPDATE cn_period_statuses

899: --ROLLBACK TO populate_srp_tables_runner;
900: retcode := 2;
901:
902: -- change status to FAILED
903: UPDATE cn_period_statuses
904: SET processing_status_code = 'FAILED'
905: WHERE processing_status_code = 'PROCESSING'
906: AND period_id = l_curr_pd_id;
907: -- commit status change

Line 919: UPDATE cn_period_statuses

915: errbuf := substr(sqlerrm,1,250);
916: retcode := 2;
917:
918: -- change status to FAILED
919: UPDATE cn_period_statuses
920: SET processing_status_code = 'FAILED'
921: WHERE processing_status_code = 'PROCESSING'
922: AND period_id = l_curr_pd_id;
923: -- commit status change

Line 938: -- Create a CN status record in CN_PERIOD_STATUSES if it doesn't exist.

934: --
935: -- Procedure Name
936: -- Check_CN_Period_Record
937: -- Purpose
938: -- Create a CN status record in CN_PERIOD_STATUSES if it doesn't exist.
939: --
940:
941: PROCEDURE Check_CN_Period_Record (x_org_id NUMBER,
942: x_period_name VARCHAR2,

Line 1044: FROM cn_period_statuses

1040: 1000 * x_period_year + x_period_num;
1041:
1042: SELECT period_id
1043: INTO x_dummy
1044: FROM cn_period_statuses
1045: WHERE period_id = x_period_id
1046: AND org_id = x_org_id;
1047:
1048: EXCEPTION

Line 1063: INSERT INTO cn_period_statuses

1059: -- else x_period_type_id := 0 ; -- Bug 397015. Xinyang Fan
1060: -- end if;
1061:
1062:
1063: INSERT INTO cn_period_statuses
1064: (period_id,
1065: period_name,
1066: period_type_id,
1067: period_status,

Line 1149: PROCEDURE set_dates (x_start_period_id cn_period_statuses.period_id%TYPE,

1145: -- 01-26-96 A. Erickson Created
1146: -- 03-13-96 A. Erickson Updated.
1147: --
1148:
1149: PROCEDURE set_dates (x_start_period_id cn_period_statuses.period_id%TYPE,
1150: x_end_period_id cn_period_statuses.period_id%TYPE,
1151: x_org_id cn_period_statuses.org_id%TYPE,
1152: x_start_date OUT nocopy DATE,
1153: x_end_date OUT nocopy DATE) IS

Line 1150: x_end_period_id cn_period_statuses.period_id%TYPE,

1146: -- 03-13-96 A. Erickson Updated.
1147: --
1148:
1149: PROCEDURE set_dates (x_start_period_id cn_period_statuses.period_id%TYPE,
1150: x_end_period_id cn_period_statuses.period_id%TYPE,
1151: x_org_id cn_period_statuses.org_id%TYPE,
1152: x_start_date OUT nocopy DATE,
1153: x_end_date OUT nocopy DATE) IS
1154:

Line 1151: x_org_id cn_period_statuses.org_id%TYPE,

1147: --
1148:
1149: PROCEDURE set_dates (x_start_period_id cn_period_statuses.period_id%TYPE,
1150: x_end_period_id cn_period_statuses.period_id%TYPE,
1151: x_org_id cn_period_statuses.org_id%TYPE,
1152: x_start_date OUT nocopy DATE,
1153: x_end_date OUT nocopy DATE) IS
1154:
1155: CURSOR get_dates (p_period_id NUMBER) is

Line 1157: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP

1153: x_end_date OUT nocopy DATE) IS
1154:
1155: CURSOR get_dates (p_period_id NUMBER) is
1156: SELECT cn.start_date, cn.end_date
1157: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP
1158: WHERE rp.period_set_id = cn.period_set_id
1159: AND rp.period_type_id = cn.period_type_id
1160: AND cn.org_id = rp.org_id
1161: AND cn.org_id = x_org_id

Line 1168: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP

1164: date_rec get_dates%ROWTYPE;
1165:
1166: CURSOR get_min_date IS
1167: SELECT MIN(cn.start_date)
1168: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP
1169: WHERE rp.period_set_id = cn.period_set_id
1170: AND rp.period_type_id = cn.period_type_id
1171: AND cn.org_id = rp.org_id
1172: AND cn.org_id = x_org_id;