1 PACKAGE IGS_EN_NSC_PKG AS
2 /* $Header: IGSEN87S.pls 120.0 2005/06/01 15:28:29 appldev noship $ */
3
4
5 /*
6 This is the main procedure which creates the snapshots
7 and stores it in the EDS. Also it submits the concurrent
8 process which prints the data into the text file.
9 */
10
11 PROCEDURE Create_Snapshot_Request(
12 errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
13 retcode OUT NOCOPY NUMBER , -- Request standard return status
14 p_comment IN VARCHAR2, -- Runtime Comments
15 p_school_id IN VARCHAR2, -- School code
16 p_branch_id IN VARCHAR2, -- Branch code
17 p_cal_inst_id IN VARCHAR2, -- Calendar instance concatenated ID
18 p_std_rep_flag IN VARCHAR2, -- Standard report flag
19 p_dummy IN VARCHAR2, -- Dummy parameter
20 p_non_std_rpt_typ IN VARCHAR2, -- Non Standard report type like GRADUATE
21 p_prev_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Previous snapshot Id (if any)
22 p_dirpath IN VARCHAR2, -- Output directory name
23 p_file_name IN VARCHAR2, -- Output file name
24 p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
25 );
26
27
28
29 /*
30 This is the main procedure which prints the data into the text file.
31 Its called from the concurent request form or from the Create_Snapshot procedure.
32 */
33
34 PROCEDURE Print_Snapshot_Request (
35 errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
36 retcode OUT NOCOPY NUMBER , -- Request standard return status
37 p_comment IN VARCHAR2, -- Runtime comments
38 p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE, -- Snapshot Id to create a file
39 p_dirpath IN VARCHAR2, -- Output directory name
40 p_file_name IN VARCHAR2, -- Output file name
41 p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
42 );
43
44
45
46 /*
47 This is the procedure which deletes the snapshot from the database.
48 */
49
50 PROCEDURE Delete_Snapshot_Request (
51 errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
52 retcode OUT NOCOPY NUMBER , -- Request standard return status
53 p_comment IN VARCHAR2, -- Runtime comments
54 p_inst_id IN igs_en_doc_instances.doc_inst_id%TYPE , -- Snapshot Id to delete
55 p_debug_mode IN VARCHAR2 := FND_API.G_FALSE
56 );
57
58 FUNCTION org_alt_check (p_org_id VARCHAR2 )
59 RETURN VARCHAR2;
60
61 END IGS_EN_NSC_PKG;