APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_ARCHIVE

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

3217: /* Initialise the global PL/SQL table */
3218:
3219: for i in 1..l_context_no loop
3220:
3221: pay_archive.g_context_values.name(i) := NULL;
3222: pay_archive.g_context_values.value(i) := NULL;
3223:
3224: end loop;
3225:

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

3218:
3219: for i in 1..l_context_no loop
3220:
3221: pay_archive.g_context_values.name(i) := NULL;
3222: pay_archive.g_context_values.value(i) := NULL;
3223:
3224: end loop;
3225:
3226:

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

3235: fetch c_get_city into l_jurisdiction;
3236: exit when c_get_city%NOTFOUND;
3237:
3238: l_count := l_count + 1;
3239: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3240: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
3241:
3242: end loop;
3243: close c_get_city;

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

3236: exit when c_get_city%NOTFOUND;
3237:
3238: l_count := l_count + 1;
3239: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3240: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
3241:
3242: end loop;
3243: close c_get_city;
3244:

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

3243: close c_get_city;
3244:
3245: If l_count = 0 then
3246: l_count := l_count + 1;
3247: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3248: pay_archive.g_context_values.value(l_count) := g_sqwl_jursd;
3249: end if;
3250: pay_archive.g_context_values.sz := l_count;
3251:

Line 3248: pay_archive.g_context_values.value(l_count) := g_sqwl_jursd;

3244:
3245: If l_count = 0 then
3246: l_count := l_count + 1;
3247: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3248: pay_archive.g_context_values.value(l_count) := g_sqwl_jursd;
3249: end if;
3250: pay_archive.g_context_values.sz := l_count;
3251:
3252: end if;

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

3246: l_count := l_count + 1;
3247: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
3248: pay_archive.g_context_values.value(l_count) := g_sqwl_jursd;
3249: end if;
3250: pay_archive.g_context_values.sz := l_count;
3251:
3252: end if;
3253: /* End Bug 976472 */
3254:

Line 3299: pay_archive.balance_aa := aaid;

3295: where paa.assignment_action_id = p_assactid;
3296: END IF;
3297: END IF;
3298: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',aaid);
3299: pay_archive.balance_aa := aaid;
3300:
3301: exception
3302: when others then
3303: hr_utility.trace('Problem in archive_data');