APPS.CN_NOTIFY_CLAWBACKS dependencies on CN_PERIODS

Line 15: x_start_period cn_periods.period_id%TYPE,

11: -- 01-05-96 A. Erickson Created
12:
13:
14: PROCEDURE notify (
15: x_start_period cn_periods.period_id%TYPE,
16: x_end_period cn_periods.period_id%TYPE,
17: debug_pipe VARCHAR2 DEFAULT NULL,
18: debug_level NUMBER DEFAULT NULL,
19: x_org_id NUMBER) IS

Line 16: x_end_period cn_periods.period_id%TYPE,

12:
13:
14: PROCEDURE notify (
15: x_start_period cn_periods.period_id%TYPE,
16: x_end_period cn_periods.period_id%TYPE,
17: debug_pipe VARCHAR2 DEFAULT NULL,
18: debug_level NUMBER DEFAULT NULL,
19: x_org_id NUMBER) IS
20:

Line 47: cn_periods_api.set_dates(x_start_period, x_end_period, x_org_id,

43: x_proc_audit_id := NULL; -- Will get a value in the call below
44: cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, NULL,
45: 'NOT', 'Notification run', NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);
46:
47: cn_periods_api.set_dates(x_start_period, x_end_period, x_org_id,
48: x_start_date, x_end_date);
49:
50: -- Set end_due_date for clawbacks. 02-26-96
51: -- This is the end_date minus the clawback grace period.

Line 56: FROM cn_periods p

52:
53: --bug 513940 -J.C
54: SELECT r.clawback_grace_days
55: INTO x_clb_grace_period
56: FROM cn_periods p
57: ,cn_repositories r
58: ,gl_sets_of_books s
59: WHERE r.current_period_id = p.period_id(+)
60: AND r.application_id = 283