APPS.PAY_AUD_BUS dependencies on PAY_STAT_TRANS_AUDIT

Line 21: (p_person_id in pay_stat_trans_audit.person_id%TYPE

17: -- |--------------------------< chk_person_id >------------------------------|
18: -- ---------------------------------------------------------------------------
19: --
20: procedure chk_person_id
21: (p_person_id in pay_stat_trans_audit.person_id%TYPE
22: ,p_business_group_id in pay_stat_trans_audit.business_group_id%TYPE
23: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
24: )
25: is

Line 22: ,p_business_group_id in pay_stat_trans_audit.business_group_id%TYPE

18: -- ---------------------------------------------------------------------------
19: --
20: procedure chk_person_id
21: (p_person_id in pay_stat_trans_audit.person_id%TYPE
22: ,p_business_group_id in pay_stat_trans_audit.business_group_id%TYPE
23: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
24: )
25: is
26: --

Line 23: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE

19: --
20: procedure chk_person_id
21: (p_person_id in pay_stat_trans_audit.person_id%TYPE
22: ,p_business_group_id in pay_stat_trans_audit.business_group_id%TYPE
23: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
24: )
25: is
26: --
27: l_exists varchar2(1);

Line 95: (p_assignment_id in pay_stat_trans_audit.assignment_id%TYPE

91: -- Access Status
92: -- Internal table handler use only.
93: --
94: Procedure chk_assignment_id
95: (p_assignment_id in pay_stat_trans_audit.assignment_id%TYPE
96: ,p_business_group_id in pay_stat_trans_audit.business_group_id%TYPE
97: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
98: ) is
99: --

Line 96: ,p_business_group_id in pay_stat_trans_audit.business_group_id%TYPE

92: -- Internal table handler use only.
93: --
94: Procedure chk_assignment_id
95: (p_assignment_id in pay_stat_trans_audit.assignment_id%TYPE
96: ,p_business_group_id in pay_stat_trans_audit.business_group_id%TYPE
97: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
98: ) is
99: --
100: l_proc varchar2(72) := g_package||'chk_assignment_id';

Line 97: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE

93: --
94: Procedure chk_assignment_id
95: (p_assignment_id in pay_stat_trans_audit.assignment_id%TYPE
96: ,p_business_group_id in pay_stat_trans_audit.business_group_id%TYPE
97: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
98: ) is
99: --
100: l_proc varchar2(72) := g_package||'chk_assignment_id';
101: l_dummy varchar2(1);

Line 162: (p_source in pay_stat_trans_audit.source1%TYPE

158: -- |--------------------------< chk_source >------------------------------|
159: -- ---------------------------------------------------------------------------
160: --
161: procedure chk_source
162: (p_source in pay_stat_trans_audit.source1%TYPE
163: ,p_source_type in pay_stat_trans_audit.source1_type%TYPE
164: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
165: )
166: is

Line 163: ,p_source_type in pay_stat_trans_audit.source1_type%TYPE

159: -- ---------------------------------------------------------------------------
160: --
161: procedure chk_source
162: (p_source in pay_stat_trans_audit.source1%TYPE
163: ,p_source_type in pay_stat_trans_audit.source1_type%TYPE
164: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
165: )
166: is
167: --

Line 164: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE

160: --
161: procedure chk_source
162: (p_source in pay_stat_trans_audit.source1%TYPE
163: ,p_source_type in pay_stat_trans_audit.source1_type%TYPE
164: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
165: )
166: is
167: --
168: l_proc varchar2(72) := g_package||'chk_source';

Line 208: (p_transaction_type in pay_stat_trans_audit.transaction_type%TYPE

204: -- |--------------------------< chk_transaction_type>------------------------|
205: -- ---------------------------------------------------------------------------
206: --
207: procedure chk_transaction_type
208: (p_transaction_type in pay_stat_trans_audit.transaction_type%TYPE
209: ,p_transaction_subtype in pay_stat_trans_audit.transaction_subtype%TYPE
210: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
211: )
212: is

Line 209: ,p_transaction_subtype in pay_stat_trans_audit.transaction_subtype%TYPE

205: -- ---------------------------------------------------------------------------
206: --
207: procedure chk_transaction_type
208: (p_transaction_type in pay_stat_trans_audit.transaction_type%TYPE
209: ,p_transaction_subtype in pay_stat_trans_audit.transaction_subtype%TYPE
210: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
211: )
212: is
213: --

Line 210: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE

206: --
207: procedure chk_transaction_type
208: (p_transaction_type in pay_stat_trans_audit.transaction_type%TYPE
209: ,p_transaction_subtype in pay_stat_trans_audit.transaction_subtype%TYPE
210: ,p_effective_date in pay_stat_trans_audit.transaction_effective_date%TYPE
211: )
212: is
213: --
214: l_proc varchar2(72) := g_package||'chk_transaction_type';

Line 272: , pay_stat_trans_audit aud

268: --
269: cursor csr_leg_code is
270: select pbg.legislation_code
271: from per_business_groups pbg
272: , pay_stat_trans_audit aud
273: where aud.stat_trans_audit_id = p_stat_trans_audit_id
274: and pbg.business_group_id = aud.business_group_id;
275: --
276: -- Declare local variables

Line 370: ,p_descflex_name => 'PAY_STAT_TRANS_AUDIT_DDF'

366: hr_utility.set_location('Entering:'||l_proc,10);
367: --
368: hr_dflex_utility.ins_or_upd_descflex_attribs
369: (p_appl_short_name => 'PAY'
370: ,p_descflex_name => 'PAY_STAT_TRANS_AUDIT_DDF'
371: ,p_attribute_category => p_rec.audit_information_category
372: ,p_attribute1_name => 'AUDIT_INFORMATION1'
373: ,p_attribute1_value => p_rec.audit_information1
374: ,p_attribute2_name => 'AUDIT_INFORMATION2'