APPS.PAY_NO_EERR_CONTINUOUS dependencies on DBMS_LOB

Line 3325: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);

3321: l_str14 := '';
3322: l_str15 := '';
3323: l_str16 := '';
3324: l_str17 := '';
3325: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);
3326: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
3327: current_index := 0;
3328:
3329: if xml_tab.count > 0 then

Line 3326: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);

3322: l_str15 := '';
3323: l_str16 := '';
3324: l_str17 := '';
3325: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);
3326: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
3327: current_index := 0;
3328:
3329: if xml_tab.count > 0 then
3330: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);

Line 3330: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);

3326: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
3327: current_index := 0;
3328:
3329: if xml_tab.count > 0 then
3330: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);
3331: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);
3332:
3333: for table_counter in xml_tab.first .. xml_tab.last
3334: loop

Line 3331: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);

3327: current_index := 0;
3328:
3329: if xml_tab.count > 0 then
3330: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);
3331: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);
3332:
3333: for table_counter in xml_tab.first .. xml_tab.last
3334: loop
3335: l_str8 := xml_tab (table_counter).tagname;

Line 3339: dbms_lob.writeappend (

3335: l_str8 := xml_tab (table_counter).tagname;
3336: l_str9 := xml_tab (table_counter).tagvalue;
3337:
3338: if l_str8 = 'LEGAL_EMPLOYER_NAME' then
3339: dbms_lob.writeappend (
3340: l_xfdf_string,
3341: length (l_str14),
3342: l_str14
3343: );

Line 3345: dbms_lob.writeappend (

3341: length (l_str14),
3342: l_str14
3343: );
3344: elsif l_str8 = 'EMPLOYEE_NUMBER' then
3345: dbms_lob.writeappend (
3346: l_xfdf_string,
3347: length (l_str16),
3348: l_str16
3349: );

Line 3353: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);

3349: );
3350: end if;
3351:
3352: if l_str9 is not null then
3353: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3354: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3355: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3356: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3357: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);

Line 3354: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

3350: end if;
3351:
3352: if l_str9 is not null then
3353: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3354: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3355: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3356: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3357: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3358: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

Line 3355: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);

3351:
3352: if l_str9 is not null then
3353: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3354: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3355: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3356: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3357: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3358: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3359: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

Line 3356: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);

3352: if l_str9 is not null then
3353: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3354: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3355: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3356: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3357: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3358: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3359: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3360: else

Line 3357: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);

3353: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3354: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3355: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3356: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3357: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3358: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3359: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3360: else
3361: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);

Line 3358: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

3354: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3355: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3356: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3357: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3358: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3359: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3360: else
3361: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3362: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

Line 3359: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

3355: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3356: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3357: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3358: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3359: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3360: else
3361: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3362: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3363: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);

Line 3361: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);

3357: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3358: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3359: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3360: else
3361: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3362: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3363: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3364: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3365: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

Line 3362: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

3358: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3359: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3360: else
3361: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3362: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3363: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3364: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3365: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3366: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

Line 3363: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);

3359: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3360: else
3361: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3362: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3363: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3364: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3365: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3366: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3367: end if;

Line 3364: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);

3360: else
3361: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3362: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3363: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3364: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3365: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3366: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3367: end if;
3368:

Line 3365: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

3361: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3362: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3363: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3364: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3365: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3366: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3367: end if;
3368:
3369: if l_str8 = 'JOB_CHANGE_DATE' then

Line 3366: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

3362: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3363: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3364: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3365: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3366: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3367: end if;
3368:
3369: if l_str8 = 'JOB_CHANGE_DATE' then
3370: dbms_lob.writeappend (

Line 3370: dbms_lob.writeappend (

3366: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3367: end if;
3368:
3369: if l_str8 = 'JOB_CHANGE_DATE' then
3370: dbms_lob.writeappend (
3371: l_xfdf_string,
3372: length (l_str17),
3373: l_str17
3374: );

Line 3378: dbms_lob.writeappend (

3374: );
3375:
3376: if xml_tab.last = table_counter
3377: or xml_tab (table_counter + 1).tagname <> 'EMPLOYEE_NUMBER' then
3378: dbms_lob.writeappend (
3379: l_xfdf_string,
3380: length (l_str15),
3381: l_str15
3382: );

Line 3387: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);

3383: end if;
3384: end if;
3385: end loop;
3386:
3387: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
3388: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
3389: else
3390: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
3391: end if;

Line 3388: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);

3384: end if;
3385: end loop;
3386:
3387: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
3388: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
3389: else
3390: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
3391: end if;
3392:

Line 3390: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);

3386:
3387: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
3388: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
3389: else
3390: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
3391: end if;
3392:
3393: p_xfdf_clob := l_xfdf_string;
3394: hr_utility.set_location ('Leaving WritetoCLOB ', 20);