APPS.PAY_NO_EERR_CONTINUOUS dependencies on DBMS_LOB

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

3514: l_str14 := '';
3515: l_str15 := '';
3516: l_str16 := '';
3517: l_str17 := '';
3518: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);
3519: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
3520: current_index := 0;
3521:
3522: if xml_tab.count > 0 then

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

3515: l_str15 := '';
3516: l_str16 := '';
3517: l_str17 := '';
3518: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);
3519: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
3520: current_index := 0;
3521:
3522: if xml_tab.count > 0 then
3523: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);

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

3519: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
3520: current_index := 0;
3521:
3522: if xml_tab.count > 0 then
3523: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);
3524: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);
3525:
3526: for table_counter in xml_tab.first .. xml_tab.last
3527: loop

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

3520: current_index := 0;
3521:
3522: if xml_tab.count > 0 then
3523: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);
3524: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);
3525:
3526: for table_counter in xml_tab.first .. xml_tab.last
3527: loop
3528: l_str8 := xml_tab (table_counter).tagname;

Line 3532: dbms_lob.writeappend (

3528: l_str8 := xml_tab (table_counter).tagname;
3529: l_str9 := xml_tab (table_counter).tagvalue;
3530:
3531: if l_str8 = 'LEGAL_EMPLOYER_NAME' then
3532: dbms_lob.writeappend (
3533: l_xfdf_string,
3534: length (l_str14),
3535: l_str14
3536: );

Line 3538: dbms_lob.writeappend (

3534: length (l_str14),
3535: l_str14
3536: );
3537: elsif l_str8 = 'EMPLOYEE_NUMBER' then
3538: dbms_lob.writeappend (
3539: l_xfdf_string,
3540: length (l_str16),
3541: l_str16
3542: );

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

3542: );
3543: end if;
3544:
3545: if l_str9 is not null then
3546: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3547: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3548: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3549: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3550: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);

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

3543: end if;
3544:
3545: if l_str9 is not null then
3546: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3547: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3548: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3549: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3550: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3551: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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

3544:
3545: if l_str9 is not null then
3546: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3547: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3548: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3549: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3550: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3551: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3552: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

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

3545: if l_str9 is not null then
3546: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3547: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3548: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3549: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3550: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3551: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3552: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3553: else

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

3546: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3547: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3548: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3549: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3550: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3551: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3552: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3553: else
3554: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);

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

3547: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3548: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3549: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3550: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3551: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3552: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3553: else
3554: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3555: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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

3548: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3549: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
3550: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3551: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3552: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3553: else
3554: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3555: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3556: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);

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

3550: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3551: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3552: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3553: else
3554: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3555: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3556: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3557: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3558: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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

3551: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3552: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3553: else
3554: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3555: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3556: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3557: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3558: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3559: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

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

3552: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3553: else
3554: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3555: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3556: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3557: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3558: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3559: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3560: end if;

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

3553: else
3554: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3555: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3556: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3557: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3558: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3559: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3560: end if;
3561:

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

3554: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
3555: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3556: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3557: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3558: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3559: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3560: end if;
3561:
3562: if l_str8 = 'JOB_CHANGE_DATE' then

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

3555: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3556: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
3557: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
3558: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
3559: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3560: end if;
3561:
3562: if l_str8 = 'JOB_CHANGE_DATE' then
3563: dbms_lob.writeappend (

Line 3563: dbms_lob.writeappend (

3559: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
3560: end if;
3561:
3562: if l_str8 = 'JOB_CHANGE_DATE' then
3563: dbms_lob.writeappend (
3564: l_xfdf_string,
3565: length (l_str17),
3566: l_str17
3567: );

Line 3571: dbms_lob.writeappend (

3567: );
3568:
3569: if xml_tab.last = table_counter
3570: or xml_tab (table_counter + 1).tagname <> 'EMPLOYEE_NUMBER' then
3571: dbms_lob.writeappend (
3572: l_xfdf_string,
3573: length (l_str15),
3574: l_str15
3575: );

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

3576: end if;
3577: end if;
3578: end loop;
3579:
3580: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
3581: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
3582: else
3583: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
3584: end if;

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

3577: end if;
3578: end loop;
3579:
3580: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
3581: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
3582: else
3583: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
3584: end if;
3585:

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

3579:
3580: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
3581: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
3582: else
3583: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
3584: end if;
3585:
3586: p_xfdf_clob := l_xfdf_string;
3587: hr_utility.set_location ('Leaving WritetoCLOB ', 20);