PACKAGE: APPS.PAY_JP_ISDF_RPT

Source

1 PACKAGE PAY_JP_ISDF_RPT AS
2 /* $Header: pyjpisrp.pkh 120.6.12000000.2 2007/09/20 02:36:16 keyazawa noship $ */
3 --
4   g_msg_circle fnd_new_messages.message_text%type;
5 --
6   TYPE XMLRec IS RECORD(xmlstring VARCHAR2(4000));
7   TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
8 --
9   vXMLTable tXMLTable;
10 --
11   level_cnt      NUMBER;
12 --
13   cursor c_header
14   is
15   select 1
16   from dual ;
17 --
18   cursor c_footer
19   is
20   select 1
21   from dual ;
22 --
23   cursor eof
24   is
25   select 1
26   from dual ;
27 --
28   cursor c_body
29   is
30   select 'TRANSFER_ACT_ID=P',
31          assignment_action_id
32   from   pay_assignment_actions
33   where payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
34 --
35 FUNCTION chk_ass_set(
36   p_assignment_id     IN NUMBER,
37   p_assignment_set_id IN NUMBER,
38   p_formula_id        IN NUMBER,
39   p_effective_date    IN DATE,
40   p_dummy             IN NUMBER) RETURN BOOLEAN;
41 --
42 FUNCTION get_amendment_flag(
43   p_assignment_id     IN NUMBER,
44   p_assignment_set_id IN NUMBER) RETURN VARCHAR2;
45 --
46 FUNCTION chk_ass_set_mixed(
47   p_assignment_set_id IN NUMBER) RETURN NUMBER;
48 --
49 FUNCTION chk_all_exclusions(
50   p_assignment_set_id IN NUMBER) RETURN NUMBER;
51 --
52 PROCEDURE range_cursor(
53   P_PAYROLL_ACTION_ID number,
54   P_SQLSTR            OUT NOCOPY varchar2);
55 --
56 PROCEDURE action_creation(
57   P_PAYROLL_ACTION_ID number,
58   P_START_PERSON_ID   number,
59   P_END_PERSON_ID     number,
60   P_CHUNK             number);
61 --
62 PROCEDURE gen_xml_header;
63 --
64 PROCEDURE generate_xml;
65 --
66 PROCEDURE PRINT_CLOB(p_clob IN CLOB);
67 --
68 PROCEDURE gen_xml_footer;
69 --
70 PROCEDURE init_code(P_PAYROLL_ACTION_ID IN  NUMBER) ;
71 --
72 PROCEDURE archive_code(
73   P_ASSIGNMENT_ACTION_ID IN NUMBER,
74   P_EFFECTIVE_DATE       IN DATE) ;
75 --
76 PROCEDURE assact_xml(p_assignment_action_id IN NUMBER);
77 --
78 PROCEDURE get_ss_xml(
79   p_assignment_action_id IN  NUMBER,
80   p_xml                  OUT NOCOPY CLOB);
81 --
82 PROCEDURE get_cp_xml(
83   p_assignment_action_id IN  NUMBER,
84   p_xml                  OUT NOCOPY CLOB);
85 --
86 PROCEDURE WritetoCLOB(p_write_xml OUT NOCOPY CLOB);
87 --
88 FUNCTION submit_report(
89   p_pact_id   IN NUMBER,
90   p_assset_id IN NUMBER,
91   p_eff_date  IN VARCHAR2) return number;
92 --
93 END PAY_JP_ISDF_RPT;