DBA Data[Home] [Help]

APPS.PAY_BATCH_ELEMENT_ENTRY_API dependencies on PAY_BATCH_CONTROL_TOTALS

Line 1625: l_batch_control_id pay_batch_control_totals.batch_control_id%TYPE;

1621: --
1622: -- Declare cursors and local variables
1623: --
1624: l_proc varchar2(72) := g_package||'create_batch_total';
1625: l_batch_control_id pay_batch_control_totals.batch_control_id%TYPE;
1626: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;
1627: l_session_date date;
1628: /* Changes for Bug 10373368 starts here */
1629: l_uom pay_input_values_f.uom%TYPE;

Line 1626: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;

1622: -- Declare cursors and local variables
1623: --
1624: l_proc varchar2(72) := g_package||'create_batch_total';
1625: l_batch_control_id pay_batch_control_totals.batch_control_id%TYPE;
1626: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;
1627: l_session_date date;
1628: /* Changes for Bug 10373368 starts here */
1629: l_uom pay_input_values_f.uom%TYPE;
1630: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;

Line 1632: v_control_total pay_batch_control_totals.control_total%TYPE;

1628: /* Changes for Bug 10373368 starts here */
1629: l_uom pay_input_values_f.uom%TYPE;
1630: l_input_curr_code pay_element_types_f.input_currency_code%TYPE;
1631: lv_rgrflg varchar2(1);
1632: v_control_total pay_batch_control_totals.control_total%TYPE;
1633: --
1634: cursor batch_total_validate
1635: ( p_batch_id number,
1636: p_control_type varchar2,

Line 2606: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;

2602: --
2603: -- Declare cursors and local variables
2604: --
2605: l_proc varchar2(72) := g_package||'update_batch_total';
2606: l_object_version_number pay_batch_control_totals.object_version_number%TYPE;
2607: l_session_date date;
2608: --
2609: begin
2610: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2731: from pay_batch_control_totals bct

2727: where btl.batch_id = p_batch_id;
2728: --
2729: cursor csr_batch_ctl_totals is
2730: select bct.batch_control_id,bct.object_version_number
2731: from pay_batch_control_totals bct
2732: where bct.batch_id = p_batch_id;
2733: --
2734: begin
2735: hr_utility.set_location('Entering:'|| l_proc, 5);