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_QPQ_API dependencies on PAY_ASSIGNMENT_ACTIONS

Line 92: INDEX(ASGT_ACTION PAY_ASSIGNMENT_ACTIONS_N50)

88:
89: ) is
90:
91: select /*+ ORDERED INDEX(PAY_ACTION PAY_PAYROLL_ACTIONS_PK)
92: INDEX(ASGT_ACTION PAY_ASSIGNMENT_ACTIONS_N50)
93: INDEX(QP_INCL PAY_QUICKPAY_INCLUSIONS_FK2)
94: INDEX(ENTRY PAY_ELEMENT_ENTRIES_F_PK)
95: INDEX(LINK PAY_ELEMENT_LINKS_F_PK)
96: INDEX(ELEMENT PAY_ELEMENT_TYPES_F_PK)

Line 104: pay_assignment_actions ASGT_ACTION,

100: USE_NL(QP_INCL, ENTRY) USE_NL(ENTRY, LINK) USE_NL(LINK, ELEMENT)
101: USE_NL(ELEMENT, CLASS) USE_NL(CLASS, ENTVAL) */
102: count (*) TOTAL_OF_ROWS
103: from pay_payroll_actions PAY_ACTION,
104: pay_assignment_actions ASGT_ACTION,
105: pay_quickpay_inclusions QP_INCL,
106: pay_element_entries_f ENTRY,
107: pay_element_links_f LINK,
108: pay_element_types_f ELEMENT,

Line 188: INDEX(ASGT_ACTION PAY_ASSIGNMENT_ACTIONS_N50)

184:
185: ) is
186:
187: select /*+ ORDERED INDEX(PAY_ACTION PAY_PAYROLL_ACTIONS_PK)
188: INDEX(ASGT_ACTION PAY_ASSIGNMENT_ACTIONS_N50)
189: INDEX(ENTRY PAY_ELEMENT_ENTRIES_F_N50)
190: INDEX(LINK PAY_ELEMENT_LINKS_F_PK)
191: INDEX(ELEMENT PAY_ELEMENT_TYPES_F_PK)
192: INDEX(CLASS PAY_ELEMENT_CLASSIFICATION_PK)

Line 199: pay_assignment_actions ASGT_ACTION,

195: USE_NL(LINK, ELEMENT) USE_NL(ELEMENT, CLASS)
196: USE_NL(CLASS, ENTVAL) */
197: count (*) TOTAL_OF_ROWS
198: from pay_payroll_actions PAY_ACTION,
199: pay_assignment_actions ASGT_ACTION,
200: pay_element_entries_f ENTRY,
201: pay_element_links_f LINK,
202: pay_element_types_f ELEMENT,
203: pay_element_classifications CLASS,

Line 401: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE

397: -- |-------------------------< chk_asg_on_payroll >---------------------------|
398: -- ----------------------------------------------------------------------------
399: --
400: procedure chk_asg_on_payroll
401: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
402: ) is
403: --
404: v_exists varchar2(1);
405: v_proc varchar2(72) := g_package||'chk_asg_on_payroll';

Line 531: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE

527: --
528: -- {End Of Comments}
529: --
530: procedure chk_assignment
531: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
532: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
533: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
534: ) is
535: --

Line 808: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE

804: --
805: -- {End Of Comments}
806: --
807: function get_date_earned_for_gb
808: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
809: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
810: ) return pay_payroll_actions.date_earned%TYPE is
811: --
812: -- Cursor definitions

Line 978: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE

974: -- ----------------------------------------------------------------------------
975: --
976: procedure chk_eff_date
977: (p_effective_date in pay_payroll_actions.effective_date%TYPE
978: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
979: ,p_legislation_code in per_business_groups.legislation_code%TYPE
980: ,p_recal_date_earned in boolean
981: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
982: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE

Line 1145: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE

1141: -- {End Of Comments}
1142: --
1143: procedure chk_date_earned_for_gb
1144: (p_date_earned in pay_payroll_actions.date_earned%TYPE
1145: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1146: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1147: ) is
1148: --
1149: v_df_date_earned pay_payroll_actions.date_earned%TYPE;

Line 1181: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE

1177: -- ----------------------------------------------------------------------------
1178: --
1179: procedure chk_date_earned
1180: (p_date_earned in pay_payroll_actions.date_earned%TYPE
1181: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1182: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1183: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1184: ,p_payroll_id in out nocopy pay_payroll_actions.payroll_id%TYPE
1185: ,p_time_period_id in out nocopy pay_payroll_actions.time_period_id%TYPE

Line 1325: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE

1321: --
1322: procedure chk_eff_earned_payroll
1323: (p_effective_date in pay_payroll_actions.effective_date%TYPE
1324: ,p_date_earned in pay_payroll_actions.date_earned%TYPE
1325: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1326: ,p_raise_error in boolean
1327: ,p_same_payroll out nocopy boolean
1328: ) is
1329: --

Line 2289: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

2285: ,p_assignment_action_id out nocopy number
2286: ,p_a_object_version_number out nocopy number
2287: ) is
2288: --
2289: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
2290: v_object_version_number pay_assignment_actions.object_version_number%TYPE;
2291: v_proc varchar2(72) := g_package||'post_insert';
2292: --
2293: begin

Line 2290: v_object_version_number pay_assignment_actions.object_version_number%TYPE;

2286: ,p_a_object_version_number out nocopy number
2287: ) is
2288: --
2289: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
2290: v_object_version_number pay_assignment_actions.object_version_number%TYPE;
2291: v_proc varchar2(72) := g_package||'post_insert';
2292: --
2293: begin
2294: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 2787: pay_assignment_actions.object_version_number%TYPE

2783: procedure lck_general
2784: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2785: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2786: ,p_a_object_version_number in
2787: pay_assignment_actions.object_version_number%TYPE
2788: ,p_only_action_type in pay_payroll_actions.action_type%TYPE
2789: ,p_actual_action_type out nocopy pay_payroll_actions.action_type%TYPE
2790: ,p_a_action_status out nocopy pay_assignment_actions.
2791: action_status%TYPE

Line 2790: ,p_a_action_status out nocopy pay_assignment_actions.

2786: ,p_a_object_version_number in
2787: pay_assignment_actions.object_version_number%TYPE
2788: ,p_only_action_type in pay_payroll_actions.action_type%TYPE
2789: ,p_actual_action_type out nocopy pay_payroll_actions.action_type%TYPE
2790: ,p_a_action_status out nocopy pay_assignment_actions.
2791: action_status%TYPE
2792: ) is
2793: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
2794: --

Line 2793: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;

2789: ,p_actual_action_type out nocopy pay_payroll_actions.action_type%TYPE
2790: ,p_a_action_status out nocopy pay_assignment_actions.
2791: action_status%TYPE
2792: ) is
2793: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
2794: --
2795: -- Cursor selects the 'current' row from the HR Schema
2796: -- (Locks pay_payroll_actions first, then pay_assignment_actions.)
2797: --

Line 2796: -- (Locks pay_payroll_actions first, then pay_assignment_actions.)

2792: ) is
2793: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
2794: --
2795: -- Cursor selects the 'current' row from the HR Schema
2796: -- (Locks pay_payroll_actions first, then pay_assignment_actions.)
2797: --
2798: Cursor C_Sel1 is
2799: select pya.payroll_action_id
2800: , pya.business_group_id

Line 2816: , pay_assignment_actions aga

2812: , pya.action_type
2813: , aga.action_status
2814: , aga.object_version_number
2815: from pay_payroll_actions pya
2816: , pay_assignment_actions aga
2817: where /* Payroll action lock */
2818: pya.payroll_action_id = p_payroll_action_id
2819: and ( pya.action_type = p_only_action_type
2820: or ( p_only_action_type is null

Line 2919: pay_assignment_actions.object_version_number%TYPE

2915: procedure lck
2916: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2917: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2918: ,p_a_object_version_number in
2919: pay_assignment_actions.object_version_number%TYPE
2920: ) is
2921: v_unwanted_type pay_payroll_actions.action_type%TYPE;
2922: v_unwanted_status pay_assignment_actions.action_status%TYPE;
2923: begin

Line 2922: v_unwanted_status pay_assignment_actions.action_status%TYPE;

2918: ,p_a_object_version_number in
2919: pay_assignment_actions.object_version_number%TYPE
2920: ) is
2921: v_unwanted_type pay_payroll_actions.action_type%TYPE;
2922: v_unwanted_status pay_assignment_actions.action_status%TYPE;
2923: begin
2924: --
2925: -- Lock the row only if it is a QuickPay Run action
2926: --

Line 3444: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

3440: v_action_population_status pay_payroll_actions.action_population_status%TYPE;
3441: --
3442: -- These variables are set by post_insert and returned from this procedure
3443: --
3444: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3445: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
3446: --
3447: Begin
3448: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 3445: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;

3441: --
3442: -- These variables are set by post_insert and returned from this procedure
3443: --
3444: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3445: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
3446: --
3447: Begin
3448: hr_utility.set_location('Entering:'|| v_proc, 5);
3449: --

Line 3829: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE

3825: -- |-----------------------------< default_values >---------------------------|
3826: -- ----------------------------------------------------------------------------
3827: --
3828: procedure default_values
3829: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
3830: ,p_df_effective_date out nocopy pay_payroll_actions.
3831: effective_date%TYPE
3832: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
3833: ,p_period_name out nocopy per_time_periods.period_name%TYPE

Line 4133: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE

4129: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4130: ,p_p_action_status out nocopy pay_payroll_actions.action_status%TYPE
4131: ,p_display_run_number out nocopy pay_payroll_actions.
4132: display_run_number%TYPE
4133: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
4134: ) is
4135: v_proc varchar2(72) := g_package||'get_latest_status';
4136: v_argument varchar2(30);
4137: --

Line 4143: , pay_assignment_actions aga

4139: select pya.action_status
4140: , pya.display_run_number
4141: , aga.action_status
4142: from pay_payroll_actions pya
4143: , pay_assignment_actions aga
4144: where pya.payroll_action_id = p_payroll_action_id
4145: and aga.payroll_action_id = pya.payroll_action_id;
4146: begin
4147: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 4182: ,p_a_object_version_number in pay_assignment_actions.

4178: --
4179: procedure start_quickpay_process
4180: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4181: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
4182: ,p_a_object_version_number in pay_assignment_actions.
4183: object_version_number%TYPE
4184: ,p_status in out nocopy varchar2
4185: ) is
4186: v_proc varchar2(72) := g_package||'start_quickpay_process';

Line 4189: v_a_action_status pay_assignment_actions.action_status%TYPE;

4185: ) is
4186: v_proc varchar2(72) := g_package||'start_quickpay_process';
4187: v_request_id pay_payroll_actions.request_id%TYPE;
4188: v_action_type pay_payroll_actions.action_type%TYPE;
4189: v_a_action_status pay_assignment_actions.action_status%TYPE;
4190: v_leg_code per_business_groups.legislation_code%TYPE;
4191: v_process_name varchar2(30);
4192: v_first_arg varchar2(30);
4193: v_asactid varchar2(30);

Line 4216: pay_assignment_actions ACT,

4212: SELECT EE.element_entry_id
4213: FROM pay_element_types_f ET,
4214: pay_element_links_f EL,
4215: pay_element_entries_f EE,
4216: pay_assignment_actions ACT,
4217: pay_payroll_actions PACT
4218: WHERE ACT.assignment_action_id = v_asactid
4219: AND PACT.payroll_action_id = p_payroll_action_id
4220: AND EE.assignment_id = ACT.assignment_id

Line 4271: pay_assignment_actions ACT,

4267: SELECT EE.element_entry_id
4268: FROM pay_element_types_f ET,
4269: pay_element_links_f EL,
4270: pay_element_entries_f EE,
4271: pay_assignment_actions ACT,
4272: pay_payroll_actions PACT,
4273: pay_element_entry_values_f EEV
4274: WHERE PACT.payroll_action_id = p_payroll_action_id
4275: and PACT.payroll_action_id = ACT.payroll_action_id

Line 4424: FROM pay_assignment_actions

4420: fetch get_leg_rule into v_displ_msg;
4421: if (get_leg_rule%found and v_displ_msg = 'Y') then
4422: SELECT assignment_action_id
4423: INTO v_asactid
4424: FROM pay_assignment_actions
4425: WHERE payroll_action_id = p_payroll_action_id;
4426:
4427: --
4428: -- Enhancement 3368211

Line 4492: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE

4488: procedure wait_quickpay_process
4489: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4490: ,p_display_run_number out nocopy pay_payroll_actions.
4491: display_run_number%TYPE
4492: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
4493: ,p_process_info out nocopy varchar2
4494: ,p_request_id out nocopy pay_payroll_actions.request_id%TYPE
4495: ) is
4496: v_wait boolean;