385: END upload_tax_ben;
386:
387: -- This procedure will take a string in which fields are delimited and break it up in its fields.
388: -- These fields together with some environment variables will be stored in a record structure
389: -- that closely matches the BEE PAY_BATCH_LINES tables (g_batch_line)
390: -- The IN Parameters are
391: -- p_line -> the line that needs to be broken up
392: -- p_session_date -> the session date
393: -- p_batch_id -> the batch id to which the line
401:
402: PROCEDURE break_up_line (
403: p_line IN VARCHAR2,
404: p_session_date IN DATE,
405: p_batch_id IN pay_batch_lines.batch_id%TYPE,
406: p_batch_seq IN pay_batch_lines.batch_sequence%TYPE,
407: p_delimiter IN VARCHAR2,
408: p_bg_id IN per_business_groups.business_group_id%TYPE,
409: p_leg_cd IN per_business_groups.legislation_code%TYPE,
402: PROCEDURE break_up_line (
403: p_line IN VARCHAR2,
404: p_session_date IN DATE,
405: p_batch_id IN pay_batch_lines.batch_id%TYPE,
406: p_batch_seq IN pay_batch_lines.batch_sequence%TYPE,
407: p_delimiter IN VARCHAR2,
408: p_bg_id IN per_business_groups.business_group_id%TYPE,
409: p_leg_cd IN per_business_groups.legislation_code%TYPE,
410: p_batch_line OUT NOCOPY g_batch_line