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: --
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: --
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);
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
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);
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
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);
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: --
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);
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);
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);
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);
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);
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
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);
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
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.
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: --
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
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: --
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);
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.
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);
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);
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);
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);
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);
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);
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);
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);
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: --
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);
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: --
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);
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: --
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: --
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;
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: --
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);
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);
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);
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);
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);
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);
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);
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: --
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);
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: --
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);
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
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);