DBA Data[Home] [Help]

APPS.BIS_PMV_PARAMETERS_PVT dependencies on BIS_PMV_SESSION_PVT

Line 1466: l_user_session_rec BIS_PMV_SESSION_PVT.session_rec_type;

1462: l_savebyid BOOLEAN := FALSE;
1463: l_view_by_exists BOOLEAN := FALSE;
1464: l_attr_2 VARCHAR2(2000);
1465:
1466: l_user_session_rec BIS_PMV_SESSION_PVT.session_rec_type;
1467: l_parameter_rec parameter_rec_type;
1468: l_time_parameter_rec time_parameter_rec_type;
1469:
1470: l_time_attr_2 varchar2(2000);

Line 1849: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

1845:
1846: /* This procedure is based on validate_and_save */
1847: -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
1848: PROCEDURE VALIDATE_PARAMETER
1849: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
1850: ,p_parameter_rec IN OUT NOCOPY parameter_rec_type
1851: ,x_valid OUT NOCOPY VARCHAR2
1852: ,x_return_status OUT NOCOPY VARCHAR2
1853: ,x_msg_count OUT NOCOPY NUMBER

Line 1896: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

1892:
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

Line 1960: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

1956: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
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

Line 2044: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

2040: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
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

Line 2332: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

2328:
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

Line 2464: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

2460:
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

Line 2562: (p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type

2558: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
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

Line 2619: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type

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
2622: ,x_msg_count OUT NOCOPY NUMBER
2623: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2742: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.Session_rec_type

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
2746: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2862: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

2858: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
2859: END RETRIEVE_SCHEDULE_PARAMETER;
2860:
2861: PROCEDURE DELETE_PARAMETER
2862: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
2863: ,p_parameter_name IN VARCHAR2
2864: ,p_schedule_option IN VARCHAR2
2865: ,x_return_status OUT NOCOPY VARCHAR2
2866: ,x_msg_count OUT NOCOPY NUMBER

Line 2936: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

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
2940: ) IS

Line 3021: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

3017: END CREATE_SESSION_PARAMETERS;
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

Line 3132: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

3128: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
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

Line 3214: (p_user_session_Rec IN BIS_PMV_SESSION_PVT.session_rec_type

3210: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
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

Line 3399: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

3395: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
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

Line 3471: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

3467: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
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

Line 3543: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

3539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3540: END RETRIEVE_DEFAULT_PARAMETERS;
3541:
3542: PROCEDURE DELETE_SESSION_PARAMETERS
3543: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
3544: ,p_schedule_option IN VARCHAR2
3545: ,x_return_Status OUT NOCOPY VARCHAR2
3546: ,x_msg_count OUT NOCOPY NUMBER
3547: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3582: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

3578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
3579: END DELETE_SESSION_PARAMETERS;
3580:
3581: PROCEDURE DELETE_PAGE_PARAMETERS
3582: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
3583: ,x_return_status OUT NOCOPY VARCHAR2
3584: ,x_msg_count OUT NOCOPY NUMBER
3585: ,x_msg_data OUT NOCOPY VARCHAR2
3586: )

Line 3607: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

3603:
3604: END DELETE_PAGE_PARAMETERS;
3605:
3606: PROCEDURE DELETE_DEFAULT_PARAMETERS
3607: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
3608: ,x_return_status OUT NOCOPY VARCHAR2
3609: ,x_msg_count OUT NOCOPY NUMBER
3610: ,x_msg_data OUT NOCOPY VARCHAR2
3611: )

Line 4886: l_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type;

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;
4890: --l_Start_Date DATE;

Line 5812: p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type)

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;
5815: l_index1 number := 1;
5816: l_index2 number := 1;

Line 5953: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

5949: --nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
5950: PROCEDURE VALIDATE_DRILL_PARAMETER
5951: (p_user_param_tbl IN parameter_tbl_type
5952: ,p_user_param_rec IN parameter_rec_type
5953: ,p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type
5954: ,x_valid OUT NOCOPY VARCHAR2
5955: ,x_return_status OUT NOCOPY VARCHAR2
5956: ,x_msg_count OUT NOCOPY NUMBER
5957: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6069: l_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type;

6065: lValidationReqList BISVIEWER.t_char;
6066: l_validation_req VARCHAR2(30);
6067: l_parameter_rec PARAMETER_REC_TYPE;
6068: l_parameter_Rec_tbl parameter_tbl_type;
6069: l_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type;
6070: lCount NUMBER := 1;
6071: lFunctionParams VARCHAR2(2000);
6072: lSaveById VARCHAR2(1);
6073: l_return_status VARCHAR2(2000);

Line 6688: p_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type,

6684:
6685: END copyParamsFromReportToPage;
6686:
6687: PROCEDURE saveDateParams(
6688: p_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type,
6689: pAsOfDate IN DATE ,
6690: p_prev_asof_Date IN DATE ,
6691: p_curr_effective_start_date IN DATE ,
6692: p_curr_effective_end_date IN DATE ,

Line 6818: p_user_Session_rec IN BIS_PMV_SESSION_PVT.session_rec_type,

6814: END saveDateParams;
6815:
6816: --BugFix 3308824
6817: PROCEDURE SAVE_TIME_PARAMS(pTimeAttribute IN VARCHAR2,
6818: p_user_Session_rec IN BIS_PMV_SESSION_PVT.session_rec_type,
6819: x_time_level_id IN VARCHAR2,
6820: x_time_level_value IN VARCHAR2,
6821: x_start_date IN DATE,
6822: x_end_date IN DATE

Line 6879: p_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type,

6875:
6876: PROCEDURE COMPUTE_AND_SAVE_DATES(
6877: pTimeAttribute IN VARCHAR2,
6878: pTimeComparisonType IN VARCHAR2,
6879: p_user_Session_rec BIS_PMV_SESSION_PVT.session_rec_type,
6880: x_time_level_id OUT NOCOPY VARCHAR2,
6881: x_time_level_value OUT NOCOPY VARCHAR2
6882: ) IS
6883: l_time_attr_2 varchar2(2000);