6: x_retcode OUT NOCOPY VARCHAR2,
7: p_cutoff_date IN VARCHAR2 -- <4507823/>
8: ) IS
9: BEGIN
10: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Create_Cpt_Audit_Manager');
11: -- Parent Processing
12:
13: AD_CONC_UTILS_PKG.Submit_Subrequests
14: (x_errbuf => x_errbuf,
20: x_argument4 => p_cutoff_date, -- <4507823/>
21: x_argument5 => to_char(sysdate, 'yymmddhh24miss') -- <4507823>to ensure re-runnable
22: );
23:
24: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_errbuf: ' || x_errbuf);
25: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_retcode: ' || x_retcode);
26: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Create_Cpt_Audit_Manager');
27: END Create_Cpt_Audit_Manager;
28:
21: x_argument5 => to_char(sysdate, 'yymmddhh24miss') -- <4507823>to ensure re-runnable
22: );
23:
24: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_errbuf: ' || x_errbuf);
25: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_retcode: ' || x_retcode);
26: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Create_Cpt_Audit_Manager');
27: END Create_Cpt_Audit_Manager;
28:
29: PROCEDURE Create_Cpt_Audit_Worker
22: );
23:
24: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_errbuf: ' || x_errbuf);
25: FND_FILE.PUT_LINE(FND_FILE.LOG, 'x_retcode: ' || x_retcode);
26: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Create_Cpt_Audit_Manager');
27: END Create_Cpt_Audit_Manager;
28:
29: PROCEDURE Create_Cpt_Audit_Worker
30: (x_errbuf OUT NOCOPY VARCHAR2,
60: IF ((l_retstatus = FALSE) OR (l_table_owner IS NULL)) THEN
61: RAISE_APPLICATION_ERROR(-20001,
62: 'Cannot get schema name for product : '||l_product);
63: END IF;
64: FND_FILE.PUT_LINE(FND_FILE.LOG, ' X_Worker_Id : '||X_Worker_Id);
65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
66:
67: --
68: -- Worker processing
61: RAISE_APPLICATION_ERROR(-20001,
62: 'Cannot get schema name for product : '||l_product);
63: END IF;
64: FND_FILE.PUT_LINE(FND_FILE.LOG, ' X_Worker_Id : '||X_Worker_Id);
65: FND_FILE.PUT_LINE(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
66:
67: --
68: -- Worker processing
69: --
73: --
74: BEGIN -- b
75: l_cutoff_date := to_date(p_cutoff_date, 'YYYY/MM/DD HH24:MI:SS');
76:
77: FND_FILE.Put_Line(fnd_file.log, 'p_cutoff_date=' || p_cutoff_date);
78:
79: ad_parallel_updates_pkg.initialize_rowid_range(
80: ad_parallel_updates_pkg.ROWID_RANGE,
81: l_table_owner,