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 2592: sql_cursor := dbms_sql.open_cursor;

2588: l_def_rt_str := l_def_rt_str || ':p_effective_date, ';
2589: l_def_rt_str := l_def_rt_str || ':p_org_meth, ';
2590: l_def_rt_str := l_def_rt_str || ':l_org_method_id); end; ';
2591: --
2592: sql_cursor := dbms_sql.open_cursor;
2593: --
2594: dbms_sql.parse(sql_cursor, l_def_rt_str, dbms_sql.v7);
2595: --
2596: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);

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

2590: l_def_rt_str := l_def_rt_str || ':l_org_method_id); end; ';
2591: --
2592: sql_cursor := dbms_sql.open_cursor;
2593: --
2594: dbms_sql.parse(sql_cursor, l_def_rt_str, dbms_sql.v7);
2595: --
2596: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);
2597: --
2598: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);

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

2592: sql_cursor := dbms_sql.open_cursor;
2593: --
2594: dbms_sql.parse(sql_cursor, l_def_rt_str, dbms_sql.v7);
2595: --
2596: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);
2597: --
2598: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2599: --
2600: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);

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

2594: dbms_sql.parse(sql_cursor, l_def_rt_str, dbms_sql.v7);
2595: --
2596: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);
2597: --
2598: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2599: --
2600: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);
2601: --
2602: dbms_sql.bind_variable(sql_cursor, 'l_org_method_id', l_org_method_id);

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

2596: dbms_sql.bind_variable(sql_cursor, 'p_assignment_action', p_assignment_action);
2597: --
2598: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2599: --
2600: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);
2601: --
2602: dbms_sql.bind_variable(sql_cursor, 'l_org_method_id', l_org_method_id);
2603: --
2604: l_rows := dbms_sql.execute (sql_cursor);

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

2598: dbms_sql.bind_variable(sql_cursor, 'p_effective_date', p_effective_date);
2599: --
2600: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);
2601: --
2602: dbms_sql.bind_variable(sql_cursor, 'l_org_method_id', l_org_method_id);
2603: --
2604: l_rows := dbms_sql.execute (sql_cursor);
2605: --
2606: if (l_rows = 1) then

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

2600: dbms_sql.bind_variable(sql_cursor, 'p_org_meth', p_org_meth);
2601: --
2602: dbms_sql.bind_variable(sql_cursor, 'l_org_method_id', l_org_method_id);
2603: --
2604: l_rows := dbms_sql.execute (sql_cursor);
2605: --
2606: if (l_rows = 1) then
2607: dbms_sql.variable_value(sql_cursor, 'l_org_method_id',
2608: l_org_method_id);

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

2603: --
2604: l_rows := dbms_sql.execute (sql_cursor);
2605: --
2606: if (l_rows = 1) then
2607: dbms_sql.variable_value(sql_cursor, 'l_org_method_id',
2608: l_org_method_id);
2609: dbms_sql.close_cursor(sql_cursor);
2610: --
2611: -- Check that procedure returns a payment method with the same

Line 2609: dbms_sql.close_cursor(sql_cursor);

2605: --
2606: if (l_rows = 1) then
2607: dbms_sql.variable_value(sql_cursor, 'l_org_method_id',
2608: l_org_method_id);
2609: dbms_sql.close_cursor(sql_cursor);
2610: --
2611: -- Check that procedure returns a payment method with the same
2612: -- payment type as the original payment method.
2613: -- Also currency needs to be the same.

Line 2644: dbms_sql.close_cursor(sql_cursor);

2640: hr_utility.raise_error;
2641: end if;
2642: --
2643: else
2644: dbms_sql.close_cursor(sql_cursor);
2645: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');
2646: hr_utility.raise_error;
2647: end if;
2648: --

Line 3283: if dbms_sql.is_open(p_cur_id) then

3279: --
3280: p_leg_code := l_leg_code;
3281: p_bg_id := p_business_group_id;
3282: --
3283: if dbms_sql.is_open(p_cur_id) then
3284: dbms_sql.close_cursor(p_cur_id);
3285: end if;
3286: --
3287: begin

Line 3284: dbms_sql.close_cursor(p_cur_id);

3280: p_leg_code := l_leg_code;
3281: p_bg_id := p_business_group_id;
3282: --
3283: if dbms_sql.is_open(p_cur_id) then
3284: dbms_sql.close_cursor(p_cur_id);
3285: end if;
3286: --
3287: begin
3288: --

Line 3302: l_cur_id := dbms_sql.open_cursor;

3298: :date_earned,
3299: :override_date,
3300: :pre_payment_id); END;';
3301: --
3302: l_cur_id := dbms_sql.open_cursor;
3303: --
3304: dbms_sql.parse(l_cur_id,
3305: statem,
3306: dbms_sql.v7);

Line 3304: dbms_sql.parse(l_cur_id,

3300: :pre_payment_id); END;';
3301: --
3302: l_cur_id := dbms_sql.open_cursor;
3303: --
3304: dbms_sql.parse(l_cur_id,
3305: statem,
3306: dbms_sql.v7);
3307: --
3308: -- First attempt to retrieve the value.

Line 3306: dbms_sql.v7);

3302: l_cur_id := dbms_sql.open_cursor;
3303: --
3304: dbms_sql.parse(l_cur_id,
3305: statem,
3306: dbms_sql.v7);
3307: --
3308: -- First attempt to retrieve the value.
3309: --
3310: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);

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

3306: dbms_sql.v7);
3307: --
3308: -- First attempt to retrieve the value.
3309: --
3310: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3311: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3312: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3313: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3314: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);

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

3307: --
3308: -- First attempt to retrieve the value.
3309: --
3310: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3311: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3312: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3313: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3314: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3315: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);

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

3308: -- First attempt to retrieve the value.
3309: --
3310: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3311: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3312: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3313: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3314: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3315: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3316: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);

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

3309: --
3310: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3311: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3312: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3313: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3314: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3315: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3316: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3317: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);

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

3310: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3311: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3312: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3313: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3314: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3315: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3316: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3317: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3318: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);

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

3311: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3312: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3313: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3314: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3315: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3316: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3317: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3318: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3319: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);

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

3312: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3313: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3314: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3315: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3316: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3317: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3318: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3319: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3320: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);

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

3313: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3314: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3315: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3316: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3317: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3318: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3319: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3320: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3321: --

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

3314: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3315: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3316: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3317: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3318: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3319: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3320: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3321: --
3322: rows_processed := dbms_sql.execute(l_cur_id);

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

3315: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3316: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3317: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3318: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3319: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3320: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3321: --
3322: rows_processed := dbms_sql.execute(l_cur_id);
3323: --

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

3316: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);
3317: dbms_sql.bind_variable(l_cur_id, 'effective_date', p_effective_date);
3318: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3319: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3320: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3321: --
3322: rows_processed := dbms_sql.execute(l_cur_id);
3323: --
3324: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);

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

3318: dbms_sql.bind_variable(l_cur_id, 'date_earned', p_date_earned);
3319: dbms_sql.bind_variable(l_cur_id, 'override_date', p_override_date);
3320: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3321: --
3322: rows_processed := dbms_sql.execute(l_cur_id);
3323: --
3324: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);
3325: --
3326: --

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

3320: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3321: --
3322: rows_processed := dbms_sql.execute(l_cur_id);
3323: --
3324: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);
3325: --
3326: --
3327: exception
3328: --

Line 3331: if dbms_sql.is_open(l_cur_id) then

3327: exception
3328: --
3329: when others then
3330: --
3331: if dbms_sql.is_open(l_cur_id) then
3332: dbms_sql.close_cursor(l_cur_id);
3333: end if;
3334: --
3335: l_cur_id := NULL;

Line 3332: dbms_sql.close_cursor(l_cur_id);

3328: --
3329: when others then
3330: --
3331: if dbms_sql.is_open(l_cur_id) then
3332: dbms_sql.close_cursor(l_cur_id);
3333: end if;
3334: --
3335: l_cur_id := NULL;
3336: --

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

3347: end if;
3348: --
3349: if l_cur_id is not null then
3350: --
3351: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3352: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3353: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3354: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3355: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);

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

3348: --
3349: if l_cur_id is not null then
3350: --
3351: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3352: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3353: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3354: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3355: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3356: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);

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

3349: if l_cur_id is not null then
3350: --
3351: dbms_sql.bind_variable(l_cur_id, 'trx_date', l_trx_date);
3352: dbms_sql.bind_variable(l_cur_id, 'business_group_id', p_business_group_id);
3353: dbms_sql.bind_variable(l_cur_id, 'payroll_action_id', p_payroll_action_id);
3354: dbms_sql.bind_variable(l_cur_id, 'assignment_action_id', p_assignment_action_id);
3355: dbms_sql.bind_variable(l_cur_id, 'payroll_id', p_payroll_id);
3356: dbms_sql.bind_variable(l_cur_id, 'consolidation_set_id', p_consolidation_set_id);
3357: dbms_sql.bind_variable(l_cur_id, 'org_payment_method_id', p_org_payment_method_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3361: dbms_sql.bind_variable(l_cur_id, 'pre_payment_id', p_pre_payment_id);
3362: --
3363: rows_processed := dbms_sql.execute(l_cur_id);
3364: --
3365: dbms_sql.variable_value(l_cur_id, 'trx_date', l_trx_date);
3366: --
3367: else
3368: --
3369: l_trx_date := nvl(nvl(p_override_date,p_date_earned),p_effective_date);