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.BIS_PMV_PARAMETERS_PVT dependencies on BIS_PMV_PARAMETERS_PVT

Line 1: PACKAGE BODY BIS_PMV_PARAMETERS_PVT as

1: PACKAGE BODY BIS_PMV_PARAMETERS_PVT as
2: /* $Header: BISVPARB.pls 120.5 2006/03/27 12:54:18 nbarik noship $ */
3: -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=plb \
4: -- dbdrv: checkfile(115.155=120.5):~PROD:~PATH:~FILE
5:

Line 1897: ,p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type

1893: END VALIDATE_PARAMETER;
1894:
1895: PROCEDURE VALIDATE_AND_SAVE
1896: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
1897: ,p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
1898: ,x_return_status OUT NOCOPY VARCHAR2
1899: ,x_msg_count OUT NOCOPY NUMBER
1900: ,x_msg_data OUT NOCOPY VARCHAR2
1901: ) IS

Line 1961: ,p_time_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.time_parameter_rec_type

1957: END VALIDATE_AND_SAVE;
1958:
1959: PROCEDURE VALIDATE_AND_SAVE_TIME
1960: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
1961: ,p_time_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.time_parameter_rec_type
1962: ,x_return_status OUT NOCOPY VARCHAR2
1963: ,x_msg_count OUT NOCOPY NUMBER
1964: ,x_msg_data OUT NOCOPY VARCHAR2
1965: ) IS

Line 1967: l_parameter_rec BIS_PMV_PARAMETERS_PVT.parameter_rec_type;

1963: ,x_msg_count OUT NOCOPY NUMBER
1964: ,x_msg_data OUT NOCOPY VARCHAR2
1965: ) IS
1966: l_valid VARCHAR2(1);
1967: l_parameter_rec BIS_PMV_PARAMETERS_PVT.parameter_rec_type;
1968:
1969: -- DIMENSION VALUE : kiprabha
1970: l_from_index INTEGER ;
1971: l_to_index INTEGER ;

Line 2045: ,p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type

2041: END VALIDATE_AND_SAVE_TIME;
2042:
2043: PROCEDURE VALIDATE_NONTIME_PARAMETER
2044: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
2045: ,p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
2046: ,x_valid OUT NOCOPY VARCHAR2
2047: ,x_return_status OUT NOCOPY VARCHAR2
2048: ,x_msg_count OUT NOCOPY NUMBER
2049: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2333: ,p_time_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.time_parameter_rec_type

2329: END GET_DELEGATION_VALIDATED_VALUE;
2330:
2331: PROCEDURE VALIDATE_TIME_PARAMETER
2332: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
2333: ,p_time_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.time_parameter_rec_type
2334: ,x_valid OUT NOCOPY VARCHAR2
2335: ,x_return_status OUT NOCOPY VARCHAR2
2336: ,x_msg_count OUT NOCOPY NUMBER
2337: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2465: ,p_parameter_rec IN BIS_PMV_PARAMETERS_PVT.parameter_rec_type

2461: END DECODE_ID_VALUE;
2462:
2463: PROCEDURE CREATE_PARAMETER
2464: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
2465: ,p_parameter_rec IN BIS_PMV_PARAMETERS_PVT.parameter_rec_type
2466: ,x_return_status OUT NOCOPY VARCHAR2
2467: ,x_msg_count OUT NOCOPY NUMBER
2468: ,x_msg_Data OUT NOCOPY VARCHAR2
2469: ) IS

Line 2563: ,p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type

2559: END CREATE_PARAMETER;
2560:
2561: PROCEDURE RETRIEVE_PARAMETER
2562: (p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type
2563: ,p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
2564: ,x_return_status OUT NOCOPY VARCHAR2
2565: ,x_msg_count OUT NOCOPY NUMBER
2566: ,x_msg_data OUT NOCOPY VARCHAR2
2567: ) IS

Line 2617: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type

2613: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2614: END RETRIEVE_PARAMETER;
2615:
2616: PROCEDURE RETRIEVE_PAGE_PARAMETER
2617: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
2618: ,p_schedule_id IN NUMBER
2619: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type
2620: ,p_page_dims IN BISVIEWER.t_char
2621: ,x_return_status OUT NOCOPY VARCHAR2

Line 2741: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type

2737: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2738: END RETRIEVE_PAGE_PARAMETER;
2739:
2740: PROCEDURE RETRIEVE_KPI_PARAMETER
2741: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
2742: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type
2743: ,p_user_dims IN BISVIEWER.t_char
2744: ,x_return_status OUT NOCOPY VARCHAR2
2745: ,x_msg_count OUT NOCOPY NUMBER

Line 2829: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type

2825: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2826: END RETRIEVE_KPI_PARAMETER;
2827:
2828: PROCEDURE RETRIEVE_SCHEDULE_PARAMETER
2829: (p_parameter_rec IN OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_rec_type
2830: ,p_schedule_id IN NUMBER
2831: ,x_return_status OUT NOCOPY VARCHAR2
2832: ,x_msg_count OUT NOCOPY NUMBER
2833: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2935: (p_user_param_tbl IN BIS_PMV_PARAMETERS_PVT.parameter_tbl_type

2931: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2932: END DELETE_SCHEDULE_PARAMETER;
2933:
2934: PROCEDURE CREATE_SESSION_PARAMETERS
2935: (p_user_param_tbl IN BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
2936: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
2937: ,x_return_status OUT NOCOPY VARCHAR2
2938: ,x_msg_count OUT NOCOPY NUMBER
2939: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2942: l_user_param_tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_type;

2938: ,x_msg_count OUT NOCOPY NUMBER
2939: ,x_msg_data OUT NOCOPY VARCHAR2
2940: ) IS
2941:
2942: l_user_param_tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_type;
2943: l_lov_where varchar2(2000);
2944:
2945: /*
2946: cursor lov_where_cursor (cpRegionCode varchar2, cpAttr2 varchar2) is

Line 3022: ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type

3018:
3019: PROCEDURE RETRIEVE_PAGE_PARAMETERS
3020: (p_schedule_id IN NUMBER
3021: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
3022: ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
3023: ,x_return_status OUT NOCOPY VARCHAR2
3024: ,x_msg_count OUT NOCOPY NUMBER
3025: ,x_msg_data OUT NOCOPY VARCHAR2
3026: ) IS

Line 3133: ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type

3129: END RETRIEVE_PAGE_PARAMETERS;
3130:
3131: PROCEDURE RETRIEVE_KPI_PARAMETERS
3132: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
3133: ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
3134: ,x_return_status OUT NOCOPY VARCHAR2
3135: ,x_msg_count OUT NOCOPY NUMBER
3136: ,x_msg_data OUT NOCOPY VARCHAR2
3137: ) IS

Line 3215: ,x_paramportlet_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type

3211: END RETRIEVE_KPI_PARAMETERS;
3212:
3213: PROCEDURE RETRIEVE_PARAMLVL_PARAMETERS
3214: (p_user_session_Rec IN BIS_PMV_SESSION_PVT.session_rec_type
3215: ,x_paramportlet_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_Type
3216: ,x_return_status OUT NOCOPY VARCHAR2
3217: ,x_msg_count OUT NOCOPY NUMBER
3218: ,x_msg_data OUT NOCOPY VARCHAR2
3219: )

Line 3334: ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type

3330: END;
3331:
3332: PROCEDURE RETRIEVE_SCHEDULE_PARAMETERS
3333: (p_schedule_id IN NUMBER
3334: ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
3335: ,x_return_status OUT NOCOPY VARCHAR2
3336: ,x_msg_count OUT NOCOPY NUMBER
3337: ,x_msg_data OUT NOCOPY VARCHAR2
3338: ) IS

Line 3400: ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type

3396: END RETRIEVE_SCHEDULE_PARAMETERS;
3397:
3398: PROCEDURE RETRIEVE_SESSION_PARAMETERS
3399: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
3400: ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
3401: ,x_return_status OUT NOCOPY VARCHAR2
3402: ,x_msg_count OUT NOCOPY NUMBER
3403: ,x_msg_data OUT NOCOPY VARCHAR2
3404: ) IS

Line 3472: ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type

3468: END RETRIEVE_SESSION_PARAMETERS;
3469:
3470: PROCEDURE RETRIEVE_DEFAULT_PARAMETERS
3471: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
3472: ,x_user_param_tbl OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_tbl_type
3473: ,x_return_status OUT NOCOPY VARCHAR2
3474: ,x_msg_count OUT NOCOPY NUMBER
3475: ,x_msg_data OUT NOCOPY VARCHAR2
3476: ) IS

Line 4884: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;

4880: x_msg_data OUT NOCOPY VARCHAR2
4881: )
4882: IS
4883:
4884: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
4885: l_parameter_Rec_tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_type;
4886: l_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type;
4887: l_time_parameter_rec BIS_PMV_PARAMETERS_PVT.TIME_PARAMETER_REC_TYPE;
4888: l_count NUMBER;

Line 4885: l_parameter_Rec_tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_type;

4881: )
4882: IS
4883:
4884: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
4885: l_parameter_Rec_tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_type;
4886: l_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type;
4887: l_time_parameter_rec BIS_PMV_PARAMETERS_PVT.TIME_PARAMETER_REC_TYPE;
4888: l_count NUMBER;
4889: l_asof_Date DATE;

Line 4887: l_time_parameter_rec BIS_PMV_PARAMETERS_PVT.TIME_PARAMETER_REC_TYPE;

4883:
4884: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
4885: l_parameter_Rec_tbl BIS_PMV_PARAMETERS_PVT.parameter_tbl_type;
4886: l_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type;
4887: l_time_parameter_rec BIS_PMV_PARAMETERS_PVT.TIME_PARAMETER_REC_TYPE;
4888: l_count NUMBER;
4889: l_asof_Date DATE;
4890: --l_Start_Date DATE;
4891: --l_End_date DATE;

Line 5810: function GET_LOV_WHERE(p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,

5806: END SAVE_CONTEXT_VALUES;
5807:
5808:
5809:
5810: function GET_LOV_WHERE(p_parameter_tbl in BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE,
5811: p_where_clause in VARCHAR2,
5812: p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type)
5813: return varchar2 is
5814: l_lov_where varchar2(2000) := p_where_clause;

Line 5821: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;

5817: l_count number := 0;
5818: l_attribute_code varchar2(2000);
5819: l_attribute2 varchar2(2000);
5820: l_parameter_name varchar2(2000);
5821: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
5822: l_parameter_value varchar2(2000);
5823: l_parameter_description varchar2(2000);
5824: l_return_status varchar2(2000);
5825: l_msg_count number;

Line 6702: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;

6698: p_prev_effective_end_date IN DATE,
6699: p_prev_time_level_id IN VARCHAR2,
6700: p_prev_time_level_value IN VARCHAR2
6701: ) IS
6702: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
6703: l_date_format varchar2(30) := 'DD-MM-RRRR';
6704: l_asof_Date DATE;
6705: x_return_status VARCHAR2(2000);
6706: x_msg_count NUMBER;

Line 7351: END BIS_PMV_PARAMETERS_PVT;

7347: rollback;
7348: x_return_status := 'E';
7349: End UPDATE_COMPUTED_DATES;
7350:
7351: END BIS_PMV_PARAMETERS_PVT;