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_GB_ENROLL_INFO_GENE dependencies on FND_DATE

Line 214: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.auto_enrollment_date,screen_entry_value, null))) auto_enrollment_date ,

210: CURSOR c_pension_entry_values(l_assignment_id number)
211: IS
212: SELECT max(decode(trim(peevf.input_value_id),l_input_value_ids.qualifying_scheme_name,screen_entry_value, null)) qualifying_scheme_name,
213: max(decode(trim(peevf.input_value_id),l_input_value_ids.agg_earnings_pensions_id,screen_entry_value, null)) agg_earnings,
214: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.auto_enrollment_date,screen_entry_value, null))) auto_enrollment_date ,
215: max(decode(trim(peevf.input_value_id),l_input_value_ids.pension_classification,hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',screen_entry_value), null)) pension_classification,
216: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_period_end_date,screen_entry_value, null))) opt_out_period_end_date,
217: max(decode(trim(peevf.input_value_id),l_input_value_ids.total_earning_prp,screen_entry_value, null)) total_earning_prp,
218: max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_type,hr_general.decode_lookup('GB_PENSION_POSTPONEMENT_TYPES',screen_entry_value), null)) postponement_type ,

Line 216: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_period_end_date,screen_entry_value, null))) opt_out_period_end_date,

212: SELECT max(decode(trim(peevf.input_value_id),l_input_value_ids.qualifying_scheme_name,screen_entry_value, null)) qualifying_scheme_name,
213: max(decode(trim(peevf.input_value_id),l_input_value_ids.agg_earnings_pensions_id,screen_entry_value, null)) agg_earnings,
214: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.auto_enrollment_date,screen_entry_value, null))) auto_enrollment_date ,
215: max(decode(trim(peevf.input_value_id),l_input_value_ids.pension_classification,hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',screen_entry_value), null)) pension_classification,
216: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_period_end_date,screen_entry_value, null))) opt_out_period_end_date,
217: max(decode(trim(peevf.input_value_id),l_input_value_ids.total_earning_prp,screen_entry_value, null)) total_earning_prp,
218: max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_type,hr_general.decode_lookup('GB_PENSION_POSTPONEMENT_TYPES',screen_entry_value), null)) postponement_type ,
219: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_end_date,screen_entry_value, null))) postponement_end_date,
220: max(decode(trim(peevf.input_value_id),l_input_value_ids.qualifying_scheme_exists,screen_entry_value, null)) qualifying_scheme_exists,

Line 219: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_end_date,screen_entry_value, null))) postponement_end_date,

215: max(decode(trim(peevf.input_value_id),l_input_value_ids.pension_classification,hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',screen_entry_value), null)) pension_classification,
216: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_period_end_date,screen_entry_value, null))) opt_out_period_end_date,
217: max(decode(trim(peevf.input_value_id),l_input_value_ids.total_earning_prp,screen_entry_value, null)) total_earning_prp,
218: max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_type,hr_general.decode_lookup('GB_PENSION_POSTPONEMENT_TYPES',screen_entry_value), null)) postponement_type ,
219: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_end_date,screen_entry_value, null))) postponement_end_date,
220: max(decode(trim(peevf.input_value_id),l_input_value_ids.qualifying_scheme_exists,screen_entry_value, null)) qualifying_scheme_exists,
221: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_in_date,screen_entry_value, null))) opt_in_date,
222: max(decode(trim(peevf.input_value_id),l_input_value_ids.main_entry_id,screen_entry_value, null)) main_entry,
223: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.elig_jh_date,screen_entry_value, null))) elig_jh_date,

Line 221: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_in_date,screen_entry_value, null))) opt_in_date,

217: max(decode(trim(peevf.input_value_id),l_input_value_ids.total_earning_prp,screen_entry_value, null)) total_earning_prp,
218: max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_type,hr_general.decode_lookup('GB_PENSION_POSTPONEMENT_TYPES',screen_entry_value), null)) postponement_type ,
219: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_end_date,screen_entry_value, null))) postponement_end_date,
220: max(decode(trim(peevf.input_value_id),l_input_value_ids.qualifying_scheme_exists,screen_entry_value, null)) qualifying_scheme_exists,
221: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_in_date,screen_entry_value, null))) opt_in_date,
222: max(decode(trim(peevf.input_value_id),l_input_value_ids.main_entry_id,screen_entry_value, null)) main_entry,
223: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.elig_jh_date,screen_entry_value, null))) elig_jh_date,
224: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_date,screen_entry_value, null))) opt_out_date
225: from pay_element_entry_values_f peevf,

Line 223: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.elig_jh_date,screen_entry_value, null))) elig_jh_date,

219: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_end_date,screen_entry_value, null))) postponement_end_date,
220: max(decode(trim(peevf.input_value_id),l_input_value_ids.qualifying_scheme_exists,screen_entry_value, null)) qualifying_scheme_exists,
221: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_in_date,screen_entry_value, null))) opt_in_date,
222: max(decode(trim(peevf.input_value_id),l_input_value_ids.main_entry_id,screen_entry_value, null)) main_entry,
223: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.elig_jh_date,screen_entry_value, null))) elig_jh_date,
224: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_date,screen_entry_value, null))) opt_out_date
225: from pay_element_entry_values_f peevf,
226: pay_element_entries_f peef,
227: pay_element_types_f petf

Line 224: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_date,screen_entry_value, null))) opt_out_date

220: max(decode(trim(peevf.input_value_id),l_input_value_ids.qualifying_scheme_exists,screen_entry_value, null)) qualifying_scheme_exists,
221: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_in_date,screen_entry_value, null))) opt_in_date,
222: max(decode(trim(peevf.input_value_id),l_input_value_ids.main_entry_id,screen_entry_value, null)) main_entry,
223: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.elig_jh_date,screen_entry_value, null))) elig_jh_date,
224: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_date,screen_entry_value, null))) opt_out_date
225: from pay_element_entry_values_f peevf,
226: pay_element_entries_f peef,
227: pay_element_types_f petf
228: where peevf.input_value_id in (l_input_value_ids.qualifying_scheme_name ,

Line 326: ,p_action_information27 =>fnd_date.date_to_canonical(p_issue_date)

322: ,p_action_information23 =>p_archive_details_update.action_information23
323: ,p_action_information24 =>p_archive_details_update.action_information24
324: ,p_action_information25 =>p_archive_details_update.action_information25
325: ,p_action_information26 =>p_period
326: ,p_action_information27 =>fnd_date.date_to_canonical(p_issue_date)
327: ,p_action_information28 =>fnd_date.date_to_canonical(p_postponement_date)
328: ,p_action_information29 =>p_postponement_type
329: ,p_action_information30 => P_LETTER);
330: end update_archive;

Line 327: ,p_action_information28 =>fnd_date.date_to_canonical(p_postponement_date)

323: ,p_action_information24 =>p_archive_details_update.action_information24
324: ,p_action_information25 =>p_archive_details_update.action_information25
325: ,p_action_information26 =>p_period
326: ,p_action_information27 =>fnd_date.date_to_canonical(p_issue_date)
327: ,p_action_information28 =>fnd_date.date_to_canonical(p_postponement_date)
328: ,p_action_information29 =>p_postponement_type
329: ,p_action_information30 => P_LETTER);
330: end update_archive;
331:

Line 440: l_postponement_date :=fnd_date.canonical_to_date(p_pension_entry_values.postponement_end_date);

436: --l_ovn := l_archive_details_update.object_version_number;
437: CLOSE c_archive_details_update;
438: END IF;
439:
440: l_postponement_date :=fnd_date.canonical_to_date(p_pension_entry_values.postponement_end_date);
441: l_postponement_type :=p_pension_entry_values.postponement_type;
442: ----------------------------------------------------------------------------------------------------
443: IF P_LETTER = 'PYGBPAEIG1' and l_flag ='Y' THEN
444: --Letter for the Automatically Enrolled

Line 541: l_opt_out_new := greatest ((p_issue_date+30), fnd_date.canonical_to_date(p_pension_entry_values.opt_out_period_end_date));

537:
538: FOR entries IN C_ELEMENT_ENTRIES
539: LOOP
540: IF (p_pension_entry_values.opt_out_period_end_date) IS NOT NULL THEN
541: l_opt_out_new := greatest ((p_issue_date+30), fnd_date.canonical_to_date(p_pension_entry_values.opt_out_period_end_date));
542: ELSE
543: fnd_file.put_line(fnd_file.LOG,'No Opt-Out End Date found for this assignment');
544: END IF;
545: IF p_pension_entry_values.qualifying_scheme_exists = 'Y'

Line 562: P_INPUT_VALUE_ID2 => l_input_value_ids.auto_enrollment_date, P_ENTRY_VALUE2 => p_pension_entry_values.auto_enrollment_date,--fnd_date.canonical_to_date(p_pension_entry_values.auto_enrollment_date ),

558:
559: HR_ENTRY_API.UPDATE_ELEMENT_ENTRY (P_DT_UPDATE_MODE =>'UPDATE', P_SESSION_DATE => entries.START_DATE,
560: P_CHECK_FOR_UPDATE =>'N' , P_CREATOR_TYPE => 'F', P_ELEMENT_ENTRY_ID => entries.ELEMENT_ENTRY_ID ,
561: P_INPUT_VALUE_ID1 => l_input_value_ids.qualifying_scheme_name, P_ENTRY_VALUE1 => p_pension_entry_values.qualifying_scheme_name ,
562: P_INPUT_VALUE_ID2 => l_input_value_ids.auto_enrollment_date, P_ENTRY_VALUE2 => p_pension_entry_values.auto_enrollment_date,--fnd_date.canonical_to_date(p_pension_entry_values.auto_enrollment_date ),
563: P_INPUT_VALUE_ID3 => l_input_value_ids.pension_classification, P_ENTRY_VALUE3 => p_pension_entry_values.pension_classification ,
564: P_INPUT_VALUE_ID4 => l_input_value_ids.opt_out_period_end_date, P_ENTRY_VALUE4 => l_opt_out_new,--Date
565: P_INPUT_VALUE_ID5 => l_input_value_ids.total_earning_prp, P_ENTRY_VALUE5 => p_pension_entry_values.total_earning_prp,
566: P_INPUT_VALUE_ID6 => l_input_value_ids.postponement_type, P_ENTRY_VALUE6 => p_pension_entry_values.postponement_type,

Line 567: P_INPUT_VALUE_ID7 => l_input_value_ids.postponement_end_date, P_ENTRY_VALUE7 => p_pension_entry_values.postponement_end_date,--fnd_date.canonical_to_date(p_pension_entry_values.postponement_end_date),

563: P_INPUT_VALUE_ID3 => l_input_value_ids.pension_classification, P_ENTRY_VALUE3 => p_pension_entry_values.pension_classification ,
564: P_INPUT_VALUE_ID4 => l_input_value_ids.opt_out_period_end_date, P_ENTRY_VALUE4 => l_opt_out_new,--Date
565: P_INPUT_VALUE_ID5 => l_input_value_ids.total_earning_prp, P_ENTRY_VALUE5 => p_pension_entry_values.total_earning_prp,
566: P_INPUT_VALUE_ID6 => l_input_value_ids.postponement_type, P_ENTRY_VALUE6 => p_pension_entry_values.postponement_type,
567: P_INPUT_VALUE_ID7 => l_input_value_ids.postponement_end_date, P_ENTRY_VALUE7 => p_pension_entry_values.postponement_end_date,--fnd_date.canonical_to_date(p_pension_entry_values.postponement_end_date),
568: P_INPUT_VALUE_ID8 => l_input_value_ids.qualifying_scheme_exists, P_ENTRY_VALUE8 => l_scheme_exists,
569: P_INPUT_VALUE_ID9 => l_input_value_ids.opt_in_date, P_ENTRY_VALUE9 => p_pension_entry_values.opt_in_date,--fnd_date.canonical_to_date(p_pension_entry_values.opt_in_date),
570: P_INPUT_VALUE_ID10 => l_input_value_ids.elig_jh_date, P_ENTRY_VALUE10 => p_pension_entry_values.elig_jh_date,--fnd_date.canonical_to_date(p_pension_entry_values.elig_jh_date),
571: P_INPUT_VALUE_ID11 => l_input_value_ids.opt_out_date, P_ENTRY_VALUE11 => fnd_date.canonical_to_date(p_pension_entry_values.opt_out_date),

Line 569: P_INPUT_VALUE_ID9 => l_input_value_ids.opt_in_date, P_ENTRY_VALUE9 => p_pension_entry_values.opt_in_date,--fnd_date.canonical_to_date(p_pension_entry_values.opt_in_date),

565: P_INPUT_VALUE_ID5 => l_input_value_ids.total_earning_prp, P_ENTRY_VALUE5 => p_pension_entry_values.total_earning_prp,
566: P_INPUT_VALUE_ID6 => l_input_value_ids.postponement_type, P_ENTRY_VALUE6 => p_pension_entry_values.postponement_type,
567: P_INPUT_VALUE_ID7 => l_input_value_ids.postponement_end_date, P_ENTRY_VALUE7 => p_pension_entry_values.postponement_end_date,--fnd_date.canonical_to_date(p_pension_entry_values.postponement_end_date),
568: P_INPUT_VALUE_ID8 => l_input_value_ids.qualifying_scheme_exists, P_ENTRY_VALUE8 => l_scheme_exists,
569: P_INPUT_VALUE_ID9 => l_input_value_ids.opt_in_date, P_ENTRY_VALUE9 => p_pension_entry_values.opt_in_date,--fnd_date.canonical_to_date(p_pension_entry_values.opt_in_date),
570: P_INPUT_VALUE_ID10 => l_input_value_ids.elig_jh_date, P_ENTRY_VALUE10 => p_pension_entry_values.elig_jh_date,--fnd_date.canonical_to_date(p_pension_entry_values.elig_jh_date),
571: P_INPUT_VALUE_ID11 => l_input_value_ids.opt_out_date, P_ENTRY_VALUE11 => fnd_date.canonical_to_date(p_pension_entry_values.opt_out_date),
572: P_INPUT_VALUE_ID12 => l_input_value_ids.main_entry_id, P_ENTRY_VALUE12 => l_main_entry,
573: P_INPUT_VALUE_ID13 => l_input_value_ids.agg_earnings_pensions_id,P_ENTRY_VALUE13 => l_agg_earnings);

Line 570: P_INPUT_VALUE_ID10 => l_input_value_ids.elig_jh_date, P_ENTRY_VALUE10 => p_pension_entry_values.elig_jh_date,--fnd_date.canonical_to_date(p_pension_entry_values.elig_jh_date),

566: P_INPUT_VALUE_ID6 => l_input_value_ids.postponement_type, P_ENTRY_VALUE6 => p_pension_entry_values.postponement_type,
567: P_INPUT_VALUE_ID7 => l_input_value_ids.postponement_end_date, P_ENTRY_VALUE7 => p_pension_entry_values.postponement_end_date,--fnd_date.canonical_to_date(p_pension_entry_values.postponement_end_date),
568: P_INPUT_VALUE_ID8 => l_input_value_ids.qualifying_scheme_exists, P_ENTRY_VALUE8 => l_scheme_exists,
569: P_INPUT_VALUE_ID9 => l_input_value_ids.opt_in_date, P_ENTRY_VALUE9 => p_pension_entry_values.opt_in_date,--fnd_date.canonical_to_date(p_pension_entry_values.opt_in_date),
570: P_INPUT_VALUE_ID10 => l_input_value_ids.elig_jh_date, P_ENTRY_VALUE10 => p_pension_entry_values.elig_jh_date,--fnd_date.canonical_to_date(p_pension_entry_values.elig_jh_date),
571: P_INPUT_VALUE_ID11 => l_input_value_ids.opt_out_date, P_ENTRY_VALUE11 => fnd_date.canonical_to_date(p_pension_entry_values.opt_out_date),
572: P_INPUT_VALUE_ID12 => l_input_value_ids.main_entry_id, P_ENTRY_VALUE12 => l_main_entry,
573: P_INPUT_VALUE_ID13 => l_input_value_ids.agg_earnings_pensions_id,P_ENTRY_VALUE13 => l_agg_earnings);
574: END LOOP;

Line 571: P_INPUT_VALUE_ID11 => l_input_value_ids.opt_out_date, P_ENTRY_VALUE11 => fnd_date.canonical_to_date(p_pension_entry_values.opt_out_date),

567: P_INPUT_VALUE_ID7 => l_input_value_ids.postponement_end_date, P_ENTRY_VALUE7 => p_pension_entry_values.postponement_end_date,--fnd_date.canonical_to_date(p_pension_entry_values.postponement_end_date),
568: P_INPUT_VALUE_ID8 => l_input_value_ids.qualifying_scheme_exists, P_ENTRY_VALUE8 => l_scheme_exists,
569: P_INPUT_VALUE_ID9 => l_input_value_ids.opt_in_date, P_ENTRY_VALUE9 => p_pension_entry_values.opt_in_date,--fnd_date.canonical_to_date(p_pension_entry_values.opt_in_date),
570: P_INPUT_VALUE_ID10 => l_input_value_ids.elig_jh_date, P_ENTRY_VALUE10 => p_pension_entry_values.elig_jh_date,--fnd_date.canonical_to_date(p_pension_entry_values.elig_jh_date),
571: P_INPUT_VALUE_ID11 => l_input_value_ids.opt_out_date, P_ENTRY_VALUE11 => fnd_date.canonical_to_date(p_pension_entry_values.opt_out_date),
572: P_INPUT_VALUE_ID12 => l_input_value_ids.main_entry_id, P_ENTRY_VALUE12 => l_main_entry,
573: P_INPUT_VALUE_ID13 => l_input_value_ids.agg_earnings_pensions_id,P_ENTRY_VALUE13 => l_agg_earnings);
574: END LOOP;
575:

Line 1306: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||fnd_date.date_to_canonical(l_pay_start_date));

1302:
1303: OPEN c_payroll_details(p_period);
1304: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1305: CLOSE c_payroll_details;
1306: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||fnd_date.date_to_canonical(l_pay_start_date));
1307: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||fnd_date.date_to_canonical(l_pay_end_date));
1308: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1309:
1310: OPEN cur_input_id;

Line 1307: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||fnd_date.date_to_canonical(l_pay_end_date));

1303: OPEN c_payroll_details(p_period);
1304: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1305: CLOSE c_payroll_details;
1306: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||fnd_date.date_to_canonical(l_pay_start_date));
1307: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||fnd_date.date_to_canonical(l_pay_end_date));
1308: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1309:
1310: OPEN cur_input_id;
1311: FETCH cur_input_id INTO l_input_value_ids;

Line 1308: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));

1304: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1305: CLOSE c_payroll_details;
1306: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||fnd_date.date_to_canonical(l_pay_start_date));
1307: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||fnd_date.date_to_canonical(l_pay_end_date));
1308: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1309:
1310: OPEN cur_input_id;
1311: FETCH cur_input_id INTO l_input_value_ids;
1312: CLOSE cur_input_id;

Line 1325: fnd_file.put_line(fnd_file.LOG,'Before l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));

1321: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1322: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1323: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1324:
1325: fnd_file.put_line(fnd_file.LOG,'Before l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1326: fnd_file.put_line(fnd_file.LOG,'Before P_PAYROLL ::'||P_PAYROLL);
1327: OPEN c_prp_details(p_payroll);
1328: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;
1329: CLOSE c_prp_details;

Line 1564: fnd_date.canonical_to_date(p_issue_date),t_string );

1560:
1561:
1562: IF P_MODE = 'GENMAIL' THEN --Mode = Generate and Mail Inner
1563: generate_xml(p_letter ,assignment.assignment_id ,l_pension_entry_values ,P_PERIOD,p_payroll ,
1564: fnd_date.canonical_to_date(p_issue_date),t_string );
1565:
1566: l_string := l_string || t_string;
1567:
1568: fnd_file.put_line(fnd_file.LOG,'GENERATE_XML xml: '||l_string);

Line 1626: argument6 => fnd_date.date_to_canonical(sysdate) ,argument7 => 'PYGBPAEIGP' ,argument8 => 'PAY'

1622: --Testing For PDF
1623: p_request_id := fnd_request.submit_request (application => 'PAY' ,program => 'PYGBPAEIGP' ,argument1 => P_EMPLOYER ,argument2 =>P_PAYROLL ,
1624: argument3 => p_period , argument4 =>'PYGBPAEIGP' ,
1625: argument5 => 'GB' ,
1626: argument6 => fnd_date.date_to_canonical(sysdate) ,argument7 => 'PYGBPAEIGP' ,argument8 => 'PAY'
1627: --Template Name
1628: ,argument9 => 'PYGBPAEIG', argument10 =>P_ASSIGNMENT_SET ,
1629: argument11=>p_letter,argument12=>P_ISSUE_DATE, argument13 => 'N');
1630: --,argument9 => 'PYGBPAEIG', argument10 =>P_ASSIGNMENT_SET ,argument11 => 'N');

Line 1801: fnd_date.canonical_to_date(p_issue_date),t_string );

1797:
1798:
1799: fnd_file.put_line(fnd_file.LOG,'Before GENERATE_XML');
1800: generate_xml(p_letter ,assignment.assignment_id ,l_pension_entry_values ,P_PERIOD,p_payroll ,
1801: fnd_date.canonical_to_date(p_issue_date),t_string );
1802:
1803: l_string := l_string || t_string;
1804:
1805: fnd_file.put_line(fnd_file.LOG,'GENERATE_XML xml: '||l_string);