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_US_ARCHIVE dependencies on PAY_ARCHIVE

Line 3996: pay_archive.g_context_values.name(i) := NULL;

3992: l_step := 6;
3993:
3994: for i in 1..l_context_no loop
3995:
3996: pay_archive.g_context_values.name(i) := NULL;
3997: pay_archive.g_context_values.value(i) := NULL;
3998:
3999: end loop;
4000:

Line 3997: pay_archive.g_context_values.value(i) := NULL;

3993:
3994: for i in 1..l_context_no loop
3995:
3996: pay_archive.g_context_values.name(i) := NULL;
3997: pay_archive.g_context_values.value(i) := NULL;
3998:
3999: end loop;
4000:
4001: pay_archive.g_context_values.sz := 0;

Line 4001: pay_archive.g_context_values.sz := 0;

3997: pay_archive.g_context_values.value(i) := NULL;
3998:
3999: end loop;
4000:
4001: pay_archive.g_context_values.sz := 0;
4002:
4003: /* Set up the assignment id, date earned and tax unit id contexts */
4004:
4005: l_step := 7;

Line 4008: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';

4004:
4005: l_step := 7;
4006:
4007: l_count := l_count + 1;
4008: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
4009: pay_archive.g_context_values.value(l_count) := l_asgid;
4010: l_count := l_count + 1;
4011: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
4012: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);

Line 4009: pay_archive.g_context_values.value(l_count) := l_asgid;

4005: l_step := 7;
4006:
4007: l_count := l_count + 1;
4008: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
4009: pay_archive.g_context_values.value(l_count) := l_asgid;
4010: l_count := l_count + 1;
4011: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
4012: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
4013: l_count := l_count + 1;

Line 4011: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';

4007: l_count := l_count + 1;
4008: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
4009: pay_archive.g_context_values.value(l_count) := l_asgid;
4010: l_count := l_count + 1;
4011: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
4012: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
4013: l_count := l_count + 1;
4014: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';
4015: pay_archive.g_context_values.value(l_count) := l_taxunitid;

Line 4012: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);

4008: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
4009: pay_archive.g_context_values.value(l_count) := l_asgid;
4010: l_count := l_count + 1;
4011: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
4012: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
4013: l_count := l_count + 1;
4014: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';
4015: pay_archive.g_context_values.value(l_count) := l_taxunitid;
4016:

Line 4014: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';

4010: l_count := l_count + 1;
4011: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
4012: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
4013: l_count := l_count + 1;
4014: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';
4015: pay_archive.g_context_values.value(l_count) := l_taxunitid;
4016:
4017: hr_utility.trace('Initialised Pl/SQL table');
4018:

Line 4015: pay_archive.g_context_values.value(l_count) := l_taxunitid;

4011: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
4012: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
4013: l_count := l_count + 1;
4014: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';
4015: pay_archive.g_context_values.value(l_count) := l_taxunitid;
4016:
4017: hr_utility.trace('Initialised Pl/SQL table');
4018:
4019: /* Get the context_id for 'Jurisdiction' from ff_contexts */

Line 4079: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';

4075:
4076: l_step := 16;
4077:
4078: l_count := l_count + 1;
4079: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4080: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
4081:
4082: /* Insert rows into ff_archive_items and ff_archive_item_contexts
4083: for the city, county and state */

Line 4080: pay_archive.g_context_values.value(l_count) := l_jurisdiction;

4076: l_step := 16;
4077:
4078: l_count := l_count + 1;
4079: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4080: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
4081:
4082: /* Insert rows into ff_archive_items and ff_archive_item_contexts
4083: for the city, county and state */
4084:

Line 4184: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';

4180: end if;
4181:
4182: if l_true = 'N' then
4183: l_count := l_count + 1;
4184: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4185: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
4186: end if;
4187:
4188: /* Now archive the county */

Line 4185: pay_archive.g_context_values.value(l_count) := l_jurisdiction;

4181:
4182: if l_true = 'N' then
4183: l_count := l_count + 1;
4184: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4185: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
4186: end if;
4187:
4188: /* Now archive the county */
4189:

Line 4287: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';

4283:
4284:
4285: if l_true = 'N' then
4286: l_count := l_count + 1;
4287: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4288: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
4289: end if;
4290:
4291: if l_chk_state_archive = 'N' then

Line 4288: pay_archive.g_context_values.value(l_count) := l_jurisdiction;

4284:
4285: if l_true = 'N' then
4286: l_count := l_count + 1;
4287: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4288: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
4289: end if;
4290:
4291: if l_chk_state_archive = 'N' then
4292:

Line 4377: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';

4373: end if;
4374:
4375: if l_true = 'N' then
4376: l_count := l_count + 1;
4377: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4378: pay_archive.g_context_values.value(l_count) := substr(l_jurisdiction,1,8);
4379: end if;
4380: l_step := 42;
4381:

Line 4378: pay_archive.g_context_values.value(l_count) := substr(l_jurisdiction,1,8);

4374:
4375: if l_true = 'N' then
4376: l_count := l_count + 1;
4377: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4378: pay_archive.g_context_values.value(l_count) := substr(l_jurisdiction,1,8);
4379: end if;
4380: l_step := 42;
4381:
4382: if l_chk_cnt_sd_archive = 'N' then

Line 4457: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';

4453:
4454: if l_true = 'N' then
4455:
4456: l_count := l_count + 1;
4457: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4458: pay_archive.g_context_values.value(l_count) := substr(l_jurisdiction,1,8);
4459: end if;
4460: l_step := 48;
4461:

Line 4458: pay_archive.g_context_values.value(l_count) := substr(l_jurisdiction,1,8);

4454: if l_true = 'N' then
4455:
4456: l_count := l_count + 1;
4457: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
4458: pay_archive.g_context_values.value(l_count) := substr(l_jurisdiction,1,8);
4459: end if;
4460: l_step := 48;
4461:
4462: if l_chk_city_sd_archive = 'N' then

Line 4511: pay_archive.g_context_values.sz := l_count;

4507:
4508: l_step := 51;
4509:
4510: /* Set the no. of contexts */
4511: pay_archive.g_context_values.sz := l_count;
4512:
4513: if l_count = 1 then
4514: -- pay_balance_pkg.set_context ('JURISDICTION_CODE',lt_jursd_context(1));
4515: -- lt_jursd_context(1) := NULL;

Line 4516: hr_utility.trace('One context only name : ' || pay_archive.g_context_values.name(1));

4512:
4513: if l_count = 1 then
4514: -- pay_balance_pkg.set_context ('JURISDICTION_CODE',lt_jursd_context(1));
4515: -- lt_jursd_context(1) := NULL;
4516: hr_utility.trace('One context only name : ' || pay_archive.g_context_values.name(1));
4517: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));
4518: else
4519: for i in 1..l_count loop
4520: hr_utility.trace('Multiple context name : ' || pay_archive.g_context_values.name(i));

Line 4517: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));

4513: if l_count = 1 then
4514: -- pay_balance_pkg.set_context ('JURISDICTION_CODE',lt_jursd_context(1));
4515: -- lt_jursd_context(1) := NULL;
4516: hr_utility.trace('One context only name : ' || pay_archive.g_context_values.name(1));
4517: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));
4518: else
4519: for i in 1..l_count loop
4520: hr_utility.trace('Multiple context name : ' || pay_archive.g_context_values.name(i));
4521: hr_utility.trace('Multiple context value : ' || pay_archive.g_context_values.value(i));

Line 4520: hr_utility.trace('Multiple context name : ' || pay_archive.g_context_values.name(i));

4516: hr_utility.trace('One context only name : ' || pay_archive.g_context_values.name(1));
4517: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));
4518: else
4519: for i in 1..l_count loop
4520: hr_utility.trace('Multiple context name : ' || pay_archive.g_context_values.name(i));
4521: hr_utility.trace('Multiple context value : ' || pay_archive.g_context_values.value(i));
4522: -- hr_utility.trace('Multiple context ('|| to_char(i)||') : ' || lt_jursd_context(i));
4523: end loop;
4524: end if;

Line 4521: hr_utility.trace('Multiple context value : ' || pay_archive.g_context_values.value(i));

4517: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));
4518: else
4519: for i in 1..l_count loop
4520: hr_utility.trace('Multiple context name : ' || pay_archive.g_context_values.name(i));
4521: hr_utility.trace('Multiple context value : ' || pay_archive.g_context_values.value(i));
4522: -- hr_utility.trace('Multiple context ('|| to_char(i)||') : ' || lt_jursd_context(i));
4523: end loop;
4524: end if;
4525:

Line 4526: hr_utility.trace('g_context_values.sz : ' || pay_archive.g_context_values.sz);

4522: -- hr_utility.trace('Multiple context ('|| to_char(i)||') : ' || lt_jursd_context(i));
4523: end loop;
4524: end if;
4525:
4526: hr_utility.trace('g_context_values.sz : ' || pay_archive.g_context_values.sz);
4527:
4528: /* Flush all jurisdiction contexts */
4529:
4530: hr_utility.trace('l_jd_done_tab....first : '|| l_jd_done_tab.first);

Line 4890: pay_archive.balance_aa := l_aaid;

4886: l_step := 94;
4887:
4888: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
4889: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
4890: pay_archive.balance_aa := l_aaid;
4891:
4892: l_step := 95;
4893: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
4894: