DBA Data[Home] [Help]

APPS.PAY_IE_P45PART3_P46_PKG dependencies on PAY_FILE_DETAILS

Line 1164: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;

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

Line 1165: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;

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,

Line 1277: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%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);

Line 1278: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;

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: