APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on DBMS_LOB

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

2434: l_str14 := '';
2435: l_str15 := '';
2436: l_str16 := '';
2437: l_str17 := '';
2438: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);
2439: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
2440: current_index := 0;
2441:
2442: if xml_tab.count > 0 then

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

2435: l_str15 := '';
2436: l_str16 := '';
2437: l_str17 := '';
2438: dbms_lob.createtemporary (l_xfdf_string, false , dbms_lob.call);
2439: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
2440: current_index := 0;
2441:
2442: if xml_tab.count > 0 then
2443: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);

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

2439: dbms_lob.open (l_xfdf_string, dbms_lob.lob_readwrite);
2440: current_index := 0;
2441:
2442: if xml_tab.count > 0 then
2443: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);
2444: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);
2445:
2446: for table_counter in xml_tab.first .. xml_tab.last
2447: loop

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

2440: current_index := 0;
2441:
2442: if xml_tab.count > 0 then
2443: dbms_lob.writeappend (l_xfdf_string, length (l_str1), l_str1);
2444: dbms_lob.writeappend (l_xfdf_string, length (l_str12), l_str12);
2445:
2446: for table_counter in xml_tab.first .. xml_tab.last
2447: loop
2448: l_str8 := xml_tab (table_counter).tagname;

Line 2452: dbms_lob.writeappend (

2448: l_str8 := xml_tab (table_counter).tagname;
2449: l_str9 := xml_tab (table_counter).tagvalue;
2450:
2451: if l_str8 = 'LEGAL_EMPLOYER_NAME' then
2452: dbms_lob.writeappend (
2453: l_xfdf_string,
2454: length (l_str14),
2455: l_str14
2456: );

Line 2458: dbms_lob.writeappend (

2454: length (l_str14),
2455: l_str14
2456: );
2457: elsif l_str8 = 'EMPLOYEE_NUMBER' then
2458: dbms_lob.writeappend (
2459: l_xfdf_string,
2460: length (l_str16),
2461: l_str16
2462: );

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

2462: );
2463: end if;
2464:
2465: if l_str9 is not null then
2466: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2467: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2468: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2469: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2470: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);

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

2463: end if;
2464:
2465: if l_str9 is not null then
2466: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2467: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2468: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2469: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2470: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2471: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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

2464:
2465: if l_str9 is not null then
2466: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2467: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2468: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2469: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2470: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2471: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2472: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

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

2465: if l_str9 is not null then
2466: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2467: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2468: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2469: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2470: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2471: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2472: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2473: else

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

2466: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2467: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2468: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2469: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2470: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2471: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2472: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2473: else
2474: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);

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

2467: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2468: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2469: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2470: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2471: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2472: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2473: else
2474: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2475: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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

2468: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2469: dbms_lob.writeappend (l_xfdf_string, length (l_str9), l_str9);
2470: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2471: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2472: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2473: else
2474: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2475: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2476: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);

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

2470: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2471: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2472: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2473: else
2474: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2475: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2476: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2477: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2478: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);

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

2471: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2472: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2473: else
2474: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2475: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2476: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2477: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2478: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2479: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);

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

2472: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2473: else
2474: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2475: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2476: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2477: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2478: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2479: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2480: end if;

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

2473: else
2474: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2475: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2476: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2477: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2478: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2479: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2480: end if;
2481:

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

2474: dbms_lob.writeappend (l_xfdf_string, length (l_str2), l_str2);
2475: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2476: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2477: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2478: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2479: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2480: end if;
2481:
2482: if l_str8 = 'JOB_CHANGE_DATE' then

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

2475: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2476: dbms_lob.writeappend (l_xfdf_string, length (l_str3), l_str3);
2477: dbms_lob.writeappend (l_xfdf_string, length (l_str4), l_str4);
2478: dbms_lob.writeappend (l_xfdf_string, length (l_str8), l_str8);
2479: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2480: end if;
2481:
2482: if l_str8 = 'JOB_CHANGE_DATE' then
2483: dbms_lob.writeappend (

Line 2483: dbms_lob.writeappend (

2479: dbms_lob.writeappend (l_xfdf_string, length (l_str5), l_str5);
2480: end if;
2481:
2482: if l_str8 = 'JOB_CHANGE_DATE' then
2483: dbms_lob.writeappend (
2484: l_xfdf_string,
2485: length (l_str17),
2486: l_str17
2487: );

Line 2491: dbms_lob.writeappend (

2487: );
2488:
2489: if xml_tab.last = table_counter
2490: or xml_tab (table_counter + 1).tagname <> 'EMPLOYEE_NUMBER' then
2491: dbms_lob.writeappend (
2492: l_xfdf_string,
2493: length (l_str15),
2494: l_str15
2495: );

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

2496: end if;
2497: end if;
2498: end loop;
2499:
2500: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
2501: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
2502: else
2503: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
2504: end if;

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

2497: end if;
2498: end loop;
2499:
2500: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
2501: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
2502: else
2503: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
2504: end if;
2505:

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

2499:
2500: dbms_lob.writeappend (l_xfdf_string, length (l_str13), l_str13);
2501: dbms_lob.writeappend (l_xfdf_string, length (l_str6), l_str6);
2502: else
2503: dbms_lob.writeappend (l_xfdf_string, length (l_str7), l_str7);
2504: end if;
2505:
2506: p_xfdf_clob := l_xfdf_string;
2507: hr_utility.set_location ('Leaving WritetoCLOB ', 20);