1160:
1161: PROCEDURE gen_body_xml
1162: IS
1163: l_string varchar2(32767) := NULL;
1164: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1165: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1166:
1167: CURSOR c_action_information(c_action_type VARCHAR2, c_asg_act_id NUMBER) IS
1168: SELECT
1161: PROCEDURE gen_body_xml
1162: IS
1163: l_string varchar2(32767) := NULL;
1164: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1165: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1166:
1167: CURSOR c_action_information(c_action_type VARCHAR2, c_asg_act_id NUMBER) IS
1168: SELECT
1169: action_information6 form_type,
1273: -----------------------------------------------------------------------
1274: PROCEDURE gen_header_xml
1275: IS
1276: l_string varchar2(32767) := NULL;
1277: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1278: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1279:
1280: l_proc VARCHAR2(100);
1281: l_buf VARCHAR2(2000);
1274: PROCEDURE gen_header_xml
1275: IS
1276: l_string varchar2(32767) := NULL;
1277: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
1278: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1279:
1280: l_proc VARCHAR2(100);
1281: l_buf VARCHAR2(2000);
1282: