APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_ARCHIVE

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

2284: /* Initialise the global PL/SQL table */
2285:
2286: for i in 1..l_context_no loop
2287:
2288: pay_archive.g_context_values.name(i) := NULL;
2289: pay_archive.g_context_values.value(i) := NULL;
2290:
2291: end loop;
2292:

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

2285:
2286: for i in 1..l_context_no loop
2287:
2288: pay_archive.g_context_values.name(i) := NULL;
2289: pay_archive.g_context_values.value(i) := NULL;
2290:
2291: end loop;
2292:
2293:

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

2302: fetch c_get_city into l_jurisdiction;
2303: exit when c_get_city%NOTFOUND;
2304:
2305: l_count := l_count + 1;
2306: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
2307: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
2308:
2309: end loop;
2310: close c_get_city;

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

2303: exit when c_get_city%NOTFOUND;
2304:
2305: l_count := l_count + 1;
2306: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
2307: pay_archive.g_context_values.value(l_count) := l_jurisdiction;
2308:
2309: end loop;
2310: close c_get_city;
2311:

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

2310: close c_get_city;
2311:
2312: If l_count = 0 then
2313: l_count := l_count + 1;
2314: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
2315: pay_archive.g_context_values.value(l_count) := g_sqwl_jursd;
2316: end if;
2317: pay_archive.g_context_values.sz := l_count;
2318:

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

2311:
2312: If l_count = 0 then
2313: l_count := l_count + 1;
2314: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
2315: pay_archive.g_context_values.value(l_count) := g_sqwl_jursd;
2316: end if;
2317: pay_archive.g_context_values.sz := l_count;
2318:
2319: end if;

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

2313: l_count := l_count + 1;
2314: pay_archive.g_context_values.name(l_count) := 'JURISDICTION_CODE';
2315: pay_archive.g_context_values.value(l_count) := g_sqwl_jursd;
2316: end if;
2317: pay_archive.g_context_values.sz := l_count;
2318:
2319: end if;
2320: /* End Bug 976472 */
2321:

Line 2366: pay_archive.balance_aa := aaid;

2362: where paa.assignment_action_id = p_assactid;
2363: END IF;
2364: END IF;
2365: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',aaid);
2366: pay_archive.balance_aa := aaid;
2367:
2368: end archive_data;
2369:
2370: /* Name : update_ff_archive_items