1 package pay_jp_magtape_pkg as
2 /* $Header: payjpmag.pkh 120.0 2005/05/29 02:38:04 appldev noship $ */
3 --
4 -- TYPE definitions.
5 --
6 type header is record(
7 org_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE,
8 transaction_type hr_lookups.lookup_code%TYPE,
9 character_set_code hr_lookups.lookup_code%TYPE,
10 direct_deposit_date pay_payroll_actions.overriding_dd_date%TYPE,
11 company_code pay_org_payment_methods_f.pmeth_information1%TYPE,
12 company_name pay_org_payment_methods_f.pmeth_information2%TYPE,
13 external_account_id pay_external_accounts.external_account_id%TYPE,
14 bank_code pay_jp_banks.bank_code%TYPE,
15 bank_name_kana pay_jp_banks.bank_name_kana%TYPE,
16 branch_code pay_jp_bank_branches.branch_code%TYPE,
17 branch_name_kana pay_jp_bank_branches.branch_name_kana%TYPE,
18 account_type pay_external_accounts.segment7%TYPE,
19 account_number pay_external_accounts.segment8%TYPE,
20 account_name pay_external_accounts.segment9%TYPE,
21 description1 pay_external_accounts.segment10%TYPE,
22 description2 pay_external_accounts.segment11%TYPE);
23 type data is record(
24 person_id per_all_people_f.person_id%TYPE,
25 employee_number per_all_people_f.employee_number%TYPE,
26 external_account_id pay_external_accounts.external_account_id%TYPE,
27 bank_code pay_jp_banks.bank_code%TYPE,
28 bank_name_kana pay_jp_banks.bank_name_kana%TYPE,
29 branch_code pay_jp_bank_branches.branch_code%TYPE,
30 branch_name_kana pay_jp_bank_branches.branch_name_kana%TYPE,
31 account_type pay_external_accounts.segment7%TYPE,
32 account_number pay_external_accounts.segment8%TYPE,
33 account_name pay_external_accounts.segment9%TYPE,
34 description1 pay_external_accounts.segment10%TYPE,
35 description2 pay_external_accounts.segment11%TYPE,
36 payment number);
37 type trailer is record(
38 total_count number,
39 total_payment number);
40 --
41 function latest_request_id(
42 p_payroll_action_id in number) return number;
43 function show_sql(
44 p_record_type in varchar2) return varchar2;
45 --
46 -- Changed to return converted characters because of Reports'
47 -- convert function bug.
48 -- When running Reports, user have to run in the environment
49 -- without character conversion, that is, nls_characterset
50 -- must always be the same as DB characterset.
51 -- But user do not have to care about this because Reports runs
52 -- by Concurrent Manager whose nls_characterset is always be the
53 -- same as DB characterset.
54 --
55 procedure init(
56 p_package_name in varchar2,
57 p_character_set in varchar2);
58 function header_record(
59 p_org_payment_method_id in number,
60 p_transaction_type in varchar2,
61 p_character_set_code in varchar2,
62 p_direct_deposit_date in date,
63 p_company_code in varchar2,
64 p_company_name in varchar2,
65 p_external_account_id in number,
66 p_bank_code in varchar2,
67 p_bank_name_kana in varchar2,
68 p_branch_code in varchar2,
69 p_branch_name_kana in varchar2,
70 p_account_type in varchar2,
71 p_account_number in varchar2,
72 p_account_name in varchar2,
73 p_description1 in varchar2,
74 p_description2 in varchar2) return varchar2;
75 function data_record(
76 p_person_id in number,
77 p_employee_number in varchar2,
78 p_external_account_id in number,
79 p_bank_code in varchar2,
80 p_bank_name_kana in varchar2,
81 p_branch_code in varchar2,
82 p_branch_name_kana in varchar2,
83 p_account_type in varchar2,
84 p_account_number in varchar2,
85 p_account_name in varchar2,
86 p_description1 in varchar2,
87 p_description2 in varchar2,
88 p_payment in number) return varchar2;
89 function trailer_record(
90 p_total_count in number,
91 p_total_payment in number) return varchar2;
92 function end_record return varchar2;
93 --
94 end pay_jp_magtape_pkg;