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.PQP_GB_OSP_FUNCTIONS dependencies on SSP_MEDICALS

Line 506: -- pqp_get_ssp_medicals_details is the function to get the value

502: RAISE;
503: END IF;
504: END pqp_get_absence_addnl_attr;
505:
506: -- pqp_get_ssp_medicals_details is the function to get the value
507: -- of the column from table SSP_MEDICALS
508: FUNCTION pqp_get_ssp_medicals_details(
509: p_absence_attendance_id IN NUMBER
510: ,p_col_name IN VARCHAR2

Line 507: -- of the column from table SSP_MEDICALS

503: END IF;
504: END pqp_get_absence_addnl_attr;
505:
506: -- pqp_get_ssp_medicals_details is the function to get the value
507: -- of the column from table SSP_MEDICALS
508: FUNCTION pqp_get_ssp_medicals_details(
509: p_absence_attendance_id IN NUMBER
510: ,p_col_name IN VARCHAR2
511: ,p_error_code OUT NOCOPY NUMBER

Line 508: FUNCTION pqp_get_ssp_medicals_details(

504: END pqp_get_absence_addnl_attr;
505:
506: -- pqp_get_ssp_medicals_details is the function to get the value
507: -- of the column from table SSP_MEDICALS
508: FUNCTION pqp_get_ssp_medicals_details(
509: p_absence_attendance_id IN NUMBER
510: ,p_col_name IN VARCHAR2
511: ,p_error_code OUT NOCOPY NUMBER
512: ,p_message OUT NOCOPY VARCHAR2

Line 519: g_package_name||'pqp_get_ssp_medicals_details';

515: IS
516: l_val VARCHAR2(2000);
517: l_proc_step NUMBER(38,10):=0;
518: l_proc_name VARCHAR2(61):=
519: g_package_name||'pqp_get_ssp_medicals_details';
520: l_medical_id ssp_medicals.medical_id%TYPE;
521: BEGIN
522:
523: IF g_debug THEN

Line 520: l_medical_id ssp_medicals.medical_id%TYPE;

516: l_val VARCHAR2(2000);
517: l_proc_step NUMBER(38,10):=0;
518: l_proc_name VARCHAR2(61):=
519: g_package_name||'pqp_get_ssp_medicals_details';
520: l_medical_id ssp_medicals.medical_id%TYPE;
521: BEGIN
522:
523: IF g_debug THEN
524: debug_enter(l_proc_name);

Line 550: ,p_table => 'SSP_MEDICALS'

546: l_val :=
547: pqp_utilities.get_col_value(
548: p_col_nam => p_col_name
549: ,p_key_val => l_medical_id
550: ,p_table => 'SSP_MEDICALS'
551: ,p_key_col => 'MEDICAL_ID'
552: ,p_where => NULL
553: ,p_error_code => p_error_code
554: ,p_message => p_message

Line 577: END pqp_get_ssp_medicals_details;

573: fnd_message.raise_error;
574: ELSE
575: RAISE;
576: END IF;
577: END pqp_get_ssp_medicals_details;
578:
579: -- pqp_get_ssp_medical_addnl_attr returns the value of the items
580: -- from the flex filed SSP_MEDICALS
581: FUNCTION pqp_get_ssp_medical_addnl_attr(

Line 580: -- from the flex filed SSP_MEDICALS

576: END IF;
577: END pqp_get_ssp_medicals_details;
578:
579: -- pqp_get_ssp_medical_addnl_attr returns the value of the items
580: -- from the flex filed SSP_MEDICALS
581: FUNCTION pqp_get_ssp_medical_addnl_attr(
582: p_business_group_id IN NUMBER
583: ,p_effective_date IN DATE
584: ,p_absence_attendance_id IN NUMBER

Line 596: l_medical_id ssp_medicals.medical_id%TYPE;

592: l_val VARCHAR2(2000);
593: l_proc_step NUMBER(38,10):=0;
594: l_proc_name VARCHAR2(61):=
595: g_package_name||'pqp_get_ssp_medical_addnl_attr';
596: l_medical_id ssp_medicals.medical_id%TYPE;
597: BEGIN
598:
599: IF g_debug THEN
600: debug_enter(l_proc_name);

Line 630: ,p_tab_name => 'SSP_MEDICALS'

626: l_val :=
627: pqp_utilities.pqp_get_concat_value(
628: p_key_col => 'MEDICAL_ID'
629: ,p_key_val => l_medical_id
630: ,p_tab_name => 'SSP_MEDICALS'
631: ,p_view_name => 'SSP_MEDICALS_DFV'
632: ,p_message => p_message
633: );
634: --

Line 631: ,p_view_name => 'SSP_MEDICALS_DFV'

627: pqp_utilities.pqp_get_concat_value(
628: p_key_col => 'MEDICAL_ID'
629: ,p_key_val => l_medical_id
630: ,p_tab_name => 'SSP_MEDICALS'
631: ,p_view_name => 'SSP_MEDICALS_DFV'
632: ,p_message => p_message
633: );
634: --
635: ELSE

Line 640: p_flex_name => 'SSP_MEDICALS'

636: --
637: debug(l_proc_name, 30);
638: l_val :=
639: pqp_utilities.get_df_value(
640: p_flex_name => 'SSP_MEDICALS'
641: ,p_flex_context => NULL
642: ,p_flex_field_title => p_segment_name
643: ,p_key_col => 'MEDICAL_ID'
644: ,p_key_val => l_medical_id

Line 645: ,p_tab_name => 'SSP_MEDICALS'

641: ,p_flex_context => NULL
642: ,p_flex_field_title => p_segment_name
643: ,p_key_col => 'MEDICAL_ID'
644: ,p_key_val => l_medical_id
645: ,p_tab_name => 'SSP_MEDICALS'
646: ,p_effective_date => p_effective_date
647: ,p_eff_date_req => 'N'
648: ,p_business_group_id => p_business_group_id
649: ,p_bus_group_id_req => 'N'

Line 1396: -- ben_get_ssp_medicals_details is the main function to get the value

1392: END IF;
1393:
1394: END ben_get_absence_addnl_attr;
1395:
1396: -- ben_get_ssp_medicals_details is the main function to get the value
1397: -- of the column from table SSP_MEDICALS
1398: FUNCTION ben_get_ssp_medicals_details(
1399: p_assignment_id IN NUMBER
1400: ,p_effective_date IN DATE

Line 1397: -- of the column from table SSP_MEDICALS

1393:
1394: END ben_get_absence_addnl_attr;
1395:
1396: -- ben_get_ssp_medicals_details is the main function to get the value
1397: -- of the column from table SSP_MEDICALS
1398: FUNCTION ben_get_ssp_medicals_details(
1399: p_assignment_id IN NUMBER
1400: ,p_effective_date IN DATE
1401: ,p_col_name IN VARCHAR2

Line 1398: FUNCTION ben_get_ssp_medicals_details(

1394: END ben_get_absence_addnl_attr;
1395:
1396: -- ben_get_ssp_medicals_details is the main function to get the value
1397: -- of the column from table SSP_MEDICALS
1398: FUNCTION ben_get_ssp_medicals_details(
1399: p_assignment_id IN NUMBER
1400: ,p_effective_date IN DATE
1401: ,p_col_name IN VARCHAR2
1402: ,p_error_code OUT NOCOPY NUMBER

Line 1409: g_package_name||'ben_get_ssp_medicals_details';

1405: RETURN VARCHAR2
1406: IS
1407: l_proc_step NUMBER(38,10):=0;
1408: l_proc_name VARCHAR2(61):=
1409: g_package_name||'ben_get_ssp_medicals_details';
1410: l_absence_id per_absence_attendances.absence_attendance_id%TYPE;
1411: l_val VARCHAR2(2000);
1412: BEGIN
1413: IF g_debug THEN

Line 1427: pqp_gb_osp_functions.pqp_get_ssp_medicals_details(

1423: ,p_effective_date => p_effective_date
1424: );
1425: debug(l_proc_name, 20);
1426: l_val :=
1427: pqp_gb_osp_functions.pqp_get_ssp_medicals_details(
1428: p_absence_attendance_id => l_absence_id
1429: ,p_col_name => p_col_name
1430: ,p_error_code => p_error_code
1431: ,p_message => p_message

Line 1453: END ben_get_ssp_medicals_details;

1449: ELSE
1450: RAISE;
1451: END IF;
1452:
1453: END ben_get_ssp_medicals_details;
1454:
1455: -- ben_get_absence_further_info returns the value of the items
1456: -- from the flex filed SSP_MEDICALS
1457: FUNCTION ben_get_ssp_medical_addnl_attr(

Line 1456: -- from the flex filed SSP_MEDICALS

1452:
1453: END ben_get_ssp_medicals_details;
1454:
1455: -- ben_get_absence_further_info returns the value of the items
1456: -- from the flex filed SSP_MEDICALS
1457: FUNCTION ben_get_ssp_medical_addnl_attr(
1458: p_business_group_id IN NUMBER
1459: ,p_effective_date IN DATE
1460: ,p_assignment_id IN NUMBER

Line 1929: -- ssp_medicals. Inputs are absence_attendance_id and the title

1925: END IF;
1926: END ben_get_absence_details;
1927:
1928: -- get_medical_details Returns the value of the column in table
1929: -- ssp_medicals. Inputs are absence_attendance_id and the title
1930: -- of the column in the absence form.The mapping of form title to the DB
1931: -- column is done in Lookup and the same is fetched by calling
1932: -- get_lookup_code function.
1933: FUNCTION get_medical_details(

Line 1972: pqp_gb_osp_functions.pqp_get_ssp_medicals_details(

1968: --
1969: debug(l_proc_name, 20);
1970: -- Call pqp_get_absence_details to get the value of the column.
1971: l_val :=
1972: pqp_gb_osp_functions.pqp_get_ssp_medicals_details(
1973: p_absence_attendance_id => p_absence_attendance_id
1974: ,p_col_name => l_col_name
1975: ,p_error_code => p_error_code
1976: ,p_message => p_message

Line 3508: l_medical_id ssp_medicals.medical_id%TYPE;

3504: IS
3505: l_proc_step NUMBER(38,10):=0;
3506: l_proc_name VARCHAR2(61):=
3507: g_package_name||'pqp_get_medical_id';
3508: l_medical_id ssp_medicals.medical_id%TYPE;
3509: BEGIN
3510: IF g_debug THEN
3511: debug_enter(l_proc_name);
3512: debug('p_absence_id:'||p_absence_id);

Line 4941: -- ssp_medicals. Inputs are absence_attendance_id and the title

4937: END IF;
4938: END ben_matrnty_details;
4939:
4940: -- ben_medical_details Returns the value of the column in table
4941: -- ssp_medicals. Inputs are absence_attendance_id and the title
4942: -- of the column in the absence form.The mapping of form title to the DB
4943: -- column is done in Lookup and the same is fetched by calling
4944: -- get_lookup_code function.
4945: FUNCTION ben_medical_details(