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_SQWL_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 70: and inserted archive_type in ff_archive_items.

66: and asg.effective_start_date <= l_period_end
67: instead of ppa.effective_date between
68: ASG.effective_start_date and ASG.effective_end_date
69: 02-Jun-2003 fusman 115.36 2965887 Checked for archive type in chk_gre_archive
70: and inserted archive_type in ff_archive_items.
71: 28-MAY-2003 tmehra 115.35 2981455 Made changes to the action_creation
72: Added code to error out in case
73: if the wage plan is missing at both
74: the Asg and the GRE level for CA.

Line 158: to update_ff_archive_items.

154: quarter.
155:
156: 11/16/2000 asasthan 115.8 1494215 Added A_SIT_PRE_TAX_REDNS_PER_JD_GRE_QTD
157: and A_SUI_ER_PRE_TAX_REDNS_PER_JD_GRE_QTD
158: to update_ff_archive_items.
159: 22-AUG-2000 ashgupta 110.12 1382408 Changed the SQL statement of
160: c_rts_dup_wage cursor. This SQL was
161: changed due to Fidelity issue. Now
162: the cursor does not check for Multi

Line 1618: insert into ff_archive_items

1614: begin
1615:
1616: l_step := 1;
1617:
1618: insert into ff_archive_items
1619: (ARCHIVE_ITEM_ID,
1620: USER_ENTITY_ID,
1621: CONTEXT1,
1622: VALUE,

Line 1625: (ff_archive_items_s.nextval,

1621: CONTEXT1,
1622: VALUE,
1623: ARCHIVE_TYPE)
1624: values
1625: (ff_archive_items_s.nextval,
1626: p_user_entity_id,
1627: p_context1,
1628: p_value,
1629: 'PPA'); /* Bug:2965887 */

Line 1641: (ff_archive_items_s.currval,

1637: SEQUENCE_NO,
1638: CONTEXT,
1639: CONTEXT_ID)
1640: values
1641: (ff_archive_items_s.currval,
1642: p_sequence(i),
1643: p_context(i),
1644: p_context_id(i));
1645: end loop;

Line 1650: hr_utility.trace('Error while inserting into ff_archive_items'

1646:
1647: exception
1648: when others then
1649: if l_step = 1 then
1650: hr_utility.trace('Error while inserting into ff_archive_items'
1651: || to_char(sqlcode));
1652: raise hr_utility.hr_error;
1653:
1654: elsif l_step = 2 then

Line 1809: from ff_archive_items fai

1805: cursor c_chk_payroll_action is
1806: select 'Y'
1807: from dual
1808: where exists (select null
1809: from ff_archive_items fai
1810: where fai.context1 = p_payroll_action_id
1811: and archive_type = 'PPA'); /* Bug:2965887 */
1812: begin
1813:

Line 2157: -- INSERT INTO ff_archive_items (archive_item_id,

2153: -- EXIT WHEN c_archive_wage_plan_code_rts%NOTFOUND;
2154: -- END IF;
2155: --
2156: --
2157: -- INSERT INTO ff_archive_items (archive_item_id,
2158: -- user_entity_id,
2159: -- context1,
2160: -- value)
2161: -- VALUES( ff_archive_items_s.NEXTVAL ,

Line 2161: -- VALUES( ff_archive_items_s.NEXTVAL ,

2157: -- INSERT INTO ff_archive_items (archive_item_id,
2158: -- user_entity_id,
2159: -- context1,
2160: -- value)
2161: -- VALUES( ff_archive_items_s.NEXTVAL ,
2162: -- l_user_entity_id ,
2163: -- p_assactid ,
2164: -- l_wage_plan_code );
2165: --

Line 2171: -- VALUES (ff_archive_items_s.currval,

2167: -- INSERT INTO ff_archive_item_contexts (archive_item_id,
2168: -- sequence_no ,
2169: -- context ,
2170: -- context_id )
2171: -- VALUES (ff_archive_items_s.currval,
2172: -- 1 ,
2173: -- l_assignment_id ,
2174: -- l_context_id_assignment_id);
2175: -- END LOOP;

Line 2196: INSERT INTO ff_archive_items (archive_item_id,

2192: hr_utility.trace('In Archive Wage Plan Code loop ');
2193:
2194: l_wage_plan_code := c_rec.aei_information3;
2195:
2196: INSERT INTO ff_archive_items (archive_item_id,
2197: user_entity_id,
2198: context1,
2199: value)
2200: VALUES( ff_archive_items_s.NEXTVAL ,

Line 2200: VALUES( ff_archive_items_s.NEXTVAL ,

2196: INSERT INTO ff_archive_items (archive_item_id,
2197: user_entity_id,
2198: context1,
2199: value)
2200: VALUES( ff_archive_items_s.NEXTVAL ,
2201: l_user_entity_id ,
2202: p_assactid ,
2203: l_wage_plan_code );
2204:

Line 2209: VALUES (ff_archive_items_s.currval,

2205: INSERT INTO ff_archive_item_contexts (archive_item_id,
2206: sequence_no ,
2207: context ,
2208: context_id )
2209: VALUES (ff_archive_items_s.currval,
2210: 1 ,
2211: asgid ,
2212: l_context_id_assignment_id);
2213:

Line 2231: INSERT INTO ff_archive_items (archive_item_id,

2227: END LOOP;
2228:
2229:
2230:
2231: INSERT INTO ff_archive_items (archive_item_id,
2232: user_entity_id,
2233: context1,
2234: value)
2235: VALUES( ff_archive_items_s.NEXTVAL ,

Line 2235: VALUES( ff_archive_items_s.NEXTVAL ,

2231: INSERT INTO ff_archive_items (archive_item_id,
2232: user_entity_id,
2233: context1,
2234: value)
2235: VALUES( ff_archive_items_s.NEXTVAL ,
2236: l_user_entity_id ,
2237: p_assactid ,
2238: l_wage_plan_code );
2239:

Line 2244: VALUES (ff_archive_items_s.currval,

2240: INSERT INTO ff_archive_item_contexts (archive_item_id,
2241: sequence_no ,
2242: context ,
2243: context_id )
2244: VALUES (ff_archive_items_s.currval,
2245: 1 ,
2246: asgid ,
2247: l_context_id_assignment_id);
2248:

Line 2370: /* Name : update_ff_archive_items

2366: pay_archive.balance_aa := aaid;
2367:
2368: end archive_data;
2369:
2370: /* Name : update_ff_archive_items
2371: Purpose : Given the SQWL payroll_action_id, identifies SQWL assignment actions for which
2372: serial number is set to 1 (those employee assgnment actions who doesnt have balances
2373: in the 4th Qtr while running 4th qtr new york SQWL report ) and update QTD balances
2374: to zero for the assignment action in ff_archive_items.

Line 2374: to zero for the assignment action in ff_archive_items.

2370: /* Name : update_ff_archive_items
2371: Purpose : Given the SQWL payroll_action_id, identifies SQWL assignment actions for which
2372: serial number is set to 1 (those employee assgnment actions who doesnt have balances
2373: in the 4th Qtr while running 4th qtr new york SQWL report ) and update QTD balances
2374: to zero for the assignment action in ff_archive_items.
2375: Arguments : SQWL Payroll Action ID
2376: */
2377:
2378: /* added A_SUI_ER_PRE_TAX_REDNS_PER_JD_GRE_QTD and A_SIT_PRE_TAX_REDNS_PER_JD_GRE_QTD

Line 2381: FUNCTION Update_ff_archive_items (p_payroll_action_id in VARCHAR2)

2377:
2378: /* added A_SUI_ER_PRE_TAX_REDNS_PER_JD_GRE_QTD and A_SIT_PRE_TAX_REDNS_PER_JD_GRE_QTD
2379: for bug 1494215 of NY Q4 */
2380:
2381: FUNCTION Update_ff_archive_items (p_payroll_action_id in VARCHAR2)
2382: return varchar is
2383: BEGIN
2384: update ff_archive_items ffai
2385: set ffai.value = 0

Line 2384: update ff_archive_items ffai

2380:
2381: FUNCTION Update_ff_archive_items (p_payroll_action_id in VARCHAR2)
2382: return varchar is
2383: BEGIN
2384: update ff_archive_items ffai
2385: set ffai.value = 0
2386: where ffai.user_entity_id in (
2387: select user_entity_id
2388: from ff_database_items

Line 2419: hr_utility.trace('Error while updating ff_archive_items ');

2415: return 'Y';
2416:
2417: EXCEPTION
2418: when OTHERS then
2419: hr_utility.trace('Error while updating ff_archive_items ');
2420: return 'N';
2421: END Update_ff_archive_items;
2422:
2423:

Line 2421: END Update_ff_archive_items;

2417: EXCEPTION
2418: when OTHERS then
2419: hr_utility.trace('Error while updating ff_archive_items ');
2420: return 'N';
2421: END Update_ff_archive_items;
2422:
2423:
2424: --Name
2425: -- preprocess_check

Line 2601: l_archive_item_id ff_archive_items.archive_item_id%type;

2597: AND ASG.Effective_end_date;
2598:
2599: l_location_id per_all_assignments_f.location_id%type;
2600: l_user_entity_id ff_user_entities.user_entity_id%type;
2601: l_archive_item_id ff_archive_items.archive_item_id%type;
2602: l_object_version_number ff_archive_items.object_version_number%type;
2603: l_some_warning boolean;
2604:
2605: l_procedure varchar2(16) := 'archive_asg_locs';

Line 2602: l_object_version_number ff_archive_items.object_version_number%type;

2598:
2599: l_location_id per_all_assignments_f.location_id%type;
2600: l_user_entity_id ff_user_entities.user_entity_id%type;
2601: l_archive_item_id ff_archive_items.archive_item_id%type;
2602: l_object_version_number ff_archive_items.object_version_number%type;
2603: l_some_warning boolean;
2604:
2605: l_procedure varchar2(16) := 'archive_asg_locs';
2606: