[Home] [Help]
PACKAGE: APPS.PAY_NAF_SHD
Source
1 PACKAGE pay_naf_shd
2 /* $Header: pynafrhi.pkh 120.1.12020000.1 2012/08/14 09:09:16 achandwa noship $ */
3 as
4 TYPE g_rec_type IS RECORD (transfer_id number(9)
5 ,transfer_status varchar2(30)
6 ,concurrent_request_id number(15)
7 ,payroll_action_id number(9)
8 ,report_name varchar2(100)
9 ,run_effective_date date
10 ,shipment_reference varchar2(100)
11 ,organization_id number(15)
12 ,business_group_id number(15)
13 ,receipt_id number(15)
14 ,receipt_status varchar2(100)
15 ,receipt_text varchar2(200)
16 ,receipt_last_updated date
17 ,alt_element_id number(9)
18 ,alt_archive_ref varchar2(30)
19 ,curr_state varchar2(20)
20 ,next_state varchar2(20)
21 ,object_version_number number(9)
22 ,tfr_information_category varchar2(150)
23 ,tfr_information1 varchar2(150)
24 ,tfr_information2 varchar2(150)
25 ,tfr_information3 varchar2(150)
26 ,tfr_information4 varchar2(150)
27 ,tfr_information5 varchar2(150)
28 ,tfr_information6 varchar2(150)
29 ,tfr_information7 varchar2(150)
30 ,tfr_information8 varchar2(150)
31 ,tfr_information9 varchar2(150)
32 ,tfr_information10 varchar2(150)
33 ,tfr_information11 varchar2(150)
34 ,tfr_information12 varchar2(150)
35 ,tfr_information13 varchar2(150)
36 ,tfr_information14 varchar2(150)
37 ,tfr_information15 varchar2(150)
38 ,tfr_information16 varchar2(150)
39 ,tfr_information17 varchar2(150)
40 ,tfr_information18 varchar2(150)
41 ,tfr_information19 varchar2(150)
42 ,tfr_information20 varchar2(150));
43
44 g_old_rec g_rec_type;
45
46 g_api_dml boolean;
47
48 FUNCTION return_api_dml_status RETURN boolean;
49
50 PROCEDURE constraint_error
51 (p_constraint_name IN all_constraints.constraint_name%TYPE);
52
53 FUNCTION api_updating
54 (p_transfer_id IN number
55 ,p_object_version_number IN number) RETURN boolean;
56
57 PROCEDURE lck
58 (p_transfer_id IN number
59 ,p_object_version_number IN number);
60
61 FUNCTION convert_args
62 (p_transfer_id IN number
63 ,p_transfer_status IN varchar2
64 ,p_concurrent_request_id IN number
65 ,p_payroll_action_id IN number
66 ,p_report_name IN varchar2
67 ,p_run_effective_date IN date
68 ,p_shipment_reference_number IN varchar2
69 ,p_organization_id IN number
70 ,p_business_group_id IN number
71 ,p_reciept_id IN number
72 ,p_reciept_status IN varchar2
73 ,p_reciept_text IN varchar2
74 ,p_receipt_last_updated IN varchar2
75 ,p_alt_element_id IN number
76 ,p_alt_archive_ref IN varchar2
77 ,p_curr_state IN varchar2
78 ,p_next_state IN varchar2
79 ,p_object_version_number IN number
80 ,p_tfr_information_category IN varchar2
81 ,p_tfr_information1 IN varchar2
82 ,p_tfr_information2 IN varchar2
83 ,p_tfr_information3 IN varchar2
84 ,p_tfr_information4 IN varchar2
85 ,p_tfr_information5 IN varchar2
86 ,p_tfr_information6 IN varchar2
87 ,p_tfr_information7 IN varchar2
88 ,p_tfr_information8 IN varchar2
89 ,p_tfr_information9 IN varchar2
90 ,p_tfr_information10 IN varchar2
91 ,p_tfr_information11 IN varchar2
92 ,p_tfr_information12 IN varchar2
93 ,p_tfr_information13 IN varchar2
94 ,p_tfr_information14 IN varchar2
95 ,p_tfr_information15 IN varchar2
96 ,p_tfr_information16 IN varchar2
97 ,p_tfr_information17 IN varchar2
98 ,p_tfr_information18 IN varchar2
99 ,p_tfr_information19 IN varchar2
100 ,p_tfr_information20 IN varchar2) RETURN g_rec_type;
101 END pay_naf_shd;