DBA Data[Home] [Help]

APPS.PAY_MAG_TAPE dependencies on PAY_MAG_TAPE

Line 1: package body pay_mag_tape as

1: package body pay_mag_tape as
2: /* $Header: pymagtpe.pkb 120.8.12010000.1 2008/07/27 23:09:00 appldev ship $ */
3: procedure run_proc(comm in varchar2)
4: is
5: sql_curs number;

Line 46: p_file_id => pay_mag_tape.g_blob_file_id

42: p_file_location => file_name,
43: p_file_type => 'XML',
44: p_int_file_name => 'MAGFILE',
45: p_sequence => sequence,
46: p_file_id => pay_mag_tape.g_blob_file_id
47: );
48:
49: select blob_file_fragment
50: into g_blob_value

Line 52: where file_detail_id = pay_mag_tape.g_blob_file_id;

48:
49: select blob_file_fragment
50: into g_blob_value
51: from pay_file_details
52: where file_detail_id = pay_mag_tape.g_blob_file_id;
53:
54: statem := 'BEGIN '||comm||'; END;';
55: sql_curs := dbms_sql.open_cursor;
56: dbms_sql.parse(sql_curs,

Line 62: pay_core_files.close_file ( p_file_id => pay_mag_tape.g_blob_file_id);

58: dbms_sql.v7);
59: rows_processed := dbms_sql.execute(sql_curs);
60: dbms_sql.close_cursor(sql_curs);
61:
62: pay_core_files.close_file ( p_file_id => pay_mag_tape.g_blob_file_id);
63:
64: end;
65:
66:

Line 122: end pay_mag_tape;

118: EXCEPTION
119: WHEN NO_DATA_FOUND THEN
120: return;
121: end;
122: end pay_mag_tape;