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_EOY_RL1_ARCHIVE dependencies on FF_ARCHIVE_API

Line 288: to ff_archive_api.create_archive_item.

284: archived in eoy_archive_data.
285: 08-May-2009 sapalani 115.102 8500723 Added function getnext_seq_num to
286: calculate check digit for PDF sequence.
287: In function gen_rl1_pdf_seq added call
288: to ff_archive_api.create_archive_item.
289: This archives CAEOY_RL1_PDF_SEQ_NUMBER
290: when PDF is run for a period and
291: archive item doesn't exist in that
292: period.

Line 294: call to ff_archive_api.update_archive

290: when PDF is run for a period and
291: archive item doesn't exist in that
292: period.
293: 17-Aug-2009 sapalani 115.103 8732218 In function gen_rl1_pdf_seq, replaced
294: call to ff_archive_api.update_archive
295: _item with direct update statement.
296: 09-Sep-2009 sapalani 115.104 6853279 Added order by clause to cursor
297: cur_non_box_mesg.
298: 24-Nov-2009 sneelapa 115.105 9135372 Modified eoy_archive_data procedure to

Line 1545: ff_archive_api.create_archive_item(

1541: l_counter := 1;
1542: l_user_entity_name := 'CAEOY_RL1_QUEBEC_BN';
1543:
1544: hr_utility.trace('Archiving AAC level data for ' || to_char(lockingactid));
1545: ff_archive_api.create_archive_item(
1546: p_archive_item_id => l_archive_item_id
1547: ,p_user_entity_id => get_user_entity_id(l_user_entity_name)
1548: ,p_archive_value => l_pre_organization_id
1549: ,p_archive_type => 'AAC'

Line 2055: ff_archive_api.create_archive_item(

2051: /*hr_utility.trace_on('Y','RL1'); */
2052:
2053: hr_utility.trace('user_entity id is : ' || l_user_entity_name_tab(i));
2054:
2055: ff_archive_api.create_archive_item(
2056: p_archive_item_id => l_archive_item_id
2057: ,p_user_entity_id => get_user_entity_id(l_user_entity_name_tab(i))
2058: ,p_archive_value => l_user_entity_value_tab(i)
2059: ,p_archive_type => 'PA'

Line 2282: ff_archive_api.create_archive_item(

2278: if (called_from ='XMLPROC') then
2279: if(l_archive_item_id is null) then --If DBI is not archived when PDF is run
2280: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 40');
2281:
2282: ff_archive_api.create_archive_item(
2283: p_archive_item_id => l_archive_item_id
2284: ,p_user_entity_id => get_user_entity_id('CAEOY_RL1_PDF_SEQ_NUMBER')
2285: ,p_archive_value => l_final_seq_num
2286: ,p_archive_type => 'AAP'

Line 2298: ff_archive_api.update_archive_item( p_archive_item_id => l_archive_item_id

2294: else -- If DBI is archived but with null value then update it with new value
2295: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 50');
2296:
2297: /* Commented for bug 8732218
2298: ff_archive_api.update_archive_item( p_archive_item_id => l_archive_item_id
2299: ,p_effective_date => fnd_date.string_to_date('31/12/'||p_reporting_year,'DD/MM/YYYY')
2300: --,p_validate in boolean default false
2301: ,p_archive_value => l_final_seq_num
2302: ,p_object_version_number => l_obj_ver

Line 2751: ff_archive_api.create_archive_item(

2747: hr_utility.trace('This Tax unit id has no payroll run, so skip it');
2748: end;
2749: end loop; -- end of c_all_gres_for_further_info
2750: close c_all_gres_for_further_info;
2751: ff_archive_api.create_archive_item(
2752: p_archive_item_id => l_archive_item_id
2753: ,p_user_entity_id =>
2754: get_footnote_user_entity_id(l_user_entity_name_tab(i))
2755: ,p_archive_value => result

Line 3338: ff_archive_api.create_archive_item(

3334: l_count := l_count + 1;
3335:
3336: hr_utility.trace('archiving CAEOY_RL1_PROVINCE_OF_EMPLOYMENT');
3337:
3338: ff_archive_api.create_archive_item(
3339: /*p_validate => 'TRUE' */
3340: p_archive_item_id => l_archive_item_id
3341: ,p_user_entity_id =>
3342: get_user_entity_id('CAEOY_RL1_PROVINCE_OF_EMPLOYMENT')

Line 3913: ff_archive_api.create_archive_item(

3909:
3910: if get_footnote_user_entity_id(l_footnote_amount_ue)<>0
3911: and l_footnote_amount <> 0
3912: then
3913: ff_archive_api.create_archive_item(
3914: p_archive_item_id => l_archive_item_id
3915: ,p_user_entity_id =>
3916: get_footnote_user_entity_id(l_footnote_amount_ue)
3917: ,p_archive_value => l_footnote_amount

Line 4039: ff_archive_api.create_archive_item(

4035:
4036: if get_footnote_user_entity_id(l_footnote_amount_ue) <> 0
4037: and l_footnote_amount <> 0 then
4038:
4039: ff_archive_api.create_archive_item(
4040: p_archive_item_id => l_archive_item_id
4041: ,p_user_entity_id =>
4042: get_footnote_user_entity_id(l_footnote_amount_ue)
4043: ,p_archive_value => l_footnote_amount

Line 4074: ff_archive_api.create_archive_item(

4070: hr_utility.trace('l_user_entity_value_tab(i) ='|| l_user_entity_value_tab(i));
4071: hr_utility.trace('p_assactid ='|| p_assactid);
4072: hr_utility.trace('l_object_version_number ='|| l_object_version_number);
4073: -- hr_utility.trace('l_some_warning ='|| l_some_warning);
4074: ff_archive_api.create_archive_item(
4075: /* p_validate => 'TRUE' */
4076: p_archive_item_id => l_archive_item_id
4077: ,p_user_entity_id =>
4078: get_user_entity_id(l_user_entity_name_tab(i))

Line 4135: ff_archive_api.create_archive_item(

4131: if l_user_entity_value_tab_boxo < 0 then
4132: l_negative_balance_exists := 'Y';
4133: end if;
4134:
4135: ff_archive_api.create_archive_item(
4136: p_archive_item_id => l_archive_item_id
4137: ,p_user_entity_id =>
4138: get_user_entity_id('CAEOY_RL1_BOXO_PER_JD_YTD')
4139: ,p_archive_value => l_user_entity_value_tab_boxo

Line 4149: ff_archive_api.create_archive_item(

4145: ,p_context1 => 'QC'
4146: ,p_some_warning => l_some_warning
4147: );
4148:
4149: ff_archive_api.create_archive_item(
4150: /* p_validate => 'TRUE' */
4151: p_archive_item_id => l_archive_item_id
4152: ,p_user_entity_id =>
4153: get_user_entity_id('CAEOY_RL1_BOXO_CODE_PER_JD_YTD')

Line 4251: ff_archive_api.create_archive_item(

4247: end loop;
4248: close c_all_gres_for_person;
4249: hr_utility.trace('closed all GREs for the person');
4250:
4251: ff_archive_api.create_archive_item(
4252: /* p_validate => 'TRUE' */
4253: p_archive_item_id => l_archive_item_id
4254: ,p_user_entity_id =>
4255: get_user_entity_id('CAEOY_CPP_EE_WITHHELD_PER_YTD')

Line 4275: ff_archive_api.create_archive_item(

4271: l_negative_balance_exists := 'Y';
4272: end if;
4273:
4274: /* Bug 14701466,15914635 sbachu*/
4275: ff_archive_api.create_archive_item(
4276: /* p_validate => 'TRUE' */
4277: p_archive_item_id => l_archive_item_id
4278: ,p_user_entity_id =>
4279: get_user_entity_id('CAEOY_CPP_EE_TAXABLE_PER_YTD')

Line 4372: ff_archive_api.create_archive_item(

4368: end if;
4369:
4370: /* archive RL1 slip number */
4371:
4372: ff_archive_api.create_archive_item(
4373: /* p_validate => 'TRUE' */
4374: p_archive_item_id => l_archive_item_id
4375: ,p_user_entity_id =>
4376: get_user_entity_id('CAEOY_RL1_SLIP_NUMBER')

Line 4386: ff_archive_api.create_archive_item(

4382: ,p_some_warning => l_some_warning );
4383:
4384: /* archiving RL1 PDF Sequence Number -Bug 6768167*/
4385:
4386: ff_archive_api.create_archive_item(
4387: p_archive_item_id => l_archive_item_id
4388: ,p_user_entity_id =>
4389: get_user_entity_id('CAEOY_RL1_PDF_SEQ_NUMBER')
4390: ,p_archive_value => l_rl1_seq_number

Line 4680: ff_archive_api.create_archive_item(

4676:
4677: --hr_utility.trace_off;
4678: end;
4679:
4680: ff_archive_api.create_archive_item(
4681: p_archive_item_id => l_archive_item_id
4682: ,p_user_entity_id =>
4683: get_user_entity_id('CAEOY_RL1_NEGATIVE_BALANCE_EXISTS')
4684: ,p_archive_value => l_negative_balance_exists

Line 4855: ff_archive_api.create_archive_item(

4851: loop
4852:
4853: hr_utility.trace('inside create loop '||l_user_entity_value_tab(i));
4854:
4855: ff_archive_api.create_archive_item(
4856: /* p_validate => 'TRUE' */
4857: p_archive_item_id => l_archive_item_id
4858: ,p_user_entity_id =>
4859: get_user_entity_id(l_user_entity_name_tab(i))

Line 4932: ff_archive_api.create_archive_item(

4928:
4929:
4930: for i in 1 .. l_counter
4931: loop
4932: ff_archive_api.create_archive_item(
4933: p_archive_item_id => l_archive_item_id
4934: ,p_user_entity_id =>
4935: get_user_entity_id(l_user_entity_name_tab(i))
4936: ,p_archive_value => l_user_entity_value_tab(i)

Line 4996: ff_archive_api.create_archive_item(

4992: close c_get_preprinted_form_no;
4993:
4994: if ln_form_no_archived = 'Y' then
4995:
4996: ff_archive_api.create_archive_item(
4997: p_archive_item_id => l_archive_item_id
4998: ,p_user_entity_id => get_user_entity_id('CAEOY_RL1_PRE_PRINTED_FORM_NO')
4999: ,p_archive_value => lv_pre_pr_form_no
5000: ,p_archive_type => 'AAP'

Line 5009: ff_archive_api.create_archive_item(

5005: ,p_context1 => 'QC'
5006: ,p_some_warning => l_some_warning
5007: );
5008: else
5009: ff_archive_api.create_archive_item(
5010: p_archive_item_id => l_archive_item_id
5011: ,p_user_entity_id => get_user_entity_id('CAEOY_RL1_PRE_PRINTED_FORM_NO')
5012: ,p_archive_value => NULL
5013: ,p_archive_type => 'AAP'

Line 5056: ff_archive_api.create_archive_item(

5052:
5053: hr_utility.trace('Jurisdiction is : ' || lv_fapp_prov);
5054: hr_utility.trace('Archiving RL1 Amendment Flag : ' || lv_fapp_flag);
5055:
5056: ff_archive_api.create_archive_item(
5057: p_archive_item_id => l_archive_item_id
5058: ,p_user_entity_id => get_user_entity_id('CAEOY_RL1_AMENDMENT_FLAG')
5059: ,p_archive_value => lv_fapp_flag
5060: ,p_archive_type => 'AAP'