1 Package hr_applicant_dataupd AUTHID CURRENT_USER as
2 /* $Header: hraplupd.pkh 120.0 2005/05/30 22:43 appldev noship $ */
3
4 -- --------------------------------------------------------------------------+
5 -- --------------------< ConvertToApplicant >--------------------------------|
6 -- --------------------------------------------------------------------------+
7 -- Description:
8 -- This procedure converts person into applicant whenever if finds active
9 -- applicant assignments opened and the application has a termination date.
10 --
11 PROCEDURE ConvertToApplicant(p_start_rowid IN rowid
12 ,p_end_rowid IN rowid
13 ,p_rows_processed OUT nocopy number);
14
15 -- --------------------------------------------------------------------------+
16 -- -----------------< Update_APL_using_LTU >---------------------------------|
17 -- --------------------------------------------------------------------------+
18 --
19 PROCEDURE Update_APL_using_LTU
20 (errbuf OUT nocopy varchar2
21 ,retcode OUT nocopy number
22 ,p_this_worker IN number
23 ,p_total_workers IN number
24 ,p_table_owner IN varchar2
25 ,p_table_name IN varchar2
26 ,p_update_name IN varchar2
27 ,p_batchsize IN number);
28
29 -- --------------------------------------------------------------------------+
30 -- Update_APL_inCM
31 -- --------------------------------------------------------------------------+
32 -- This is run as a concurrent program
33 --
34 PROCEDURE Update_APL_inCM_Manager
35 (p_errbuf out nocopy varchar2
36 ,p_retcode out nocopy varchar2
37 ,X_batch_size in number
38 ,X_Num_Workers in number
39 ,p_process_All in varchar2
40 ,p_caller in varchar2
41 ,p_apl_id in number default 0 -- if prm is optional in SRS def,
42 -- then we need a default value here
43 );
44
45 PROCEDURE Update_APL_inCM_Worker
46 (p_errbuf out nocopy varchar2
47 ,p_retcode out nocopy varchar2
48 ,X_batch_size in number
49 ,X_Worker_Id in number
50 ,X_Num_Workers in number
51 ,p_process_All in varchar2
52 ,p_caller in varchar2
53 ,p_updateName in varchar2
54 ,p_apl_id in number default 0 -- if prm is optional in SRS def,
55 -- then we need a default value here
56 );
57
58 -- --------------------------------------------------------------------------+
59 -- ValidateRun
60 -- --------------------------------------------------------------------------+
61 -- Returns 'TRUE' if process has been run otherwise 'FALSE'
62 --
63 PROCEDURE ValidateRun(p_result OUT nocopy varchar2);
64 -- --------------------------------------------------------------------------+
65 -- RunUpdateMode
66 -- --------------------------------------------------------------------------+
67 -- Returns the value of the profile option:
68 -- + P: run within adpatch
69 -- + D: run when concurrent program is re-started (deferred process)
70 -- If profile value is not set, then returns "ADPATCH"
71 --
72 FUNCTION RunUpdateMode RETURN varchar2;
73 --
74 -- --------------------------------------------------------------------------+
75 -- isADPATCHMode
76 -- --------------------------------------------------------------------------+
77 FUNCTION isADPATCHMode return boolean;
78 --
79 -- --------------------------------------------------------------------------+
80 -- isDEFERMode
81 -- --------------------------------------------------------------------------+
82 FUNCTION isDEFERMode return boolean;
83 --
84 --
85 end hr_applicant_dataupd;
[Home] [Help]