DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on DBMS_SQL

Line 519: sql_cursor := dbms_sql.open_cursor;

515: --
516: statem := 'begin pay_'||leg_code||'_rules.get_multi_tax_unit_pay_flag(';
517: statem := statem||':bus_grp, :mtup_flag); end;';
518: --
519: sql_cursor := dbms_sql.open_cursor;
520: --
521: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);
522: --
523: --

Line 521: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);

517: statem := statem||':bus_grp, :mtup_flag); end;';
518: --
519: sql_cursor := dbms_sql.open_cursor;
520: --
521: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);
522: --
523: --
524: dbms_sql.bind_variable(sql_cursor, 'bus_grp', p_business_group_id);
525: --

Line 524: dbms_sql.bind_variable(sql_cursor, 'bus_grp', p_business_group_id);

520: --
521: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);
522: --
523: --
524: dbms_sql.bind_variable(sql_cursor, 'bus_grp', p_business_group_id);
525: --
526: dbms_sql.bind_variable(sql_cursor, 'mtup_flag', p_multi_tax_unit_payment);
527: --
528: l_rows := dbms_sql.execute (sql_cursor);

Line 526: dbms_sql.bind_variable(sql_cursor, 'mtup_flag', p_multi_tax_unit_payment);

522: --
523: --
524: dbms_sql.bind_variable(sql_cursor, 'bus_grp', p_business_group_id);
525: --
526: dbms_sql.bind_variable(sql_cursor, 'mtup_flag', p_multi_tax_unit_payment);
527: --
528: l_rows := dbms_sql.execute (sql_cursor);
529: --
530: if (l_rows = 1) then

Line 528: l_rows := dbms_sql.execute (sql_cursor);

524: dbms_sql.bind_variable(sql_cursor, 'bus_grp', p_business_group_id);
525: --
526: dbms_sql.bind_variable(sql_cursor, 'mtup_flag', p_multi_tax_unit_payment);
527: --
528: l_rows := dbms_sql.execute (sql_cursor);
529: --
530: if (l_rows = 1) then
531: dbms_sql.variable_value(sql_cursor, 'mtup_flag',
532: p_multi_tax_unit_payment);

Line 531: dbms_sql.variable_value(sql_cursor, 'mtup_flag',

527: --
528: l_rows := dbms_sql.execute (sql_cursor);
529: --
530: if (l_rows = 1) then
531: dbms_sql.variable_value(sql_cursor, 'mtup_flag',
532: p_multi_tax_unit_payment);
533: dbms_sql.close_cursor(sql_cursor);
534: --
535: else

Line 533: dbms_sql.close_cursor(sql_cursor);

529: --
530: if (l_rows = 1) then
531: dbms_sql.variable_value(sql_cursor, 'mtup_flag',
532: p_multi_tax_unit_payment);
533: dbms_sql.close_cursor(sql_cursor);
534: --
535: else
536: p_multi_tax_unit_payment := 'Y';
537: dbms_sql.close_cursor(sql_cursor);

Line 537: dbms_sql.close_cursor(sql_cursor);

533: dbms_sql.close_cursor(sql_cursor);
534: --
535: else
536: p_multi_tax_unit_payment := 'Y';
537: dbms_sql.close_cursor(sql_cursor);
538: end if;
539: --
540: end override_mult_tax_unit_payment;
541: --

Line 2628: sql_cursor := dbms_sql.open_cursor;

2624: l_def_rt_str := l_def_rt_str || ':p_effective_date, ';
2625: l_def_rt_str := l_def_rt_str || ':p_org_meth, ';
2626: l_def_rt_str := l_def_rt_str || ':l_org_method_id); end; ';
2627: --
2628: sql_cursor := dbms_sql.open_cursor;
2629: --
2630: dbms_sql.parse(sql_cursor, l_def_rt_str, dbms_sql.v7);
2631: --
2632: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);

Line 2630: dbms_sql.parse(sql_cursor, l_def_rt_str, dbms_sql.v7);

2626: l_def_rt_str := l_def_rt_str || ':l_org_method_id); end; ';
2627: --
2628: sql_cursor := dbms_sql.open_cursor;
2629: --
2630: dbms_sql.parse(sql_cursor, l_def_rt_str, dbms_sql.v7);
2631: --
2632: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);
2633: --
2634: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);

Line 2632: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);

2628: sql_cursor := dbms_sql.open_cursor;
2629: --
2630: dbms_sql.parse(sql_cursor, l_def_rt_str, dbms_sql.v7);
2631: --
2632: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);
2633: --
2634: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2635: --
2636: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);

Line 2634: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);

2630: dbms_sql.parse(sql_cursor, l_def_rt_str, dbms_sql.v7);
2631: --
2632: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);
2633: --
2634: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2635: --
2636: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);
2637: --
2638: dbms_sql.bind_variable(sql_cursor, 'l_org_method_id', l_org_method_id);

Line 2636: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);

2632: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);
2633: --
2634: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2635: --
2636: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);
2637: --
2638: dbms_sql.bind_variable(sql_cursor, 'l_org_method_id', l_org_method_id);
2639: --
2640: l_rows := dbms_sql.execute (sql_cursor);

Line 2638: dbms_sql.bind_variable(sql_cursor, 'l_org_method_id', l_org_method_id);

2634: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2635: --
2636: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);
2637: --
2638: dbms_sql.bind_variable(sql_cursor, 'l_org_method_id', l_org_method_id);
2639: --
2640: l_rows := dbms_sql.execute (sql_cursor);
2641: --
2642: if (l_rows = 1) then

Line 2640: l_rows := dbms_sql.execute (sql_cursor);

2636: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);
2637: --
2638: dbms_sql.bind_variable(sql_cursor, 'l_org_method_id', l_org_method_id);
2639: --
2640: l_rows := dbms_sql.execute (sql_cursor);
2641: --
2642: if (l_rows = 1) then
2643: dbms_sql.variable_value(sql_cursor, 'l_org_method_id',
2644: l_org_method_id);

Line 2643: dbms_sql.variable_value(sql_cursor, 'l_org_method_id',

2639: --
2640: l_rows := dbms_sql.execute (sql_cursor);
2641: --
2642: if (l_rows = 1) then
2643: dbms_sql.variable_value(sql_cursor, 'l_org_method_id',
2644: l_org_method_id);
2645: dbms_sql.close_cursor(sql_cursor);
2646: --
2647: -- Check that procedure returns a payment method with the same

Line 2645: dbms_sql.close_cursor(sql_cursor);

2641: --
2642: if (l_rows = 1) then
2643: dbms_sql.variable_value(sql_cursor, 'l_org_method_id',
2644: l_org_method_id);
2645: dbms_sql.close_cursor(sql_cursor);
2646: --
2647: -- Check that procedure returns a payment method with the same
2648: -- payment type as the original payment method.
2649: -- Also currency needs to be the same.

Line 2680: dbms_sql.close_cursor(sql_cursor);

2676: hr_utility.raise_error;
2677: end if;
2678: --
2679: else
2680: dbms_sql.close_cursor(sql_cursor);
2681: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');
2682: hr_utility.raise_error;
2683: end if;
2684: --

Line 3321: if dbms_sql.is_open(p_cur_id) then

3317: --
3318: p_leg_code := l_leg_code;
3319: p_bg_id := p_business_group_id;
3320: --
3321: if dbms_sql.is_open(p_cur_id) then
3322: dbms_sql.close_cursor(p_cur_id);
3323: end if;
3324: --
3325: begin

Line 3322: dbms_sql.close_cursor(p_cur_id);

3318: p_leg_code := l_leg_code;
3319: p_bg_id := p_business_group_id;
3320: --
3321: if dbms_sql.is_open(p_cur_id) then
3322: dbms_sql.close_cursor(p_cur_id);
3323: end if;
3324: --
3325: begin
3326: --

Line 3340: l_cur_id := dbms_sql.open_cursor;

3336: :date_earned,
3337: :override_date,
3338: :pre_payment_id); END;';
3339: --
3340: l_cur_id := dbms_sql.open_cursor;
3341: --
3342: dbms_sql.parse(l_cur_id,
3343: statem,
3344: dbms_sql.v7);

Line 3342: dbms_sql.parse(l_cur_id,

3338: :pre_payment_id); END;';
3339: --
3340: l_cur_id := dbms_sql.open_cursor;
3341: --
3342: dbms_sql.parse(l_cur_id,
3343: statem,
3344: dbms_sql.v7);
3345: --
3346: -- First attempt to retrieve the value.

Line 3344: dbms_sql.v7);

3340: l_cur_id := dbms_sql.open_cursor;
3341: --
3342: dbms_sql.parse(l_cur_id,
3343: statem,
3344: dbms_sql.v7);
3345: --
3346: -- First attempt to retrieve the value.
3347: --
3348: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);

Line 3348: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);

3344: dbms_sql.v7);
3345: --
3346: -- First attempt to retrieve the value.
3347: --
3348: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3349: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3350: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3351: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3352: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);

Line 3349: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);

3345: --
3346: -- First attempt to retrieve the value.
3347: --
3348: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3349: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3350: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3351: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3352: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3353: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);

Line 3350: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);

3346: -- First attempt to retrieve the value.
3347: --
3348: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3349: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3350: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3351: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3352: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3353: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3354: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);

Line 3351: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);

3347: --
3348: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3349: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3350: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3351: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3352: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3353: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3354: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3355: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);

Line 3352: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);

3348: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3349: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3350: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3351: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3352: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3353: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3354: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3355: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3356: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);

Line 3353: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);

3349: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3350: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3351: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3352: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3353: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3354: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3355: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3356: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3357: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);

Line 3354: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);

3350: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3351: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3352: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3353: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3354: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3355: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3356: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3357: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3358: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);

Line 3355: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);

3351: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3352: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3353: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3354: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3355: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3356: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3357: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3358: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3359: --

Line 3356: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);

3352: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3353: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3354: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3355: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3356: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3357: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3358: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3359: --
3360: rows_processed := dbms_sql.execute(l_cur_id);

Line 3357: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);

3353: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3354: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3355: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3356: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3357: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3358: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3359: --
3360: rows_processed := dbms_sql.execute(l_cur_id);
3361: --

Line 3358: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);

3354: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3355: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3356: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3357: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3358: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3359: --
3360: rows_processed := dbms_sql.execute(l_cur_id);
3361: --
3362: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);

Line 3360: rows_processed := dbms_sql.execute(l_cur_id);

3356: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3357: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3358: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3359: --
3360: rows_processed := dbms_sql.execute(l_cur_id);
3361: --
3362: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);
3363: --
3364: --

Line 3362: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);

3358: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3359: --
3360: rows_processed := dbms_sql.execute(l_cur_id);
3361: --
3362: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);
3363: --
3364: --
3365: exception
3366: --

Line 3369: if dbms_sql.is_open(l_cur_id) then

3365: exception
3366: --
3367: when others then
3368: --
3369: if dbms_sql.is_open(l_cur_id) then
3370: dbms_sql.close_cursor(l_cur_id);
3371: end if;
3372: --
3373: l_cur_id := NULL;

Line 3370: dbms_sql.close_cursor(l_cur_id);

3366: --
3367: when others then
3368: --
3369: if dbms_sql.is_open(l_cur_id) then
3370: dbms_sql.close_cursor(l_cur_id);
3371: end if;
3372: --
3373: l_cur_id := NULL;
3374: --

Line 3389: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);

3385: end if;
3386: --
3387: if l_cur_id is not null then
3388: --
3389: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3390: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3391: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3392: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3393: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);

Line 3390: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);

3386: --
3387: if l_cur_id is not null then
3388: --
3389: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3390: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3391: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3392: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3393: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3394: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);

Line 3391: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);

3387: if l_cur_id is not null then
3388: --
3389: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3390: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3391: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3392: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3393: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3394: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3395: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);

Line 3392: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);

3388: --
3389: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3390: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3391: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3392: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3393: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3394: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3395: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3396: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);

Line 3393: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);

3389: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3390: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3391: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3392: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3393: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3394: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3395: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3396: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3397: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);

Line 3394: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);

3390: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3391: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3392: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3393: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3394: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3395: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3396: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3397: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3398: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);

Line 3395: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);

3391: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3392: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3393: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3394: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3395: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3396: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3397: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3398: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3399: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);

Line 3396: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);

3392: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3393: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3394: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3395: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3396: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3397: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3398: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3399: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3400: --

Line 3397: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);

3393: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3394: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3395: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3396: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3397: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3398: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3399: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3400: --
3401: rows_processed := dbms_sql.execute(l_cur_id);

Line 3398: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);

3394: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3395: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3396: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3397: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3398: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3399: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3400: --
3401: rows_processed := dbms_sql.execute(l_cur_id);
3402: --

Line 3399: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);

3395: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3396: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3397: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3398: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3399: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3400: --
3401: rows_processed := dbms_sql.execute(l_cur_id);
3402: --
3403: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);

Line 3401: rows_processed := dbms_sql.execute(l_cur_id);

3397: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3398: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3399: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3400: --
3401: rows_processed := dbms_sql.execute(l_cur_id);
3402: --
3403: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);
3404: --
3405: else

Line 3403: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);

3399: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3400: --
3401: rows_processed := dbms_sql.execute(l_cur_id);
3402: --
3403: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);
3404: --
3405: else
3406: --
3407: l_trx_date := nvl(nvl(p_override_date,p_date_earned),p_effective_date);