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.HR_BIS_ALERTS dependencies on BIS_ACTUAL_PUB

Line 195: (p_actual_rec IN bis_actual_pub.actual_rec_type)

191: --
192: -- Utilises pl to debug bis actual record
193: -------------------------------------------------------------------------
194: PROCEDURE debug_bis_actual_rec
195: (p_actual_rec IN bis_actual_pub.actual_rec_type)
196: IS
197: BEGIN
198:
199: pl('BIS ACTUAL REC => ');

Line 564: -- RETURN: bis_actual_pub.actual_rec_type

560: END Get_Target_rec;
561: ------------------------------------------------------------------------
562: -- Function: Get_bis_actual_rec
563: --
564: -- RETURN: bis_actual_pub.actual_rec_type
565: --
566: -- Description: This function returns the data in the bis actual
567: -- record format required for calculating the actuals
568: --

Line 573: bis_actual_pub.actual_rec_type

569: ------------------------------------------------------------------------
570: FUNCTION get_bis_actual_rec
571: (p_target_rec IN hri_target_rec_type)
572: RETURN
573: bis_actual_pub.actual_rec_type
574: IS
575:
576: l_actual_rec bis_actual_pub.actual_rec_type;
577:

Line 576: l_actual_rec bis_actual_pub.actual_rec_type;

572: RETURN
573: bis_actual_pub.actual_rec_type
574: IS
575:
576: l_actual_rec bis_actual_pub.actual_rec_type;
577:
578: BEGIN
579: l_actual_rec.target_level_id := p_target_rec.target_level_id;
580: l_actual_rec.target_level_short_name := p_target_rec.target_level_short_name;

Line 1217: (p_actual_rec IN bis_ACTUAL_PUB.Actual_Rec_Type)

1213: -- Post Actuals
1214: --
1215: -------------------------------------------------------------------------
1216: PROCEDURE post_actual
1217: (p_actual_rec IN bis_ACTUAL_PUB.Actual_Rec_Type)
1218: IS
1219:
1220: x_error_Tbl bis_UTILITIES_PUB.Error_Tbl_Type;
1221: x_msg_count NUMBER;

Line 1235: bis_ACTUAL_PUB.Post_Actual( p_api_version => 1.0

1231: debug_bis_actual_rec(p_actual_rec);
1232:
1233: IF p_actual_rec.actual IS NOT NULL THEN
1234: pl(' Posting actual...');
1235: bis_ACTUAL_PUB.Post_Actual( p_api_version => 1.0
1236: , p_commit => FND_API.G_TRUE
1237: , p_Actual_Rec => p_actual_rec
1238: , x_return_status => x_return_status
1239: , x_msg_count => x_msg_count

Line 1476: (p_actual_rec IN bis_actual_pub.actual_rec_type

1472: -- CALCULATE ACTUAL MANPOWER SEPARATIONS
1473: -----------------------------------------------------------------------
1474:
1475: FUNCTION hrmsp_actual
1476: (p_actual_rec IN bis_actual_pub.actual_rec_type
1477: ,p_bmtype IN VARCHAR2)
1478: RETURN NUMBER
1479: IS
1480:

Line 1614: l_actual_rec bis_actual_pub.actual_rec_type;

1610:
1611: l_actual NUMBER(22,2);
1612: l_mod_target bisfv_targets.target%TYPE;
1613:
1614: l_actual_rec bis_actual_pub.actual_rec_type;
1615:
1616: BEGIN
1617:
1618: pl('*PROCESS MANPOWER SEPARATION TARGET','Start');

Line 2102: (p_actual_rec IN bis_actual_pub.actual_rec_type

2098: -- filtered using the target dimensions.
2099: --
2100:
2101: FUNCTION hrmvr_actual
2102: (p_actual_rec IN bis_actual_pub.actual_rec_type
2103: ,p_bmtype IN VARCHAR2)
2104: RETURN NUMBER
2105: IS
2106:

Line 2131: ,p_c_actual_rec bis_actual_pub.actual_rec_type

2127: -- Gains occuring during the period. So this equates to all assignments at the
2128: -- end of a period.
2129: CURSOR mv_cur
2130: (p_c_business_group_id NUMBER
2131: ,p_c_actual_rec bis_actual_pub.actual_rec_type
2132: ,p_c_period_start_date DATE
2133: ,p_c_period_end_date DATE)
2134: IS
2135: SELECT asg.assignment_id

Line 2255: l_actual_rec bis_actual_pub.actual_rec_type;

2251: l_budget_value NUMBER(22,2);
2252: l_budget_id per_budgets_v.budget_id%TYPE;
2253: l_business_group_id NUMBER;
2254:
2255: l_actual_rec bis_actual_pub.actual_rec_type;
2256:
2257: --
2258: -- get the budget value
2259: --

Line 2613: (p_actual_rec IN bis_actual_pub.actual_rec_type

2609: -- recruitment success rate is the percentage of vacant places that were
2610: -- successfully filled.
2611: --
2612: FUNCTION hrrcs_actual
2613: (p_actual_rec IN bis_actual_pub.actual_rec_type
2614: ,p_bmtype IN VARCHAR2)
2615: RETURN NUMBER
2616: IS
2617:

Line 2635: CURSOR vac_cur(p_c_actual_rec bis_actual_pub.actual_rec_type

2631: -- This cursor gets each vacancy that closed in period defined by the
2632: -- pmf time dimension
2633: --
2634:
2635: CURSOR vac_cur(p_c_actual_rec bis_actual_pub.actual_rec_type
2636: ,p_c_bmtype VARCHAR2
2637: ,p_c_period_start_date DATE
2638: ,p_c_period_end_date DATE)
2639: IS

Line 2781: l_actual_rec bis_actual_pub.actual_rec_type;

2777: IS
2778:
2779: l_actual NUMBER;
2780: l_mod_target bisfv_targets.target%TYPE;
2781: l_actual_rec bis_actual_pub.actual_rec_type;
2782:
2783: BEGIN
2784:
2785: pl('*Process Recruitment Success Target','Start');

Line 3125: (p_actual_rec IN bis_actual_pub.actual_rec_type)

3121: --
3122:
3123:
3124: FUNCTION hrtrs_actual
3125: (p_actual_rec IN bis_actual_pub.actual_rec_type)
3126: RETURN NUMBER
3127: IS
3128:
3129: l_actual NUMBER;

Line 3147: CURSOR train_dur_cur(p_c_actual_rec bis_actual_pub.actual_rec_type

3143: --
3144: -- This Cursor has been changed due to bug 1718083 to be exactly the same
3145: -- as the Workforce Total report. JRHYDE
3146: --
3147: CURSOR train_dur_cur(p_c_actual_rec bis_actual_pub.actual_rec_type
3148: ,p_c_period_start_date DATE
3149: ,p_c_period_end_date DATE)
3150: IS
3151: SELECT asg.assignment_id

Line 3284: l_actual_rec bis_actual_pub.actual_rec_type;

3280: l_actual NUMBER;
3281: l_mod_target NUMBER;
3282: l_org_struct_version_id per_org_structure_versions.org_structure_version_id%TYPE;
3283:
3284: l_actual_rec bis_actual_pub.actual_rec_type;
3285:
3286: BEGIN
3287:
3288: pl('*Processing Training Success Target','Start');

Line 3398: --bis_actual_pub.retrieve_user_selections

3394: -- i.e. what the users want to see on their home page
3395: l_user_selection_tbl bis_INDICATOR_REGION_PUB.indicator_Region_Tbl_Type;
3396:
3397: --Needed to pass target_level_short_name into the bis record
3398: --bis_actual_pub.retrieve_user_selections
3399: l_target_level_rec bis_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
3400:
3401: -- Needed to pass specification to post_actuals
3402: l_actual_rec bis_ACTUAL_PUB.Actual_Rec_Type;

Line 3402: l_actual_rec bis_ACTUAL_PUB.Actual_Rec_Type;

3398: --bis_actual_pub.retrieve_user_selections
3399: l_target_level_rec bis_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
3400:
3401: -- Needed to pass specification to post_actuals
3402: l_actual_rec bis_ACTUAL_PUB.Actual_Rec_Type;
3403:
3404: l_return_status VARCHAR2(1);
3405: l_msg_count NUMBER;
3406: l_msg_data VARCHAR2(250);

Line 3426: bis_actual_pub.Retrieve_User_Selections

3422: pl('Retreive User Selections');
3423: l_target_level_rec.target_Level_Short_Name := p_target_rec.target_level_short_name;
3424: pl(' target_level_short_name',p_target_rec.target_level_short_name);
3425:
3426: bis_actual_pub.Retrieve_User_Selections
3427: ( p_api_version => 1.0
3428: ,p_Target_Level_Rec => l_Target_Level_Rec
3429: ,x_indicator_Region_Tbl => l_user_selection_Tbl
3430: ,x_return_status => l_return_status

Line 3450: -- and bis_actual_pub.retrieve_user_selections which calls

3446: -- re querying of this target level data that is correct for the target.
3447: -- Don't use l_user_selection_tbl.dimx_Level_Value_Name to supply
3448: -- dimensionx_level_short_name because:
3449: -- The base table bis_user_ind_selections doesn't contain the short_names
3450: -- and bis_actual_pub.retrieve_user_selections which calls
3451: -- bis_indicator_region_pvt.rectrieve_user_ind_selections - doesn't
3452: -- actually query this from bis_target_levels and put it in the
3453: -- l_user_selection_tbl!! So have to query these ourselves.
3454: -- Using the p_target_rec becuase this data is target level info