APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on DBMS_LOB

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

2612: l_str14 := '';
2613: l_str15 := '';
2614: l_str16 := '';
2615: l_str17 := '';
2616: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);
2617: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
2618: current_index := 0;
2619:
2620: if xml_tab.count > 0 then

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

2613: l_str15 := '';
2614: l_str16 := '';
2615: l_str17 := '';
2616: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);
2617: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
2618: current_index := 0;
2619:
2620: if xml_tab.count > 0 then
2621: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);

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

2617: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
2618: current_index := 0;
2619:
2620: if xml_tab.count > 0 then
2621: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);
2622: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);
2623:
2624: for table_counter in xml_tab.first .. xml_tab.last
2625: loop

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

2618: current_index := 0;
2619:
2620: if xml_tab.count > 0 then
2621: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);
2622: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);
2623:
2624: for table_counter in xml_tab.first .. xml_tab.last
2625: loop
2626: l_str8 := xml_tab (table_counter).tagname;

Line 2630: dbms_lob.writeappend (

2626: l_str8 := xml_tab (table_counter).tagname;
2627: l_str9 := xml_tab (table_counter).tagvalue;
2628:
2629: if l_str8 = 'LEGAL_EMPLOYER_NAME' then
2630: dbms_lob.writeappend (
2631: l_xfdf_string,
2632: length (l_str14),
2633: l_str14
2634: );

Line 2636: dbms_lob.writeappend (

2632: length (l_str14),
2633: l_str14
2634: );
2635: elsif l_str8 = 'EMPLOYEE_NUMBER' then
2636: dbms_lob.writeappend (
2637: l_xfdf_string,
2638: length (l_str16),
2639: l_str16
2640: );

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

2640: );
2641: end if;
2642:
2643: if l_str9 is not null then
2644: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2645: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2646: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2647: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2648: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);

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

2641: end if;
2642:
2643: if l_str9 is not null then
2644: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2645: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2646: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2647: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2648: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2649: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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

2642:
2643: if l_str9 is not null then
2644: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2645: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2646: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2647: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2648: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2649: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2650: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

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

2643: if l_str9 is not null then
2644: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2645: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2646: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2647: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2648: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2649: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2650: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2651: else

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

2644: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2645: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2646: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2647: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2648: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2649: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2650: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2651: else
2652: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);

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

2645: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2646: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2647: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2648: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2649: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2650: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2651: else
2652: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2653: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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

2646: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2647: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2648: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2649: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2650: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2651: else
2652: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2653: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2654: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);

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

2648: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2649: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2650: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2651: else
2652: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2653: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2654: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2655: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2656: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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

2649: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2650: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2651: else
2652: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2653: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2654: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2655: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2656: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2657: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

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

2650: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2651: else
2652: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2653: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2654: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2655: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2656: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2657: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2658: end if;

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

2651: else
2652: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2653: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2654: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2655: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2656: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2657: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2658: end if;
2659:

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

2652: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2653: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2654: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2655: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2656: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2657: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2658: end if;
2659:
2660: if l_str8 = 'JOB_CHANGE_DATE' then

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

2653: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2654: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2655: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2656: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2657: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2658: end if;
2659:
2660: if l_str8 = 'JOB_CHANGE_DATE' then
2661: dbms_lob.writeappend (

Line 2661: dbms_lob.writeappend (

2657: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2658: end if;
2659:
2660: if l_str8 = 'JOB_CHANGE_DATE' then
2661: dbms_lob.writeappend (
2662: l_xfdf_string,
2663: length (l_str17),
2664: l_str17
2665: );

Line 2669: dbms_lob.writeappend (

2665: );
2666:
2667: if xml_tab.last = table_counter
2668: or xml_tab (table_counter + 1).tagname <> 'EMPLOYEE_NUMBER' then
2669: dbms_lob.writeappend (
2670: l_xfdf_string,
2671: length (l_str15),
2672: l_str15
2673: );

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

2674: end if;
2675: end if;
2676: end loop;
2677:
2678: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
2679: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
2680: else
2681: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
2682: end if;

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

2675: end if;
2676: end loop;
2677:
2678: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
2679: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
2680: else
2681: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
2682: end if;
2683:

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

2677:
2678: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
2679: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
2680: else
2681: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
2682: end if;
2683:
2684: p_xfdf_clob := l_xfdf_string;
2685: hr_utility.set_location ('Leaving WritetoCLOB ', 20);