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 627: FROM cn_period_statuses

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

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

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

Line 883: UPDATE cn_period_statuses

879: --ROLLBACK TO populate_srp_tables;
880: retcode := 2;
881:
882: -- change status to FAILED
883: UPDATE cn_period_statuses
884: SET processing_status_code = 'FAILED'
885: WHERE processing_status_code = 'PROCESSING'
886: AND period_id = l_curr_pd_id;
887: -- commit status change

Line 899: UPDATE cn_period_statuses

895: --ROLLBACK TO populate_srp_tables_runner;
896: retcode := 2;
897:
898: -- change status to FAILED
899: UPDATE cn_period_statuses
900: SET processing_status_code = 'FAILED'
901: WHERE processing_status_code = 'PROCESSING'
902: AND period_id = l_curr_pd_id;
903: -- commit status change

Line 915: UPDATE cn_period_statuses

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

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

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

Line 1040: FROM cn_period_statuses

1036: 1000 * x_period_year + x_period_num;
1037:
1038: SELECT period_id
1039: INTO x_dummy
1040: FROM cn_period_statuses
1041: WHERE period_id = x_period_id
1042: AND org_id = x_org_id;
1043:
1044: EXCEPTION

Line 1059: INSERT INTO cn_period_statuses

1055: -- else x_period_type_id := 0 ; -- Bug 397015. Xinyang Fan
1056: -- end if;
1057:
1058:
1059: INSERT INTO cn_period_statuses
1060: (period_id,
1061: period_name,
1062: period_type_id,
1063: period_status,

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

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

Line 1146: x_end_period_id cn_period_statuses.period_id%TYPE,

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

Line 1147: x_org_id cn_period_statuses.org_id%TYPE,

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

Line 1153: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP

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

Line 1164: FROM CN_PERIOD_STATUSES CN, CN_REPOSITORIES_ALL RP

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