DBA Data[Home] [Help]

APPS.PA_PERF_RULES_PVT dependencies on PA_NUM_TBL_TYPE

Line 586: P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,

582: P_RULE_TYPE IN VARCHAR2,
583: P_PRECISION IN NUMBER,
584: P_START_DATE_ACTIVE IN DATE,
585: P_END_DATE_ACTIVE IN DATE,
586: P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,
587: P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,
588: P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
589: P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
590: P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,

Line 587: P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,

583: P_PRECISION IN NUMBER,
584: P_START_DATE_ACTIVE IN DATE,
585: P_END_DATE_ACTIVE IN DATE,
586: P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,
587: P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,
588: P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
589: P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
590: P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,
591: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 588: P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,

584: P_START_DATE_ACTIVE IN DATE,
585: P_END_DATE_ACTIVE IN DATE,
586: P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,
587: P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,
588: P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
589: P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
590: P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,
591: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
592: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 589: P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,

585: P_END_DATE_ACTIVE IN DATE,
586: P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,
587: P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,
588: P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
589: P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
590: P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,
591: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
592: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
593: X_MSG_DATA OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 594: P_WEIGHTING IN SYSTEM.PA_NUM_TBL_TYPE )

590: P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,
591: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
592: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
593: X_MSG_DATA OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
594: P_WEIGHTING IN SYSTEM.PA_NUM_TBL_TYPE )
595: IS
596: j NUMBER;
597: k NUMBER;
598: l_check_precission VARCHAR2(1) := 'N' ;