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: ) is
1185: --

Line 1306: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE

1302: --
1303: procedure chk_eff_earned_payroll
1304: (p_effective_date in pay_payroll_actions.effective_date%TYPE
1305: ,p_date_earned in pay_payroll_actions.date_earned%TYPE
1306: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1307: ,p_raise_error in boolean
1308: ,p_same_payroll out nocopy boolean
1309: ) is
1310: --

Line 2270: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

2266: ,p_assignment_action_id out nocopy number
2267: ,p_a_object_version_number out nocopy number
2268: ) is
2269: --
2270: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
2271: v_object_version_number pay_assignment_actions.object_version_number%TYPE;
2272: v_proc varchar2(72) := g_package||'post_insert';
2273: --
2274: begin

Line 2271: v_object_version_number pay_assignment_actions.object_version_number%TYPE;

2267: ,p_a_object_version_number out nocopy number
2268: ) is
2269: --
2270: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
2271: v_object_version_number pay_assignment_actions.object_version_number%TYPE;
2272: v_proc varchar2(72) := g_package||'post_insert';
2273: --
2274: begin
2275: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 2768: pay_assignment_actions.object_version_number%TYPE

2764: procedure lck_general
2765: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2766: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2767: ,p_a_object_version_number in
2768: pay_assignment_actions.object_version_number%TYPE
2769: ,p_only_action_type in pay_payroll_actions.action_type%TYPE
2770: ,p_actual_action_type out nocopy pay_payroll_actions.action_type%TYPE
2771: ,p_a_action_status out nocopy pay_assignment_actions.
2772: action_status%TYPE

Line 2771: ,p_a_action_status out nocopy pay_assignment_actions.

2767: ,p_a_object_version_number in
2768: pay_assignment_actions.object_version_number%TYPE
2769: ,p_only_action_type in pay_payroll_actions.action_type%TYPE
2770: ,p_actual_action_type out nocopy pay_payroll_actions.action_type%TYPE
2771: ,p_a_action_status out nocopy pay_assignment_actions.
2772: action_status%TYPE
2773: ) is
2774: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
2775: --

Line 2774: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;

2770: ,p_actual_action_type out nocopy pay_payroll_actions.action_type%TYPE
2771: ,p_a_action_status out nocopy pay_assignment_actions.
2772: action_status%TYPE
2773: ) is
2774: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
2775: --
2776: -- Cursor selects the 'current' row from the HR Schema
2777: -- (Locks pay_payroll_actions first, then pay_assignment_actions.)
2778: --

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

2773: ) is
2774: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
2775: --
2776: -- Cursor selects the 'current' row from the HR Schema
2777: -- (Locks pay_payroll_actions first, then pay_assignment_actions.)
2778: --
2779: Cursor C_Sel1 is
2780: select pya.payroll_action_id
2781: , pya.business_group_id

Line 2797: , pay_assignment_actions aga

2793: , pya.action_type
2794: , aga.action_status
2795: , aga.object_version_number
2796: from pay_payroll_actions pya
2797: , pay_assignment_actions aga
2798: where /* Payroll action lock */
2799: pya.payroll_action_id = p_payroll_action_id
2800: and ( pya.action_type = p_only_action_type
2801: or ( p_only_action_type is null

Line 2900: pay_assignment_actions.object_version_number%TYPE

2896: procedure lck
2897: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2898: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2899: ,p_a_object_version_number in
2900: pay_assignment_actions.object_version_number%TYPE
2901: ) is
2902: v_unwanted_type pay_payroll_actions.action_type%TYPE;
2903: v_unwanted_status pay_assignment_actions.action_status%TYPE;
2904: begin

Line 2903: v_unwanted_status pay_assignment_actions.action_status%TYPE;

2899: ,p_a_object_version_number in
2900: pay_assignment_actions.object_version_number%TYPE
2901: ) is
2902: v_unwanted_type pay_payroll_actions.action_type%TYPE;
2903: v_unwanted_status pay_assignment_actions.action_status%TYPE;
2904: begin
2905: --
2906: -- Lock the row only if it is a QuickPay Run action
2907: --

Line 3422: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

3418: v_action_population_status pay_payroll_actions.action_population_status%TYPE;
3419: --
3420: -- These variables are set by post_insert and returned from this procedure
3421: --
3422: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3423: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
3424: --
3425: Begin
3426: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 3423: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;

3419: --
3420: -- These variables are set by post_insert and returned from this procedure
3421: --
3422: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3423: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
3424: --
3425: Begin
3426: hr_utility.set_location('Entering:'|| v_proc, 5);
3427: --

Line 3807: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE

3803: -- |-----------------------------< default_values >---------------------------|
3804: -- ----------------------------------------------------------------------------
3805: --
3806: procedure default_values
3807: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
3808: ,p_df_effective_date out nocopy pay_payroll_actions.
3809: effective_date%TYPE
3810: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
3811: ,p_period_name out nocopy per_time_periods.period_name%TYPE

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

4107: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4108: ,p_p_action_status out nocopy pay_payroll_actions.action_status%TYPE
4109: ,p_display_run_number out nocopy pay_payroll_actions.
4110: display_run_number%TYPE
4111: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
4112: ) is
4113: v_proc varchar2(72) := g_package||'get_latest_status';
4114: v_argument varchar2(30);
4115: --

Line 4121: , pay_assignment_actions aga

4117: select pya.action_status
4118: , pya.display_run_number
4119: , aga.action_status
4120: from pay_payroll_actions pya
4121: , pay_assignment_actions aga
4122: where pya.payroll_action_id = p_payroll_action_id
4123: and aga.payroll_action_id = pya.payroll_action_id;
4124: begin
4125: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 4160: ,p_a_object_version_number in pay_assignment_actions.

4156: --
4157: procedure start_quickpay_process
4158: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4159: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
4160: ,p_a_object_version_number in pay_assignment_actions.
4161: object_version_number%TYPE
4162: ,p_status in out nocopy varchar2
4163: ) is
4164: v_proc varchar2(72) := g_package||'start_quickpay_process';

Line 4167: v_a_action_status pay_assignment_actions.action_status%TYPE;

4163: ) is
4164: v_proc varchar2(72) := g_package||'start_quickpay_process';
4165: v_request_id pay_payroll_actions.request_id%TYPE;
4166: v_action_type pay_payroll_actions.action_type%TYPE;
4167: v_a_action_status pay_assignment_actions.action_status%TYPE;
4168: v_leg_code per_business_groups.legislation_code%TYPE;
4169: v_process_name varchar2(30);
4170: v_first_arg varchar2(30);
4171: v_asactid varchar2(30);

Line 4194: pay_assignment_actions ACT,

4190: SELECT EE.element_entry_id
4191: FROM pay_element_types_f ET,
4192: pay_element_links_f EL,
4193: pay_element_entries_f EE,
4194: pay_assignment_actions ACT,
4195: pay_payroll_actions PACT
4196: WHERE ACT.assignment_action_id = v_asactid
4197: AND PACT.payroll_action_id = p_payroll_action_id
4198: AND EE.assignment_id = ACT.assignment_id

Line 4249: pay_assignment_actions ACT,

4245: SELECT EE.element_entry_id
4246: FROM pay_element_types_f ET,
4247: pay_element_links_f EL,
4248: pay_element_entries_f EE,
4249: pay_assignment_actions ACT,
4250: pay_payroll_actions PACT,
4251: pay_element_entry_values_f EEV
4252: WHERE PACT.payroll_action_id = p_payroll_action_id
4253: and PACT.payroll_action_id = ACT.payroll_action_id

Line 4402: FROM pay_assignment_actions

4398: fetch get_leg_rule into v_displ_msg;
4399: if (get_leg_rule%found and v_displ_msg = 'Y') then
4400: SELECT assignment_action_id
4401: INTO v_asactid
4402: FROM pay_assignment_actions
4403: WHERE payroll_action_id = p_payroll_action_id;
4404:
4405: --
4406: -- Enhancement 3368211

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

4466: procedure wait_quickpay_process
4467: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4468: ,p_display_run_number out nocopy pay_payroll_actions.
4469: display_run_number%TYPE
4470: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
4471: ,p_process_info out nocopy varchar2
4472: ,p_request_id out nocopy pay_payroll_actions.request_id%TYPE
4473: ) is
4474: v_wait boolean;