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_SE_HOLIDAY_PAY dependencies on PAY_BALANCE_PKG

Line 242: pay_balance_pkg.set_context ('SOURCE_NUMBER'

238: CLOSE csr_assignment_start;*/
239: /*l_days_year:=(p_earning_end_date-(greatest(p_earning_start_date,l_assignment_start)+1));*/
240: FOR csr_context IN csr_attendance_type_id
241: LOOP
242: pay_balance_pkg.set_context ('SOURCE_NUMBER'
243: ,csr_context.attendance_type_id
244: );
245: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
246: ,p_assignment_action_id

Line 245: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'

241: LOOP
242: pay_balance_pkg.set_context ('SOURCE_NUMBER'
243: ,csr_context.attendance_type_id
244: );
245: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
246: ,p_assignment_action_id
247: );
248:
249: OPEN csr_get_defined_balance_id

Line 259: (pay_balance_pkg.get_value

255: CLOSE csr_get_defined_balance_id;
256:
257: l_value :=
258: TO_CHAR
259: (pay_balance_pkg.get_value
260: (p_defined_balance_id => lr_get_defined_balance_id
261: ,p_assignment_action_id => p_assignment_action_id
262: )
263: );

Line 681: pay_balance_pkg.set_context ('SOURCE_TEXT'

677:
678: FOR csr_category IN csr_attendance_category_id
679: LOOP
680: l_attendance_category_id := csr_category.attendance_category_id;
681: pay_balance_pkg.set_context ('SOURCE_TEXT'
682: ,csr_category.attendance_category_id
683: );
684: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
685: ,p_assignment_action_id

Line 684: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'

680: l_attendance_category_id := csr_category.attendance_category_id;
681: pay_balance_pkg.set_context ('SOURCE_TEXT'
682: ,csr_category.attendance_category_id
683: );
684: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
685: ,p_assignment_action_id
686: );
687: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
688:

Line 687: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);

683: );
684: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
685: ,p_assignment_action_id
686: );
687: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
688:
689: -- pay_balance_pkg.set_context('DATE_EARNED',p_effective_date);
690: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABC_PER_YTD');
691: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABS_CAT_ASG_EARN_YTD');

Line 689: -- pay_balance_pkg.set_context('DATE_EARNED',p_effective_date);

685: ,p_assignment_action_id
686: );
687: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
688:
689: -- pay_balance_pkg.set_context('DATE_EARNED',p_effective_date);
690: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABC_PER_YTD');
691: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABS_CAT_ASG_EARN_YTD');
692: OPEN csr_get_defined_balance_id
693: ('TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ASG_LE_ABS_CAT_EARN_YEAR');

Line 700: /*l_value :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

696: INTO lr_get_defined_balance_id;
697:
698: CLOSE csr_get_defined_balance_id;
699:
700: /*l_value :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
701: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id ) );*/
702: l_value :=
703: pay_balance_pkg.get_value
704: (p_defined_balance_id => lr_get_defined_balance_id

Line 703: pay_balance_pkg.get_value

699:
700: /*l_value :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
701: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id ) );*/
702: l_value :=
703: pay_balance_pkg.get_value
704: (p_defined_balance_id => lr_get_defined_balance_id
705: ,p_assignment_action_id => p_assignment_action_id
706: ,p_tax_unit_id => p_tax_unit_id
707: ,p_jurisdiction_code => NULL

Line 1397: pay_balance_pkg.set_context('TAX_UNIT',p_tax_unit_id);

1393: /* P_days_to_pay:=0;
1394: RETURN 'E';
1395: ELSE
1396:
1397: pay_balance_pkg.set_context('TAX_UNIT',p_tax_unit_id);
1398: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1399: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SAVED_HOLIDAY_DAYS_ASG_HY_YTD');
1400: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1401: CLOSE csr_Get_Defined_Balance_Id;

Line 1398: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);

1394: RETURN 'E';
1395: ELSE
1396:
1397: pay_balance_pkg.set_context('TAX_UNIT',p_tax_unit_id);
1398: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1399: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SAVED_HOLIDAY_DAYS_ASG_HY_YTD');
1400: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1401: CLOSE csr_Get_Defined_Balance_Id;
1402: l_total_saved_holidays :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

Line 1402: l_total_saved_holidays :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1398: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1399: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SAVED_HOLIDAY_DAYS_ASG_HY_YTD');
1400: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1401: CLOSE csr_Get_Defined_Balance_Id;
1402: l_total_saved_holidays :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1403: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id ) );
1404: /*l_total_saved_holidays:=pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id,NULL,p_tax_unit_id,
1405: NULL,NULL,NULL,l_pay_date);*/
1406:

Line 1404: /*l_total_saved_holidays:=pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id,NULL,p_tax_unit_id,

1400: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1401: CLOSE csr_Get_Defined_Balance_Id;
1402: l_total_saved_holidays :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1403: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id ) );
1404: /*l_total_saved_holidays:=pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id,NULL,p_tax_unit_id,
1405: NULL,NULL,NULL,l_pay_date);*/
1406:
1407: /* l_tracking_start_date:=to_date('01/'|| to_char(l_start_date,'MM') ||'/' || to_number(to_char(l_start_date,'YYYY'))+4,'dd/mm/yyyy');
1408: l_tracking_end_date:=last_day(to_date('01/'|| to_char(l_end_date,'MM') ||'/' || to_number(to_char(l_end_date,'YYYY'))+4,'dd/mm/yyyy'));

Line 1409: pay_balance_pkg.set_context('TAX_UNIT',p_tax_unit_id);

1405: NULL,NULL,NULL,l_pay_date);*/
1406:
1407: /* l_tracking_start_date:=to_date('01/'|| to_char(l_start_date,'MM') ||'/' || to_number(to_char(l_start_date,'YYYY'))+4,'dd/mm/yyyy');
1408: l_tracking_end_date:=last_day(to_date('01/'|| to_char(l_end_date,'MM') ||'/' || to_number(to_char(l_end_date,'YYYY'))+4,'dd/mm/yyyy'));
1409: pay_balance_pkg.set_context('TAX_UNIT',p_tax_unit_id);
1410: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1411: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SAVED_HOLIDAY_DAYS_TRACKING_ASG_HY_YTD');
1412: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1413: CLOSE csr_Get_Defined_Balance_Id;

Line 1410: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);

1406:
1407: /* l_tracking_start_date:=to_date('01/'|| to_char(l_start_date,'MM') ||'/' || to_number(to_char(l_start_date,'YYYY'))+4,'dd/mm/yyyy');
1408: l_tracking_end_date:=last_day(to_date('01/'|| to_char(l_end_date,'MM') ||'/' || to_number(to_char(l_end_date,'YYYY'))+4,'dd/mm/yyyy'));
1409: pay_balance_pkg.set_context('TAX_UNIT',p_tax_unit_id);
1410: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1411: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SAVED_HOLIDAY_DAYS_TRACKING_ASG_HY_YTD');
1412: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1413: CLOSE csr_Get_Defined_Balance_Id;
1414: l_total_saved_days_tracking :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

Line 1414: l_total_saved_days_tracking :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1410: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1411: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SAVED_HOLIDAY_DAYS_TRACKING_ASG_HY_YTD');
1412: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1413: CLOSE csr_Get_Defined_Balance_Id;
1414: l_total_saved_days_tracking :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1415: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id ) );
1416: /*l_total_saved_days_tracking:=(pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id,NULL,p_tax_unit_id,
1417: NULL,NULL,NULL,l_tracking_start_date);*/
1418: /* IF l_total_saved_holidays>l_total_saved_days_tracking THEN

Line 1416: /*l_total_saved_days_tracking:=(pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id,NULL,p_tax_unit_id,

1412: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1413: CLOSE csr_Get_Defined_Balance_Id;
1414: l_total_saved_days_tracking :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1415: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id ) );
1416: /*l_total_saved_days_tracking:=(pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id,NULL,p_tax_unit_id,
1417: NULL,NULL,NULL,l_tracking_start_date);*/
1418: /* IF l_total_saved_holidays>l_total_saved_days_tracking THEN
1419: /* We need to pay the remaining days for that person */
1420: /* P_days_to_pay:= (l_total_saved_holidays-l_total_saved_days_tracking);

Line 1909: pay_balance_pkg.set_context ('SOURCE_TEXT'

1905:
1906: FOR csr_category IN csr_attendance_category_id
1907: LOOP
1908: l_attendance_category_id := csr_category.attendance_category_id;
1909: pay_balance_pkg.set_context ('SOURCE_TEXT'
1910: ,csr_category.attendance_category_id
1911: );
1912: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
1913: ,p_assignment_action_id

Line 1912: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'

1908: l_attendance_category_id := csr_category.attendance_category_id;
1909: pay_balance_pkg.set_context ('SOURCE_TEXT'
1910: ,csr_category.attendance_category_id
1911: );
1912: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
1913: ,p_assignment_action_id
1914: );
1915: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
1916:

Line 1915: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);

1911: );
1912: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
1913: ,p_assignment_action_id
1914: );
1915: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
1916:
1917: -- pay_balance_pkg.set_context('DATE_EARNED',p_date_earned);
1918: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABC_PER_YTD');
1919: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABS_CAT_ASG_HY_YTD');

Line 1917: -- pay_balance_pkg.set_context('DATE_EARNED',p_date_earned);

1913: ,p_assignment_action_id
1914: );
1915: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
1916:
1917: -- pay_balance_pkg.set_context('DATE_EARNED',p_date_earned);
1918: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABC_PER_YTD');
1919: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABS_CAT_ASG_HY_YTD');
1920: OPEN csr_get_defined_balance_id
1921: ('TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ASG_LE_ABS_CAT_HY_YEAR');

Line 1928: /*l_value :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1924: INTO lr_get_defined_balance_id;
1925:
1926: CLOSE csr_get_defined_balance_id;
1927:
1928: /*l_value :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1929: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id ) );*/
1930: l_value :=
1931: pay_balance_pkg.get_value
1932: (p_defined_balance_id => lr_get_defined_balance_id

Line 1931: pay_balance_pkg.get_value

1927:
1928: /*l_value :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1929: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id ) );*/
1930: l_value :=
1931: pay_balance_pkg.get_value
1932: (p_defined_balance_id => lr_get_defined_balance_id
1933: ,p_assignment_action_id => p_assignment_action_id
1934: ,p_tax_unit_id => p_tax_unit_id
1935: ,p_jurisdiction_code => NULL

Line 2128: pay_balance_pkg.set_context ('SOURCE_TEXT', 'S');

2124: AND hoi4.org_information_context = 'SE_LE_HOLIDAY_PAY_DETAILS'
2125: AND hoi4.org_information1 IS NOT NULL;
2126: BEGIN
2127: --l_attendance_category_id:='V';
2128: pay_balance_pkg.set_context ('SOURCE_TEXT', 'S');
2129: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
2130: ,p_assignment_action_id
2131: );
2132: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);

Line 2129: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'

2125: AND hoi4.org_information1 IS NOT NULL;
2126: BEGIN
2127: --l_attendance_category_id:='V';
2128: pay_balance_pkg.set_context ('SOURCE_TEXT', 'S');
2129: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
2130: ,p_assignment_action_id
2131: );
2132: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2133:

Line 2132: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);

2128: pay_balance_pkg.set_context ('SOURCE_TEXT', 'S');
2129: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
2130: ,p_assignment_action_id
2131: );
2132: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2133:
2134: --pay_balance_pkg.set_context('DATE_EARNED',p_date_earned);
2135: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABC_PER_YTD');
2136: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABS_CAT_ASG_YTD');

Line 2134: --pay_balance_pkg.set_context('DATE_EARNED',p_date_earned);

2130: ,p_assignment_action_id
2131: );
2132: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2133:
2134: --pay_balance_pkg.set_context('DATE_EARNED',p_date_earned);
2135: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABC_PER_YTD');
2136: --OPEN csr_Get_Defined_Balance_Id( 'TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ABS_CAT_ASG_YTD');
2137: OPEN csr_get_defined_balance_id
2138: ('TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ASG_LE_ABS_CAT_EARN_YEAR');

Line 2145: /*l_value :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2141: INTO lr_get_defined_balance_id;
2142:
2143: CLOSE csr_get_defined_balance_id;
2144:
2145: /*l_value :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2146: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id ) );*/
2147: l_value :=
2148: pay_balance_pkg.get_value
2149: (p_defined_balance_id => lr_get_defined_balance_id

Line 2148: pay_balance_pkg.get_value

2144:
2145: /*l_value :=to_char(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2146: P_ASSIGNMENT_ACTION_ID =>p_assignment_action_id ) );*/
2147: l_value :=
2148: pay_balance_pkg.get_value
2149: (p_defined_balance_id => lr_get_defined_balance_id
2150: ,p_assignment_action_id => p_assignment_action_id
2151: ,p_tax_unit_id => p_tax_unit_id
2152: ,p_jurisdiction_code => NULL

Line 2687: pay_balance_pkg.set_context ('SOURCE_TEXT'

2683: -- hr_utility.trace(' l_days_year => ' || l_days_year);
2684: FOR csr_category IN csr_attendance_category_id
2685: LOOP
2686: l_attendance_category_id := csr_category.attendance_category_id;
2687: pay_balance_pkg.set_context ('SOURCE_TEXT'
2688: ,csr_category.attendance_category_id
2689: );
2690: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
2691: ,p_assignment_action_id

Line 2690: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'

2686: l_attendance_category_id := csr_category.attendance_category_id;
2687: pay_balance_pkg.set_context ('SOURCE_TEXT'
2688: ,csr_category.attendance_category_id
2689: );
2690: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
2691: ,p_assignment_action_id
2692: );
2693: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2694:

Line 2693: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);

2689: );
2690: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID'
2691: ,p_assignment_action_id
2692: );
2693: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
2694:
2695: OPEN csr_get_defined_balance_id
2696: ('TOTAL_ABSENCE_DAYS_HOLIDAY_PAY_ASG_LE_ABS_CAT_HY_YEAR');
2697:

Line 2704: pay_balance_pkg.get_value

2700:
2701: CLOSE csr_get_defined_balance_id;
2702:
2703: l_value :=
2704: pay_balance_pkg.get_value
2705: (p_defined_balance_id => lr_get_defined_balance_id
2706: ,p_assignment_action_id => p_assignment_action_id
2707: ,p_tax_unit_id => p_tax_unit_id
2708: ,p_jurisdiction_code => NULL