[Home] [Help]
PACKAGE: APPS.PQP_NL_EXT_FUNCTIONS
Source
1 PACKAGE PQP_NL_EXT_FUNCTIONS as
2 /* $Header: pqpextff.pkh 120.2 2005/10/30 21:07 vjhanak noship $ */
3
4 g_proc_name varchar2(80) := 'pqp_nl_ext_functions.';
5
6 -- ----------------------------------------------------------------------------
7 -- |---------------------< create_org_pt_ins_chg_evt >-----------------------|
8 -- ----------------------------------------------------------------------------
9 --
10 PROCEDURE create_org_pt_ins_chg_evt (p_organization_id IN number
11 ,p_org_information1 IN varchar2
12 ,p_org_information2 IN varchar2
13 ,p_org_information3 IN varchar2
14 ,p_org_information6 IN varchar2
15 ,p_effective_date IN date
16 );
17
18 -- ----------------------------------------------------------------------------
19 -- |-------------------< create_org_pt_upd_chg_evt >-------------------------|
20 -- ----------------------------------------------------------------------------
21 --
22 PROCEDURE create_org_pt_upd_chg_evt (p_organization_id number
23 ,p_org_information1 varchar2
24 ,p_org_information2 varchar2
25 ,p_org_information3 varchar2
26 ,p_org_information6 varchar2
27 ,p_org_information1_o varchar2
28 ,p_org_information2_o varchar2
29 ,p_org_information3_o varchar2
30 ,p_org_information6_o varchar2
31 ,p_effective_date date
32 );
33
34 -- ----------------------------------------------------------------------------
35 -- |------------------< create_asg_info_ins_chg_evt>---------------------------|
36 -- ----------------------------------------------------------------------------
37 --
38 PROCEDURE create_asg_info_ins_chg_evt (p_assignment_id IN NUMBER
39 ,p_assignment_extra_info_id IN NUMBER
40 ,p_aei_information1 IN VARCHAR2
41 ,p_aei_information2 IN VARCHAR2
42 ,p_aei_information3 IN VARCHAR2
43 ,p_aei_information4 IN VARCHAR2
44 ,p_effective_date IN DATE
45 ,p_abp_reporting_date IN DATE
46 ) ;
47 -- ----------------------------------------------------------------------------
48 -- |-------------------< create_asg_info_upd_chg_evt>--------------------------|
49 -- ----------------------------------------------------------------------------
50 --
51 PROCEDURE create_asg_info_upd_chg_evt (p_assignment_id IN NUMBER
52 ,p_assignment_extra_info_id IN NUMBER
53 ,p_aei_information1 IN VARCHAR2
54 ,p_aei_information2 IN VARCHAR2
55 ,p_aei_information3 IN VARCHAR2
56 ,p_aei_information4 IN VARCHAR2
57 ,p_aei_information1_o IN VARCHAR2
58 ,p_aei_information2_o IN VARCHAR2
59 ,p_effective_date IN DATE
60 ,p_abp_reporting_date IN DATE
61 );
62
63 -- ----------------------------------------------------------------------------
64 -- |---------------------< create_org_pp_ins_chg_evt >-----------------------|
65 -- ----------------------------------------------------------------------------
66 --
67 PROCEDURE create_org_pp_ins_chg_evt (p_organization_id IN number
68 ,p_org_information1 IN varchar2
69 ,p_org_information2 IN varchar2
70 ,p_org_information3 IN varchar2
71 ,p_effective_date IN date
72 );
73
74 -- ----------------------------------------------------------------------------
75 -- |-------------------< create_org_pp_upd_chg_evt >-------------------------|
76 -- ----------------------------------------------------------------------------
77 --
78 PROCEDURE create_org_pp_upd_chg_evt (p_organization_id number
79 ,p_org_information1 varchar2
80 ,p_org_information2 varchar2
81 ,p_org_information3 varchar2
82 ,p_org_information1_o varchar2
83 ,p_org_information2_o varchar2
84 ,p_org_information3_o varchar2
85 ,p_effective_date date
86 );
87
88 -- ----------------------------------------------------------------------------
89 -- |------------------< create_si_info_ins_chg_evt>---------------------------|
90 -- ----------------------------------------------------------------------------
91 --
92 PROCEDURE create_si_info_ins_chg_evt (p_assignment_id IN number
93 ,p_aei_information1 IN varchar2
94 ,p_aei_information2 IN varchar2
95 ,p_aei_information3 IN varchar2
96 ,p_effective_date IN date
97 );
98
99 -- ----------------------------------------------------------------------------
100 -- |------------------< create_si_info_upd_chg_evt>---------------------------|
101 -- ----------------------------------------------------------------------------
102 --
103 PROCEDURE create_si_info_upd_chg_evt (p_assignment_id IN number
104 ,p_aei_information1 IN varchar2
105 ,p_aei_information2 IN varchar2
106 ,p_aei_information3 IN varchar2
107 ,p_aei_information1_o IN varchar2
108 ,p_aei_information2_o IN varchar2
109 ,p_aei_information3_o IN varchar2
110 ,p_effective_date IN date
111 );
112
113 -- ----------------------------------------------------------------------------
114 -- |------------------< create_sal_info_ins_chg_evt>---------------------------|
115 -- ----------------------------------------------------------------------------
116 --
117 PROCEDURE create_sal_info_ins_chg_evt (p_assignment_id IN number
118 ,p_assignment_extra_info_id IN NUMBER
119 ,p_aei_information1 IN varchar2
120 ,p_aei_information2 IN varchar2
121 ,p_aei_information4 IN varchar2
122 ,p_aei_information5 IN varchar2
123 ,p_aei_information6 IN varchar2
124 ,p_effective_date IN date
125 ,p_abp_reporting_date IN DATE
126 );
127
128 -- ----------------------------------------------------------------------------
129 -- |-------------------< create_sal_info_upd_chg_evt>--------------------------|
130 -- ----------------------------------------------------------------------------
131 --
132 PROCEDURE create_sal_info_upd_chg_evt (p_assignment_id IN number
133 ,p_assignment_extra_info_id IN NUMBER
134 ,p_aei_information1 IN varchar2
135 ,p_aei_information2 IN varchar2
136 ,p_aei_information4 IN varchar2
137 ,p_aei_information5 IN varchar2
138 ,p_aei_information6 IN varchar2
139 ,p_aei_information1_o IN varchar2
140 ,p_aei_information2_o IN varchar2
141 ,p_aei_information4_o IN varchar2
142 ,p_aei_information5_o IN varchar2
143 ,p_aei_information6_o IN varchar2
144 ,p_effective_date IN date
145 ,p_abp_reporting_date IN DATE
146 );
147
148 END pqp_nl_ext_functions;
149 --