eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_RL1_MAG dependencies on DUAL

Line 104: from dual;

100: utl_raw.cast_to_varchar2(hextoraw('C386')),'AE'
101: ),
102: utl_raw.cast_to_varchar2(hextoraw('C3A9')),'e'
103: )
104: from dual;
105:
106: BEGIN
107: l_data := trim(p_data);
108: l_data := REPLACE(l_data, '&' , '&' || 'amp;');

Line 192: FROM dual;

188:
189: hr_utility.trace('l_transmitter_number = ' || l_transmitter_number);
190: SELECT substr(l_transmitter_number,1,2)
191: INTO dummy1
192: FROM dual;
193:
194: IF (dummy1 <> 'NP' OR
195: length(l_transmitter_number) <> 8) THEN
196: RAISE INVALID_NUMBER;

Line 201: FROM dual;

197: END IF;
198:
199: SELECT to_number(substr(l_transmitter_number,3,6))
200: INTO dummy
201: FROM dual;
202:
203: EXCEPTION
204: WHEN INVALID_NUMBER THEN
205: hr_utility.set_message(800,'PAY_CA_RL1_INVALID_TRANSMITTER');

Line 461: FROM dual;

457: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 40);
458:
459: SELECT pay_assignment_actions_s.nextval
460: INTO lockingactid
461: FROM dual;
462:
463: hr_utility.set_location('pay_ca_rl1_mag.create_assignement_act', 50);
464: hr_nonrun_asact.insact(lockingactid,
465: l_assignment_id,

Line 685: FROM dual;

681:
682: SELECT
683: fnd_global.local_chr(13) || fnd_global.local_chr(10)
684: INTO EOL
685: FROM dual;
686:
687: lAnnee := 1;
688: lTypeEnvoi := 2;
689: lProvenance := 3;

Line 1279: FROM dual;

1275:
1276: SELECT
1277: fnd_global.local_chr(13) || fnd_global.local_chr(10)
1278: INTO EOL
1279: FROM dual;
1280:
1281: lAnnee := 1;
1282: lNoReleve := 2;
1283: lNAS := 3;

Line 1518: select trunc(sysdate) into l_session_date from dual;

1514: l_person_id1 := to_number(pay_ca_archive_utils.get_archive_value(
1515: l_arch_action_id,
1516: 'CAEOY_PERSON_ID'));
1517:
1518: select trunc(sysdate) into l_session_date from dual;
1519: hr_utility.trace('l_person_id1 ='|| l_person_id1);
1520: hr_utility.trace('l_session_date ='|| l_session_date);
1521: addr := pay_ca_rl1_reg.get_primary_address(l_person_id1, l_session_date);
1522: tab_xml_employee(lLigne1) := convert_special_char(substr(addr.addr_line_1,1,40));

Line 1650: FROM dual;

1646: to_number(l_box) <> 0 THEN
1647:
1648: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1649: INTO l_formatted_box
1650: FROM dual;
1651: tab_employee(lA_RevenuEmploi) := '' || l_formatted_box ||
1652: '' || EOL;
1653: tab_xml_employee(lA_RevenuEmploi) := l_formatted_box; --
1654: l_all_box_0 := FALSE;

Line 1682: FROM dual;

1678: l_BoxB := l_box;
1679:
1680: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1681: INTO l_formatted_box
1682: FROM dual;
1683:
1684: tab_employee(lB_CotisationRRQ) := '' || l_formatted_box
1685: || '' || EOL;
1686: tab_xml_employee(lB_CotisationRRQ) := l_formatted_box; --

Line 1716: FROM dual;

1712: to_number(l_box) <> 0 THEN
1713:
1714: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1715: INTO l_formatted_box
1716: FROM dual;
1717:
1718: tab_employee(lC_CotisationAssEmploi) := '' ||
1719: l_formatted_box || '' || EOL;
1720: tab_xml_employee(lC_CotisationAssEmploi) := l_formatted_box; --

Line 1749: FROM dual;

1745: to_number(l_box) <> 0 THEN
1746:
1747: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1748: INTO l_formatted_box
1749: FROM dual;
1750:
1751: tab_employee(lD_CotisationRPA) := '' ||
1752: l_formatted_box || '' || EOL;
1753: tab_xml_employee(lD_CotisationRPA) := l_formatted_box; --

Line 1783: FROM dual;

1779: to_number(l_box) <> 0 THEN
1780:
1781: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1782: INTO l_formatted_box
1783: FROM dual;
1784:
1785: tab_employee(lE_ImpotQue) := '' ||
1786: l_formatted_box || '' || EOL;
1787: tab_xml_employee(lE_ImpotQue) := l_formatted_box ; --

Line 1816: FROM dual;

1812: to_number(l_box) <> 0 THEN
1813:
1814: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1815: INTO l_formatted_box
1816: FROM dual;
1817:
1818: tab_employee(lF_CotisationSyndicale) := '' ||
1819: l_formatted_box || '' || EOL;
1820: tab_xml_employee(lF_CotisationSyndicale) := l_formatted_box; --

Line 1848: FROM dual;

1844: to_number(l_box) <> 0 THEN
1845:
1846: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1847: INTO l_formatted_box
1848: FROM dual;
1849:
1850: tab_employee(lQ_SalaireDiffere) := '' ||
1851: l_formatted_box || '' || EOL;
1852: tab_xml_employee(lQ_SalaireDiffere) := l_formatted_box; --

Line 1883: FROM dual;

1879: to_number(l_box) <> 0 THEN
1880:
1881: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1882: INTO l_formatted_box
1883: FROM dual;
1884:
1885: tab_employee(lU_RetraiteProgressive) := '' ||
1886: l_formatted_box || '' || EOL;
1887: tab_xml_employee(lU_RetraiteProgressive) := l_formatted_box; --

Line 1921: FROM dual;

1917: l_msg_code := 'AMT_GREATER_THAN_RANGE';
1918:
1919: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1920: INTO l_formatted_box
1921: FROM dual;
1922:
1923: tab_employee(lG_SalaireAdmisRRQ) := '' ||
1924: l_formatted_box || '' || EOL;
1925: --tab_xml_employee(lG_SalaireAdmisRRQ) := l_formatted_box; --

Line 1939: FROM dual;

1935: NVL(to_number(l_BoxU),0)) THEN
1936:
1937: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1938: INTO l_formatted_box
1939: FROM dual;
1940:
1941: tab_employee(lG_SalaireAdmisRRQ) := '' ||
1942: l_formatted_box || '' || EOL;
1943:

Line 1968: FROM dual;

1964: IF l_rep_type ='RL1PAPERPDF' THEN
1965: IF l_box IS NOT NULL THEN
1966: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
1967: INTO l_formatted_box
1968: FROM dual;
1969: tab_xml_employee(lG_SalaireAdmisRRQ) := l_formatted_box;
1970: IF to_number(l_box)= NVL(to_number(l_BoxA),0) THEN
1971: tab_xml_employee(lG_SalaireAdmisRRQ) := NULL;
1972: END IF;

Line 2003: FROM dual;

1999: to_number(l_box) <> 0 THEN
2000:
2001: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2002: INTO l_formatted_box
2003: FROM dual;
2004:
2005: tab_employee(lV_NourritureLogement) := '' ||
2006: l_formatted_box || '' || EOL;
2007: tab_xml_employee(lV_NourritureLogement) := l_formatted_box; --

Line 2036: FROM dual;

2032: to_number(l_box) <> 0 THEN
2033:
2034: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2035: INTO l_formatted_box
2036: FROM dual;
2037:
2038: tab_employee(lW_Vehicule) := '' ||
2039: l_formatted_box || '' || EOL;
2040: tab_xml_employee(lW_Vehicule) := l_formatted_box; --

Line 2068: FROM dual;

2064: to_number(l_box) <> 0 THEN
2065:
2066: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2067: INTO l_formatted_box
2068: FROM dual;
2069:
2070: tab_employee(lH_CotisationRQAP) := '' ||
2071: l_formatted_box || '' || EOL;
2072: tab_xml_employee(lH_CotisationRQAP) := l_formatted_box; --

Line 2102: FROM dual;

2098: to_number(l_box) <> 0 THEN
2099:
2100: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2101: INTO l_formatted_box
2102: FROM dual;
2103:
2104: tab_employee(lI_SalaireAdmisRQAP) := '' ||
2105: l_formatted_box || '' || EOL;
2106: tab_xml_employee(lI_SalaireAdmisRQAP) := l_formatted_box; --

Line 2136: FROM dual;

2132: to_number(l_box) <> 0 THEN
2133:
2134: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2135: INTO l_formatted_box
2136: FROM dual;
2137:
2138: tab_employee(lJ_RegimeAssMaladie) := '' ||
2139: l_formatted_box || '' || EOL;
2140: tab_xml_employee(lJ_RegimeAssMaladie) := l_formatted_box; --

Line 2169: FROM dual;

2165: to_number(l_box) <> 0 THEN
2166:
2167: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2168: INTO l_formatted_box
2169: FROM dual;
2170:
2171: tab_employee(lK_Voyage) := '' ||
2172: l_formatted_box || '' || EOL;
2173: tab_xml_employee(lK_Voyage) := l_formatted_box; --

Line 2201: FROM dual;

2197: to_number(l_box) <> 0 THEN
2198:
2199: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2200: INTO l_formatted_box
2201: FROM dual;
2202:
2203: tab_employee(lL_AutreAvantage) := '' ||
2204: l_formatted_box || '' || EOL;
2205: tab_xml_employee(lL_AutreAvantage) := l_formatted_box; --

Line 2233: FROM dual;

2229: to_number(l_box) <> 0 THEN
2230:
2231: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2232: INTO l_formatted_box
2233: FROM dual;
2234:
2235: tab_employee(lM_Commission) := '' ||
2236: l_formatted_box || '' || EOL;
2237: tab_xml_employee(lM_Commission) := l_formatted_box; --

Line 2265: FROM dual;

2261: to_number(l_box) <> 0 THEN
2262:
2263: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2264: INTO l_formatted_box
2265: FROM dual;
2266:
2267: tab_employee(lN_DonBienfaisance) := '' ||
2268: l_formatted_box || '' || EOL;
2269: tab_xml_employee(lN_DonBienfaisance) := l_formatted_box; --

Line 2299: FROM dual;

2295:
2296: l_boxO := l_box;
2297: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2298: INTO l_formatted_box
2299: FROM dual;
2300:
2301: tab_employee(lO_AutreRevenu) := '' ||
2302: l_formatted_box || '' || EOL;
2303: tab_xml_employee(lO_AutreRevenu) := l_formatted_box; --

Line 2361: FROM dual;

2357: to_number(l_box) <> 0 THEN
2358:
2359: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2360: INTO l_formatted_box
2361: FROM dual;
2362:
2363: tab_employee(lP_RegimeAssInterEntr) := '' ||
2364: l_formatted_box || '' || EOL;
2365: tab_xml_employee(lP_RegimeAssInterEntr) := l_formatted_box; --

Line 2393: FROM dual;

2389: to_number(l_box) <> 0 THEN
2390:
2391: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2392: INTO l_formatted_box
2393: FROM dual;
2394:
2395: tab_employee(lR_RevenuIndien) := '' ||
2396: l_formatted_box || '' || EOL;
2397: tab_xml_employee(lR_RevenuIndien) := l_formatted_box; --

Line 2425: FROM dual;

2421: to_number(l_box) <> 0 THEN
2422:
2423: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2424: INTO l_formatted_box
2425: FROM dual;
2426:
2427: tab_employee(lS_PourboireRecu) := '' ||
2428: l_formatted_box || '' || EOL;
2429: tab_xml_employee(lS_PourboireRecu) := l_formatted_box; --

Line 2457: FROM dual;

2453: to_number(l_box) <> 0 THEN
2454:
2455: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2456: INTO l_formatted_box
2457: FROM dual;
2458:
2459: tab_employee(lT_PourboireAttribue) := '' ||
2460: l_formatted_box || '' || EOL;
2461: tab_xml_employee(lT_PourboireAttribue) := l_formatted_box; --

Line 2488: FROM dual;

2484: to_number(l_box) <> 0 THEN
2485:
2486: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2487: INTO l_formatted_box
2488: FROM dual;
2489:
2490: tab_employee(l_ContisationRPC) := '' ||
2491: l_formatted_box || '' || EOL;
2492: l_all_box_0 := FALSE;

Line 2533: FROM dual;

2529: to_number(l_box) <> 0 THEN
2530:
2531: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2532: INTO l_formatted_box
2533: FROM dual;
2534:
2535: tab_employee(lBoxA_01) := '' ||
2536: l_formatted_box || '' || EOL;
2537: ELSE

Line 2555: FROM dual;

2551: to_number(l_box) <> 0 THEN
2552:
2553: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2554: INTO l_formatted_box
2555: FROM dual;
2556:
2557: tab_employee(lBoxA_02) := '' ||
2558: l_formatted_box || '' || EOL;
2559: ELSE

Line 2577: FROM dual;

2573: to_number(l_box) <> 0 THEN
2574:
2575: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2576: INTO l_formatted_box
2577: FROM dual;
2578:
2579: tab_employee(lBoxA_15) := '' ||
2580: l_formatted_box || '' || EOL;
2581: ELSE

Line 2599: FROM dual;

2595: to_number(l_box) <> 0 THEN
2596:
2597: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2598: INTO l_formatted_box
2599: FROM dual;
2600:
2601: tab_employee(lBoxA_16) := '' ||
2602: l_formatted_box || '' || EOL;
2603: ELSE

Line 2621: FROM dual;

2617: to_number(l_box) <> 0 THEN
2618:
2619: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2620: INTO l_formatted_box
2621: FROM dual;
2622:
2623: tab_employee(lBoxA_17) := '' ||
2624: l_formatted_box || '' || EOL;
2625: ELSE

Line 2643: FROM dual;

2639: to_number(l_box) <> 0 THEN
2640:
2641: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2642: INTO l_formatted_box
2643: FROM dual;
2644:
2645: tab_employee(lBoxA_18) := '' ||
2646: l_formatted_box || '' || EOL;
2647: ELSE

Line 2665: FROM dual;

2661: to_number(l_box) <> 0 THEN
2662:
2663: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2664: INTO l_formatted_box
2665: FROM dual;
2666:
2667: tab_employee(lBoxA_19) := '' ||
2668: l_formatted_box || '' || EOL;
2669: ELSE

Line 2687: FROM dual;

2683: to_number(l_box) <> 0 THEN
2684:
2685: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2686: INTO l_formatted_box
2687: FROM dual;
2688:
2689: tab_employee(lBoxA_25) := '' ||
2690: l_formatted_box || '' || EOL;
2691: ELSE

Line 2709: FROM dual;

2705: to_number(l_box) <> 0 THEN
2706:
2707: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2708: INTO l_formatted_box
2709: FROM dual;
2710:
2711: tab_employee(lBoxA_26) := '' ||
2712: l_formatted_box || '' || EOL;
2713: ELSE

Line 2731: FROM dual;

2727: to_number(l_box) <> 0 THEN
2728:
2729: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2730: INTO l_formatted_box
2731: FROM dual;
2732:
2733: tab_employee(lBoxA_27) := '' ||
2734: l_formatted_box || '' || EOL;
2735: ELSE

Line 2753: FROM dual;

2749: to_number(l_box) <> 0 THEN
2750:
2751: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2752: INTO l_formatted_box
2753: FROM dual;
2754:
2755: tab_employee(lBoxA_29) := '' ||
2756: l_formatted_box || '' || EOL;
2757: ELSE

Line 2775: FROM dual;

2771: to_number(l_box) <> 0 THEN
2772:
2773: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2774: INTO l_formatted_box
2775: FROM dual;
2776:
2777: tab_employee(lBoxA_30) := '' ||
2778: l_formatted_box || '' || EOL;
2779: ELSE

Line 2797: FROM dual;

2793: to_number(l_box) <> 0 THEN
2794:
2795: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2796: INTO l_formatted_box
2797: FROM dual;
2798:
2799: tab_employee(lBoxD_07) := '' ||
2800: l_formatted_box || '' || EOL;
2801: ELSE

Line 2819: FROM dual;

2815: to_number(l_box) <> 0 THEN
2816:
2817: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2818: INTO l_formatted_box
2819: FROM dual;
2820:
2821: tab_employee(lBoxD_08) := '' ||
2822: l_formatted_box || '' || EOL;
2823: ELSE

Line 2841: FROM dual;

2837: to_number(l_box) <> 0 THEN
2838:
2839: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2840: INTO l_formatted_box
2841: FROM dual;
2842:
2843: tab_employee(lBoxD_20) := '' ||
2844: l_formatted_box || '' || EOL;
2845: ELSE

Line 2863: FROM dual;

2859: to_number(l_box) <> 0 THEN
2860:
2861: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2862: INTO l_formatted_box
2863: FROM dual;
2864:
2865: tab_employee(lBoxK_11) := '' ||
2866: l_formatted_box || '' || EOL;
2867: ELSE

Line 2885: FROM dual;

2881: to_number(l_box) <> 0 THEN
2882:
2883: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2884: INTO l_formatted_box
2885: FROM dual;
2886:
2887: tab_employee(lBoxO_RA) := '' ||
2888: l_formatted_box || '' || EOL;
2889: ELSE

Line 2907: FROM dual;

2903: to_number(l_box) <> 0 THEN
2904:
2905: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2906: INTO l_formatted_box
2907: FROM dual;
2908:
2909: tab_employee(lBoxO_RB) := '' ||
2910: l_formatted_box || '' || EOL;
2911: ELSE

Line 2929: FROM dual;

2925: to_number(l_box) <> 0 THEN
2926:
2927: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2928: INTO l_formatted_box
2929: FROM dual;
2930:
2931: tab_employee(lBoxO_RC) := '' ||
2932: l_formatted_box || '' || EOL;
2933: ELSE

Line 2951: FROM dual;

2947: to_number(l_box) <> 0 THEN
2948:
2949: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2950: INTO l_formatted_box
2951: FROM dual;
2952:
2953: tab_employee(lBoxO_RD) := '' ||
2954: l_formatted_box || '' || EOL;
2955: ELSE

Line 2973: FROM dual;

2969: to_number(l_box) <> 0 THEN
2970:
2971: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2972: INTO l_formatted_box
2973: FROM dual;
2974:
2975: tab_employee(lBoxO_RE) := '' ||
2976: l_formatted_box || '' || EOL;
2977: ELSE

Line 2995: FROM dual;

2991: to_number(l_box) <> 0 THEN
2992:
2993: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
2994: INTO l_formatted_box
2995: FROM dual;
2996:
2997: tab_employee(lBoxO_RF) := '' ||
2998: l_formatted_box || '' || EOL;
2999: ELSE

Line 3017: FROM dual;

3013: to_number(l_box) <> 0 THEN
3014:
3015: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3016: INTO l_formatted_box
3017: FROM dual;
3018:
3019: tab_employee(lBoxO_RG) := '' ||
3020: l_formatted_box || '' || EOL;
3021: ELSE

Line 3039: FROM dual;

3035: to_number(l_box) <> 0 THEN
3036:
3037: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3038: INTO l_formatted_box
3039: FROM dual;
3040:
3041: tab_employee(lBoxO_RH) := '' ||
3042: l_formatted_box || '' || EOL;
3043: ELSE

Line 3061: FROM dual;

3057: to_number(l_box) <> 0 THEN
3058:
3059: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3060: INTO l_formatted_box
3061: FROM dual;
3062:
3063: tab_employee(lBoxO_RI) := '' ||
3064: l_formatted_box || '' || EOL;
3065: ELSE

Line 3083: FROM dual;

3079: to_number(l_box) <> 0 THEN
3080:
3081: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3082: INTO l_formatted_box
3083: FROM dual;
3084:
3085: tab_employee(lBoxO_RJ) := '' ||
3086: l_formatted_box || '' || EOL;
3087: ELSE

Line 3105: FROM dual;

3101: to_number(l_box) <> 0 THEN
3102:
3103: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3104: INTO l_formatted_box
3105: FROM dual;
3106:
3107: tab_employee(lBoxO_RK) := '' ||
3108: l_formatted_box || '' || EOL;
3109: ELSE

Line 3127: FROM dual;

3123: to_number(l_box) <> 0 THEN
3124:
3125: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3126: INTO l_formatted_box
3127: FROM dual;
3128:
3129: tab_employee(lBoxO_RL) := '' ||
3130: l_formatted_box || '' || EOL;
3131: ELSE

Line 3149: FROM dual;

3145: to_number(l_box) <> 0 THEN
3146:
3147: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3148: INTO l_formatted_box
3149: FROM dual;
3150:
3151: tab_employee(lBoxO_RL22) := '' ||
3152: l_formatted_box || '' || EOL;
3153: ELSE

Line 3171: FROM dual;

3167: to_number(l_box) <> 0 THEN
3168:
3169: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3170: INTO l_formatted_box
3171: FROM dual;
3172:
3173: tab_employee(lBoxO_RL28) := '' ||
3174: l_formatted_box || '' || EOL;
3175: ELSE

Line 3193: FROM dual;

3189: to_number(l_box) <> 0 THEN
3190:
3191: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3192: INTO l_formatted_box
3193: FROM dual;
3194:
3195: tab_employee(lBoxO_RM) := '' ||
3196: l_formatted_box || '' || EOL;
3197: ELSE

Line 3215: FROM dual;

3211: to_number(l_box) <> 0 THEN
3212:
3213: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3214: INTO l_formatted_box
3215: FROM dual;
3216:
3217: tab_employee(lBoxO_RN) := '' ||
3218: l_formatted_box || '' || EOL;
3219: ELSE

Line 3239: FROM dual;

3235: to_number(l_box) <> 0 THEN
3236:
3237: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3238: INTO l_formatted_box
3239: FROM dual;
3240:
3241: tab_employee(lBoxO_RN_31) := '' ||
3242: l_formatted_box || '' || EOL;
3243: ELSE

Line 3260: FROM dual;

3256: to_number(l_box) <> 0 THEN
3257:
3258: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3259: INTO l_formatted_box
3260: FROM dual;
3261:
3262: tab_employee(lBoxO_RO) := '' ||
3263: l_formatted_box || '' || EOL;
3264: ELSE

Line 3282: FROM dual;

3278: to_number(l_box) <> 0 THEN
3279:
3280: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3281: INTO l_formatted_box
3282: FROM dual;
3283:
3284: tab_employee(lBoxO_RP) := '' ||
3285: l_formatted_box || '' || EOL;
3286: ELSE

Line 3304: FROM dual;

3300: to_number(l_box) <> 0 THEN
3301:
3302: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3303: INTO l_formatted_box
3304: FROM dual;
3305:
3306: tab_employee(lBoxO_RQ) := '' ||
3307: l_formatted_box || '' || EOL;
3308: ELSE

Line 3326: FROM dual;

3322: to_number(l_box) <> 0 THEN
3323:
3324: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3325: INTO l_formatted_box
3326: FROM dual;
3327:
3328: tab_employee(lBoxO_RR) := '' ||
3329: l_formatted_box || '' || EOL;
3330: ELSE

Line 3348: FROM dual;

3344: to_number(l_box) <> 0 THEN
3345:
3346: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3347: INTO l_formatted_box
3348: FROM dual;
3349:
3350: tab_employee(lBoxO_RS) := '' ||
3351: l_formatted_box || '' || EOL;
3352: ELSE

Line 3370: FROM dual;

3366: to_number(l_box) <> 0 THEN
3367:
3368: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3369: INTO l_formatted_box
3370: FROM dual;
3371:
3372: tab_employee(lBoxO_RT) := '' ||
3373: l_formatted_box || '' || EOL;
3374: ELSE

Line 3392: FROM dual;

3388: to_number(l_box) <> 0 THEN
3389:
3390: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3391: INTO l_formatted_box
3392: FROM dual;
3393:
3394: tab_employee(lBoxO_RU) := '' ||
3395: l_formatted_box || '' || EOL;
3396: ELSE

Line 3414: FROM dual;

3410: to_number(l_box) <> 0 THEN
3411:
3412: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3413: INTO l_formatted_box
3414: FROM dual;
3415:
3416: tab_employee(lBoxO_RV) := '' ||
3417: l_formatted_box || '' || EOL;
3418: ELSE

Line 3436: FROM dual;

3432: to_number(l_box) <> 0 THEN
3433:
3434: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3435: INTO l_formatted_box
3436: FROM dual;
3437:
3438: tab_employee(lBoxO_RW) := '' ||
3439: l_formatted_box || '' || EOL;
3440: ELSE

Line 3458: FROM dual;

3454: to_number(l_box) <> 0 THEN
3455:
3456: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3457: INTO l_formatted_box
3458: FROM dual;
3459:
3460: tab_employee(lBoxQ_24) := '' ||
3461: l_formatted_box || '' || EOL;
3462: ELSE

Line 3480: FROM dual;

3476: to_number(l_box) <> 0 THEN
3477:
3478: SELECT ltrim(rtrim(to_char(to_number(l_box),l_format_mask)))
3479: INTO l_formatted_box
3480: FROM dual;
3481:
3482: tab_employee(lBoxR_14) := '' ||
3483: l_formatted_box || '' || EOL;
3484: ELSE

Line 3790: select pay_ca_rl1_pdf_seq_s.nextval into l_sequence_number from dual;

3786: hr_utility.trace('l_footnote_boxo2 ='|| l_footnote_boxo2);
3787: hr_utility.trace('l_footnote_boxo3 ='|| l_footnote_boxo3);
3788: tab_xml_employee(lNomFamille) := tab_xml_employee(lNomFamille)||','||tab_xml_employee(lPrenom)||' '||tab_xml_employee(lInitiale);
3789:
3790: select pay_ca_rl1_pdf_seq_s.nextval into l_sequence_number from dual;
3791: l_sequence_number1:=getnext_seq_num(l_sequence_number);
3792:
3793: for k in 1..3 loop
3794: l_final_xml_string :=

Line 4173: FROM dual;

4169:
4170: SELECT
4171: fnd_global.local_chr(13) || fnd_global.local_chr(10)
4172: INTO EOL
4173: FROM dual;
4174:
4175: lAnnee := 1;
4176: lNbReleves := 2;
4177: lNoId := 3;

Line 4460: from dual;

4456: hr_utility.trace('l_see_attached = '||l_see_attached);
4457: SELECT
4458: fnd_global.local_chr(13) || fnd_global.local_chr(10)
4459: INTO EOL
4460: from dual;
4461: l_cpp_withheld := pay_ca_archive_utils.get_archive_value(p_arch_assact_id
4462: ,'CAEOY_CPP_EE_WITHHELD_PER_YTD');
4463: open c_get_language(p_assgn_id);
4464: fetch c_get_language into l_person_lang;

Line 4590: FROM dual;

4586:
4587: SELECT
4588: fnd_global.local_chr(13) || fnd_global.local_chr(10)
4589: INTO EOL
4590: FROM dual;
4591:
4592: lNoId := 1;
4593: lNom1 := 2;
4594: lLigne1 := 3;