DBA Data[Home] [Help]

APPS.PAY_JP_MAGTAPE_PKG dependencies on PAY_JP_MAGTAPE_PKG

Line 1: package body pay_jp_magtape_pkg as

1: package body pay_jp_magtape_pkg as
2: /* $Header: payjpmag.pkb 120.0 2005/05/29 02:37:56 appldev noship $ */
3: --
4: -- Global variables and Constants.
5: --

Line 11: g_package_name varchar2(30) := 'pay_jp_magtape_pkg';

7: g_header_sql varchar2(2000);
8: g_data_sql varchar2(2000);
9: g_trailer_sql varchar2(2000);
10: g_end_sql varchar2(2000);
11: g_package_name varchar2(30) := 'pay_jp_magtape_pkg';
12: c_default_package_name constant varchar2(30) := 'pay_jp_magtape_format_pkg';
13: --------------------------------------------------------------------------------
14: -- This function returns latest request_id for specified payroll_action_id.
15: --------------------------------------------------------------------------------

Line 87: l_data pay_jp_magtape_pkg.header;

83: g_character_set := p_character_set;
84: --
85: g_header_sql :=
86: 'declare
87: l_data pay_jp_magtape_pkg.header;
88: begin
89: l_data.org_payment_method_id := :v1;
90: l_data.transaction_type := :v2;
91: l_data.character_set_code := :v3;

Line 110: l_data pay_jp_magtape_pkg.data;

106: end;';
107: --
108: g_data_sql :=
109: 'declare
110: l_data pay_jp_magtape_pkg.data;
111: begin
112: l_data.person_id := :v1;
113: l_data.employee_number := :v2;
114: l_data.external_account_id := :v3;

Line 130: l_data pay_jp_magtape_pkg.trailer;

126: end;';
127: --
128: g_trailer_sql :=
129: 'declare
130: l_data pay_jp_magtape_pkg.trailer;
131: begin
132: l_data.total_count := :v1;
133: l_data.total_payment := :v2;
134: :v3 := ' || l_package_name || '.trailer_record(l_data);

Line 429: end pay_jp_magtape_pkg;

425: fnd_message.set_token('SQL',g_end_sql);
426: fnd_message.raise_error;
427: end end_record;
428: --
429: end pay_jp_magtape_pkg;