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 3364: pay_archive.g_context_values.name(i) := NULL;

3360: l_step := 6;
3361:
3362: for i in 1..l_context_no loop
3363:
3364: pay_archive.g_context_values.name(i) := NULL;
3365: pay_archive.g_context_values.value(i) := NULL;
3366:
3367: end loop;
3368:

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

3361:
3362: for i in 1..l_context_no loop
3363:
3364: pay_archive.g_context_values.name(i) := NULL;
3365: pay_archive.g_context_values.value(i) := NULL;
3366:
3367: end loop;
3368:
3369: pay_archive.g_context_values.sz := 0;

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

3365: pay_archive.g_context_values.value(i) := NULL;
3366:
3367: end loop;
3368:
3369: pay_archive.g_context_values.sz := 0;
3370:
3371: /* Set up the assignment id, date earned and tax unit id contexts */
3372:
3373: l_step := 7;

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

3372:
3373: l_step := 7;
3374:
3375: l_count := l_count + 1;
3376: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
3377: pay_archive.g_context_values.value(l_count) := l_asgid;
3378: l_count := l_count + 1;
3379: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
3380: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);

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

3373: l_step := 7;
3374:
3375: l_count := l_count + 1;
3376: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
3377: pay_archive.g_context_values.value(l_count) := l_asgid;
3378: l_count := l_count + 1;
3379: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
3380: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
3381: l_count := l_count + 1;

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

3375: l_count := l_count + 1;
3376: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
3377: pay_archive.g_context_values.value(l_count) := l_asgid;
3378: l_count := l_count + 1;
3379: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
3380: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
3381: l_count := l_count + 1;
3382: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';
3383: pay_archive.g_context_values.value(l_count) := l_taxunitid;

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

3376: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
3377: pay_archive.g_context_values.value(l_count) := l_asgid;
3378: l_count := l_count + 1;
3379: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
3380: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
3381: l_count := l_count + 1;
3382: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';
3383: pay_archive.g_context_values.value(l_count) := l_taxunitid;
3384:

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

3378: l_count := l_count + 1;
3379: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
3380: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
3381: l_count := l_count + 1;
3382: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';
3383: pay_archive.g_context_values.value(l_count) := l_taxunitid;
3384:
3385: hr_utility.trace('Initialised Pl/SQL table');
3386:

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

3379: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
3380: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
3381: l_count := l_count + 1;
3382: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';
3383: pay_archive.g_context_values.value(l_count) := l_taxunitid;
3384:
3385: hr_utility.trace('Initialised Pl/SQL table');
3386:
3387: /* Get the context_id for 'Jurisdiction' from ff_contexts */

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

3443:
3444: l_step := 16;
3445:
3446: l_count := l_count + 1;
3447: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3448: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
3449:
3450: /* Insert rows into ff_archive_items and ff_archive_item_contexts
3451: for the city, county and state */

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

3444: l_step := 16;
3445:
3446: l_count := l_count + 1;
3447: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3448: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
3449:
3450: /* Insert rows into ff_archive_items and ff_archive_item_contexts
3451: for the city, county and state */
3452:

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

3548: end if;
3549:
3550: if l_true = 'N' then
3551: l_count := l_count + 1;
3552: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3553: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
3554: end if;
3555:
3556: /* Now archive the county */

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

3549:
3550: if l_true = 'N' then
3551: l_count := l_count + 1;
3552: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3553: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
3554: end if;
3555:
3556: /* Now archive the county */
3557:

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

3651:
3652:
3653: if l_true = 'N' then
3654: l_count := l_count + 1;
3655: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3656: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
3657: end if;
3658:
3659: if l_chk_state_archive = 'N' then

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

3652:
3653: if l_true = 'N' then
3654: l_count := l_count + 1;
3655: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3656: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
3657: end if;
3658:
3659: if l_chk_state_archive = 'N' then
3660:

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

3741: end if;
3742:
3743: if l_true = 'N' then
3744: l_count := l_count + 1;
3745: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3746: pay_archive.g_context_values.value(l_count) := substr(l_jurisdiction,1,8);
3747: end if;
3748: l_step := 42;
3749:

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

3742:
3743: if l_true = 'N' then
3744: l_count := l_count + 1;
3745: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3746: pay_archive.g_context_values.value(l_count) := substr(l_jurisdiction,1,8);
3747: end if;
3748: l_step := 42;
3749:
3750: if l_chk_cnt_sd_archive = 'N' then

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

3821:
3822: if l_true = 'N' then
3823:
3824: l_count := l_count + 1;
3825: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3826: pay_archive.g_context_values.value(l_count) := substr(l_jurisdiction,1,8);
3827: end if;
3828: l_step := 48;
3829:

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

3822: if l_true = 'N' then
3823:
3824: l_count := l_count + 1;
3825: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3826: pay_archive.g_context_values.value(l_count) := substr(l_jurisdiction,1,8);
3827: end if;
3828: l_step := 48;
3829:
3830: if l_chk_city_sd_archive = 'N' then

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

3875:
3876: l_step := 51;
3877:
3878: /* Set the no. of contexts */
3879: pay_archive.g_context_values.sz := l_count;
3880:
3881: if l_count = 1 then
3882: -- pay_balance_pkg.set_context ('JURISDICTION_CODE',lt_jursd_context(1));
3883: -- lt_jursd_context(1) := NULL;

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

3880:
3881: if l_count = 1 then
3882: -- pay_balance_pkg.set_context ('JURISDICTION_CODE',lt_jursd_context(1));
3883: -- lt_jursd_context(1) := NULL;
3884: hr_utility.trace('One context only name : ' || pay_archive.g_context_values.name(1));
3885: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));
3886: else
3887: for i in 1..l_count loop
3888: hr_utility.trace('Multiple context name : ' || pay_archive.g_context_values.name(i));

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

3881: if l_count = 1 then
3882: -- pay_balance_pkg.set_context ('JURISDICTION_CODE',lt_jursd_context(1));
3883: -- lt_jursd_context(1) := NULL;
3884: hr_utility.trace('One context only name : ' || pay_archive.g_context_values.name(1));
3885: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));
3886: else
3887: for i in 1..l_count loop
3888: hr_utility.trace('Multiple context name : ' || pay_archive.g_context_values.name(i));
3889: hr_utility.trace('Multiple context value : ' || pay_archive.g_context_values.value(i));

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

3884: hr_utility.trace('One context only name : ' || pay_archive.g_context_values.name(1));
3885: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));
3886: else
3887: for i in 1..l_count loop
3888: hr_utility.trace('Multiple context name : ' || pay_archive.g_context_values.name(i));
3889: hr_utility.trace('Multiple context value : ' || pay_archive.g_context_values.value(i));
3890: -- hr_utility.trace('Multiple context ('|| to_char(i)||') : ' || lt_jursd_context(i));
3891: end loop;
3892: end if;

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

3885: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));
3886: else
3887: for i in 1..l_count loop
3888: hr_utility.trace('Multiple context name : ' || pay_archive.g_context_values.name(i));
3889: hr_utility.trace('Multiple context value : ' || pay_archive.g_context_values.value(i));
3890: -- hr_utility.trace('Multiple context ('|| to_char(i)||') : ' || lt_jursd_context(i));
3891: end loop;
3892: end if;
3893:

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

3890: -- hr_utility.trace('Multiple context ('|| to_char(i)||') : ' || lt_jursd_context(i));
3891: end loop;
3892: end if;
3893:
3894: hr_utility.trace('g_context_values.sz : ' || pay_archive.g_context_values.sz);
3895:
3896: /* Flush all jurisdiction contexts */
3897:
3898: hr_utility.trace('l_jd_done_tab....first : '|| l_jd_done_tab.first);

Line 4221: pay_archive.balance_aa := l_aaid;

4217: l_step := 94;
4218:
4219: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
4220: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
4221: pay_archive.balance_aa := l_aaid;
4222:
4223: l_step := 95;
4224: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
4225: