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.

[Home] [Help]

APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_ACTION_CONTEXTS

Line 311: pay_action_contexts pac,

307: UNION ALL
308:
309: SELECT distinct pac.assignment_id
310: FROM per_all_assignments_f paf,
311: pay_action_contexts pac,
312: pay_us_modified_geocodes pmod
313: WHERE pmod.state_code = 'CA'
314: AND pmod.county_code = pac.context_value
315: AND pac.context_id in (select context_id

Line 974: pay_action_contexts pac,

970: pmod.new_county_code jd_code,
971: paf.person_id, pmod.new_city_code, pmod.process_type,
972: pac.context_id
973: FROM per_all_assignments_f paf,
974: pay_action_contexts pac,
975: pay_us_modified_geocodes pmod
976: WHERE pmod.state_code = 'CA'
977: AND pmod.county_code = pac.context_value
978: AND pac.context_id in (select context_id

Line 1099: --Retrieves all affected rows in the table pay_action_contexts

1095:
1096: prr_rec prr_cur%ROWTYPE;
1097:
1098: --Per bug 2996546
1099: --Retrieves all affected rows in the table pay_action_contexts
1100: --
1101: --
1102: CURSOR pac_cur(assign_id NUMBER, context_id NUMBER) IS
1103: SELECT pac.context_id,

Line 1105: FROM pay_action_contexts pac,

1101: --
1102: CURSOR pac_cur(assign_id NUMBER, context_id NUMBER) IS
1103: SELECT pac.context_id,
1104: pac.assignment_action_id
1105: FROM pay_action_contexts pac,
1106: pay_assignment_actions paa
1107: WHERE paa.assignment_id = assign_id
1108: AND pac.assignment_id = paa.assignment_id -- Bug# 3679984 added this to where clause
1109: AND paa.assignment_action_id = pac.assignment_action_id

Line 1977: -- This procedure, PROCEDURE pay_action_contexts, will update the context values

1973: END run_results;
1974: --
1975: --
1976: --Per bug 2996546
1977: -- This procedure, PROCEDURE pay_action_contexts, will update the context values
1978: --based on assignment_action_id
1979: --
1980: --
1981: PROCEDURE pay_action_contexts

Line 1981: PROCEDURE pay_action_contexts

1977: -- This procedure, PROCEDURE pay_action_contexts, will update the context values
1978: --based on assignment_action_id
1979: --
1980: --
1981: PROCEDURE pay_action_contexts
1982: (p_proc_type IN VARCHAR2,
1983: p_person_id IN NUMBER,
1984: p_assign_id IN NUMBER,
1985: p_assign_act_id IN NUMBER,

Line 1994: FROM pay_action_contexts

1990:
1991: CURSOR pac_inside_cur(p_assign_act_id number, p_assign_id number,
1992: p_context_id number, p_old_juri_code varchar2)
1993: IS select 'Y'
1994: FROM pay_action_contexts
1995: WHERE assignment_action_id = p_assign_act_id
1996: AND assignment_id = p_assign_id
1997: AND context_id = p_context_id
1998: AND context_value = p_old_juri_code ;

Line 2004: hr_utility.trace('Entering pay_us_geo_upd_pkg.pay_action_contexts');

2000: l_pac_inside_exist varchar2(2);
2001:
2002: BEGIN
2003:
2004: hr_utility.trace('Entering pay_us_geo_upd_pkg.pay_action_contexts');
2005:
2006: IF ((p_proc_type <> 'SU' and p_proc_type <> 'US') and p_api_mode = 'N') THEN
2007:
2008: hr_utility.trace('Before update of pay_action_contexts for assignment id: '||to_char(p_assign_id));

Line 2008: hr_utility.trace('Before update of pay_action_contexts for assignment id: '||to_char(p_assign_id));

2004: hr_utility.trace('Entering pay_us_geo_upd_pkg.pay_action_contexts');
2005:
2006: IF ((p_proc_type <> 'SU' and p_proc_type <> 'US') and p_api_mode = 'N') THEN
2007:
2008: hr_utility.trace('Before update of pay_action_contexts for assignment id: '||to_char(p_assign_id));
2009:
2010: IF G_MODE = 'UPGRADE' THEN
2011:
2012: UPDATE pay_action_contexts

Line 2012: UPDATE pay_action_contexts

2008: hr_utility.trace('Before update of pay_action_contexts for assignment id: '||to_char(p_assign_id));
2009:
2010: IF G_MODE = 'UPGRADE' THEN
2011:
2012: UPDATE pay_action_contexts
2013: SET context_value = p_new_juri_code
2014: WHERE context_value = p_old_juri_code
2015: AND assignment_action_id = p_assign_act_id
2016: AND context_id = p_context_id ;

Line 2033: p_location => 'PAY_ACTION_CONTEXTS',

2029: p_person_id => p_person_id,
2030: p_assign_id => p_assign_id,
2031: p_old_juri_code => p_old_juri_code,
2032: p_new_juri_code => p_new_juri_code,
2033: p_location => 'PAY_ACTION_CONTEXTS',
2034: p_id => p_assign_id);
2035:
2036: END IF;
2037: CLOSE pac_inside_cur;

Line 2053: p_location => 'PAY_ACTION_CONTEXTS',

2049: p_person_id => p_person_id,
2050: p_assign_id => p_assign_id,
2051: p_old_juri_code => p_old_juri_code,
2052: p_new_juri_code => p_new_juri_code,
2053: p_location => 'PAY_ACTION_CONTEXTS',
2054: p_id => p_assign_id);
2055:
2056: END IF;
2057: CLOSE pac_inside_cur;

Line 2061: END pay_action_contexts;

2057: CLOSE pac_inside_cur;
2058:
2059: END IF;
2060:
2061: END pay_action_contexts;
2062: ---
2063: ---
2064: ---
2065:

Line 3070: -- Update pay_action_contexts . context value

3066: --
3067: --
3068:
3069: --Per bug 2996546
3070: -- Update pay_action_contexts . context value
3071: --
3072: --
3073:
3074: OPEN pac_cur(main_assign_id, main_city_tax_rule_id);

Line 3082: l_proc_stage := 'PAY_ACTION_CONTEXTS';

3078:
3079:
3080: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geocodes',240);
3081:
3082: l_proc_stage := 'PAY_ACTION_CONTEXTS';
3083:
3084: pay_action_contexts(
3085: p_proc_type => main_proc_type,
3086: p_person_id => main_person_id,

Line 3084: pay_action_contexts(

3080: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geocodes',240);
3081:
3082: l_proc_stage := 'PAY_ACTION_CONTEXTS';
3083:
3084: pay_action_contexts(
3085: p_proc_type => main_proc_type,
3086: p_person_id => main_person_id,
3087: p_assign_id => main_assign_id,
3088: p_assign_act_id => pac_rec.assignment_action_id,