APPS.CN_NOTIFY_ORDERS dependencies on CN_REPOSITORIES

Line 155: CURSOR batch_size IS SELECT system_batch_size FROM cn_repositories WHERE org_id = x_org_id;

151: l_trx_count NUMBER;
152: l_proc_audit_id NUMBER;
153: l_rowid ROWID;
154: l_sys_batch_size NUMBER;
155: CURSOR batch_size IS SELECT system_batch_size FROM cn_repositories WHERE org_id = x_org_id;
156:
157: BEGIN
158:
159: cn_message_pkg.debug('notify: adjust: entering notify_line (lid = '||p_line_id||') ');

Line 270: CURSOR batch_size IS SELECT system_batch_size FROM cn_repositories WHERE org_id = p_org_id;

266: l_proc_audit_id NUMBER;
267: l_rowid ROWID;
268: l_org_id NUMBER;
269: l_sys_batch_size NUMBER;
270: CURSOR batch_size IS SELECT system_batch_size FROM cn_repositories WHERE org_id = p_org_id;
271:
272: BEGIN
273:
274: cn_message_pkg.debug('notify: adjust: entering notify_deleted_line (lid = '||p_line_id||')');

Line 1303: CURSOR batch_size IS SELECT system_batch_size FROM cn_repositories WHERE org_id = x_org_id;

1299: l_so_org_id NUMBER;
1300: l_sys_batch_size NUMBER;
1301: l_client_org_id NUMBER;
1302:
1303: CURSOR batch_size IS SELECT system_batch_size FROM cn_repositories WHERE org_id = x_org_id;
1304:
1305: BEGIN
1306: IF (debug_pipe IS NOT NULL) THEN
1307: cn_debug.init_pipe(debug_pipe, debug_level);