APPS.PA_RES_ASG_CURRENCY_PUB dependencies on PA_BUDGET_VERSIONS

Line 74: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,

70: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
71: P_CALLING_MODULE IN VARCHAR2 DEFAULT NULL,
72: P_DELETE_FLAG IN VARCHAR2 DEFAULT NULL,
73: P_COPY_FLAG IN VARCHAR2 DEFAULT NULL,
74: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
75: P_COPY_MODE IN VARCHAR2 DEFAULT NULL,
76: P_ROLLUP_FLAG IN VARCHAR2 DEFAULT NULL,
77: P_VERSION_LEVEL_FLAG IN VARCHAR2 DEFAULT NULL,
78: P_CALLED_MODE IN VARCHAR2 DEFAULT NULL );

Line 91: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,

87: X_MSG_DATA OUT NOCOPY VARCHAR2);
88:
89: PROCEDURE COPY_TABLE_RECORDS
90: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
91: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
92: P_COPY_MODE IN VARCHAR2 DEFAULT 'COPY_OVERRIDES',
93: P_CALLING_MODULE IN VARCHAR2,
94: P_VERSION_LEVEL_FLAG IN VARCHAR2 DEFAULT 'N',
95: P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',

Line 131: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

127: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
128: P_CALLING_MODULE IN VARCHAR2,
129: P_DELETE_FLAG IN VARCHAR2,
130: P_COPY_FLAG IN VARCHAR2,
131: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
132: P_COPY_MODE IN VARCHAR2,
133: P_ROLLUP_FLAG IN VARCHAR2,
134: P_VERSION_LEVEL_FLAG IN VARCHAR2,
135: P_CALLED_MODE IN VARCHAR2,

Line 617: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

613: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
614: P_CALLING_MODULE IN VARCHAR2,
615: P_DELETE_FLAG IN VARCHAR2,
616: P_COPY_FLAG IN VARCHAR2,
617: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
618: P_COPY_MODE IN VARCHAR2,
619: P_ROLLUP_FLAG IN VARCHAR2,
620: P_VERSION_LEVEL_FLAG IN VARCHAR2,
621: P_CALLED_MODE IN VARCHAR2 )

Line 896: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

892:
893:
894: PROCEDURE COPY_TABLE_RECORDS
895: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
896: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
897: P_COPY_MODE IN VARCHAR2,
898: P_CALLING_MODULE IN VARCHAR2,
899: P_VERSION_LEVEL_FLAG IN VARCHAR2,
900: P_CALLED_MODE IN VARCHAR2,

Line 1056: l_wp_version_flag PA_BUDGET_VERSIONS.WP_VERSION_FLAG%TYPE;

1052:
1053: l_NULL_NumTabTyp PA_PLSQL_DATATYPES.NumTabTyp;
1054:
1055: -- Indicates if the Target version is a Workplan.
1056: l_wp_version_flag PA_BUDGET_VERSIONS.WP_VERSION_FLAG%TYPE;
1057:
1058: BEGIN
1059: IF p_pa_debug_mode = 'Y' THEN
1060: PA_DEBUG.SET_CURR_FUNCTION

Line 1080: FROM pa_budget_versions

1076:
1077: BEGIN
1078: SELECT nvl(wp_version_flag,'N')
1079: INTO l_wp_version_flag
1080: FROM pa_budget_versions
1081: WHERE budget_version_id = p_fp_cols_rec.x_budget_version_id;
1082: EXCEPTION WHEN NO_DATA_FOUND THEN
1083: IF p_pa_debug_mode = 'Y' THEN
1084: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

Line 2057: l_wp_version_flag PA_BUDGET_VERSIONS.WP_VERSION_FLAG%TYPE;

2053:
2054: l_NULL_NumTabTyp PA_PLSQL_DATATYPES.NumTabTyp;
2055:
2056: -- Indicates if the Target version is a Workplan.
2057: l_wp_version_flag PA_BUDGET_VERSIONS.WP_VERSION_FLAG%TYPE;
2058:
2059: BEGIN
2060:
2061: IF p_pa_debug_mode = 'Y' THEN

Line 2080: FROM pa_budget_versions

2076:
2077: BEGIN
2078: SELECT nvl(wp_version_flag,'N')
2079: INTO l_wp_version_flag
2080: FROM pa_budget_versions
2081: WHERE budget_version_id = p_fp_cols_rec.x_budget_version_id;
2082: EXCEPTION WHEN NO_DATA_FOUND THEN
2083: IF p_pa_debug_mode = 'Y' THEN
2084: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG