DBA Data[Home] [Help]

APPS.PA_PERF_RULES_PUB dependencies on PA_NUM_TBL_TYPE

Line 454: P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,

450: P_RULE_TYPE IN VARCHAR2,
451: P_PRECISION IN NUMBER,
452: P_START_DATE_ACTIVE IN DATE,
453: P_END_DATE_ACTIVE IN DATE,
454: P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,
455: P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,
456: P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
457: P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
458: P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,

Line 455: P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,

451: P_PRECISION IN NUMBER,
452: P_START_DATE_ACTIVE IN DATE,
453: P_END_DATE_ACTIVE IN DATE,
454: P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,
455: P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,
456: P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
457: P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
458: P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,
459: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 456: P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,

452: P_START_DATE_ACTIVE IN DATE,
453: P_END_DATE_ACTIVE IN DATE,
454: P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,
455: P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,
456: P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
457: P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
458: P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,
459: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
460: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 457: P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,

453: P_END_DATE_ACTIVE IN DATE,
454: P_THRESHOLD_ID IN SYSTEM.PA_NUM_TBL_TYPE,
455: P_THRES_OBJ_ID IN SYSTEM.PA_NUM_TBL_TYPE,
456: P_FROM_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
457: P_TO_VALUE IN SYSTEM.PA_NUM_TBL_TYPE,
458: P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,
459: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
460: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
461: X_MSG_DATA OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 462: P_WEIGHTING IN SYSTEM.PA_NUM_TBL_TYPE )

458: P_INDICATOR_CODE IN SYSTEM.pa_varchar2_30_tbl_type,
459: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
460: X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
461: X_MSG_DATA OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
462: P_WEIGHTING IN SYSTEM.PA_NUM_TBL_TYPE )
463: IS
464: l_debug_mode VARCHAR2(1);
465: l_RETURN_STATUS VARCHAR2(1);
466: l_MSG_COUNT NUMBER;