DBA Data[Home] [Help]

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_MAG_TAPE

Line 110: pay_mag_tape.g_blob_value

106:
107: /****************************************************************************
108: Name : WRITE_TO_MAGTAPE_LOB
109: Description : This procedure appends passed BLOB parameter to
110: pay_mag_tape.g_blob_value
111: *****************************************************************************/
112:
113: PROCEDURE WRITE_TO_MAGTAPE_LOB(p_blob BLOB) IS
114: BEGIN

Line 124: pay_mag_tape.g_blob_value

120:
121: /****************************************************************************
122: Name : WRITE_TO_MAGTAPE_LOB
123: Description : This procedure appends passed varchar2 parameter to
124: pay_mag_tape.g_blob_value
125: *****************************************************************************/
126:
127: PROCEDURE WRITE_TO_MAGTAPE_LOB(p_data varchar2) IS
128: BEGIN

Line 136: format and appends to pay_mag_tape.g_blob_value.

132:
133: /****************************************************************************
134: Name : GENERATE_XML
135: Description : This procedure fetches archived data, converts it to XML
136: format and appends to pay_mag_tape.g_blob_value.
137: *****************************************************************************/
138: PROCEDURE GENERATE_XML AS
139:
140: CURSOR get_person_bank_details(p_per_pay_method NUMBER,

Line 395: print_blob (pay_mag_tape.g_blob_value);

391: dbms_lob.freeTemporary(l_xml);
392:
393: hr_utility_trace ('BLOB contents for assignment action '||
394: ln_assignment_action_id);
395: print_blob (pay_mag_tape.g_blob_value);
396:
397: hr_utility_trace ('Leaving '||l_proc_name);
398: END GENERATE_XML;
399:

Line 404: pay_mag_tape.g_blob_value.

400:
401: /****************************************************************************
402: Name : GEN_XML_HEADER
403: Description : This procedure generates XML header information and appends to
404: pay_mag_tape.g_blob_value.
405: *****************************************************************************/
406: PROCEDURE GET_HEADERS AS
407: l_proc_name varchar2(100);
408: lv_buf varchar2(2000);

Line 421: print_blob (pay_mag_tape.g_blob_value);

417:
418: write_to_magtape_lob (lv_buf);
419:
420: hr_utility_trace ('BLOB contents after appending header information');
421: print_blob (pay_mag_tape.g_blob_value);
422:
423: hr_utility_trace ('Leaving '||l_proc_name);
424: END GET_HEADERS;
425:

Line 431: pay_mag_tape.g_blob_value.

427:
428: /****************************************************************************
429: Name : GEN_EMPLOYER_LEVEL_XML
430: Description : This procedure generates XML header information and appends to
431: pay_mag_tape.g_blob_value.
432: *****************************************************************************/
433: PROCEDURE get_deposit_header AS
434: l_proc_name varchar2(100);
435: lv_buf varchar2(2000);

Line 609: print_blob (pay_mag_tape.g_blob_value);

605:
606:
607:
608: hr_utility_trace ('BLOB contents after appending header information');
609: print_blob (pay_mag_tape.g_blob_value);
610:
611: hr_utility_trace ('Leaving '||l_proc_name);
612: END get_deposit_header;
613:

Line 618: pay_mag_tape.g_blob_value.

614: /****************************************************************************
615: Name : GEN_XML_FOOTER
616: Description : This procedure generates XML information for GRE and the final
617: closing tag. Final result is appended to
618: pay_mag_tape.g_blob_value.
619: *****************************************************************************/
620: PROCEDURE get_deposit_footer AS
621: lv_buf varchar2(2000);
622: l_proc_name varchar2(200);

Line 632: print_blob (pay_mag_tape.g_blob_value);

628:
629: write_to_magtape_lob (lv_buf);
630:
631: hr_utility_trace ('BLOB contents after appending footer information');
632: print_blob (pay_mag_tape.g_blob_value);
633:
634: hr_utility_trace ('Leaving '||l_proc_name);
635: END get_deposit_footer;
636:

Line 649: print_blob (pay_mag_tape.g_blob_value);

645:
646: write_to_magtape_lob (lv_buf);
647:
648: hr_utility_trace ('BLOB contents after appending footer information');
649: print_blob (pay_mag_tape.g_blob_value);
650:
651: hr_utility_trace ('Leaving '||l_proc_name);
652: END GET_FOOTERS;
653: