DBA Data[Home] [Help]

APPS.CN_NOTIFY_ORDERS dependencies on CN_PERIODS

Line 1279: x_start_period cn_periods.period_id%TYPE,

1275: -- order updates off of the queue
1276:
1277: PROCEDURE regular_col_notify
1278: (
1279: x_start_period cn_periods.period_id%TYPE,
1280: x_end_period cn_periods.period_id%TYPE,
1281: x_adj_flag VARCHAR2,
1282: parent_proc_audit_id NUMBER,
1283: debug_pipe VARCHAR2 DEFAULT NULL,

Line 1280: x_end_period cn_periods.period_id%TYPE,

1276:
1277: PROCEDURE regular_col_notify
1278: (
1279: x_start_period cn_periods.period_id%TYPE,
1280: x_end_period cn_periods.period_id%TYPE,
1281: x_adj_flag VARCHAR2,
1282: parent_proc_audit_id NUMBER,
1283: debug_pipe VARCHAR2 DEFAULT NULL,
1284: debug_level NUMBER DEFAULT NULL,

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

1337: cn_process_audits_pkg.insert_row
1338: ( l_rowid, l_proc_audit_id, NULL, 'NOT', 'Notification run',
1339: NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);
1340:
1341: cn_periods_api.set_dates(x_start_period, x_end_period, x_org_id,
1342: l_start_date, l_end_date);
1343:
1344: cn_message_pkg.debug
1345: ( 'notify: Inserting records into CN_NOT_TRX from period '