APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_FILE_DETAILS

Line 2035: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;

2031:
2032: PROCEDURE gen_body_xml
2033: IS
2034: l_string varchar2(32767) := NULL;
2035: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2036: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2037:
2038: l_person_id per_all_people_f.person_id%TYPE;
2039: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 2036: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;

2032: PROCEDURE gen_body_xml
2033: IS
2034: l_string varchar2(32767) := NULL;
2035: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2036: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2037:
2038: l_person_id per_all_people_f.person_id%TYPE;
2039: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2040: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

Line 2093: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;

2089: -----------------------------------------------------------------------
2090: PROCEDURE gen_header_xml
2091: IS
2092: l_string varchar2(32767) := NULL;
2093: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2094: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2095:
2096: l_proc VARCHAR2(100);
2097: l_buf VARCHAR2(2000);

Line 2094: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;

2090: PROCEDURE gen_header_xml
2091: IS
2092: l_string varchar2(32767) := NULL;
2093: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2094: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2095:
2096: l_proc VARCHAR2(100);
2097: l_buf VARCHAR2(2000);
2098:

Line 2189: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;

2185: -----------------------------------------------------------------------
2186: PROCEDURE gen_footer_xml
2187: IS
2188: l_string varchar2(32767) := NULL;
2189: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2190: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2191: l_buf VARCHAR2(2000);
2192: l_proc VARCHAR2(100);
2193:

Line 2190: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;

2186: PROCEDURE gen_footer_xml
2187: IS
2188: l_string varchar2(32767) := NULL;
2189: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2190: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2191: l_buf VARCHAR2(2000);
2192: l_proc VARCHAR2(100);
2193:
2194: CURSOR cur_get_totals (c_pact_id NUMBER)