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 905: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

901:
902:
903: PROCEDURE COPY_TABLE_RECORDS
904: ( P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
905: P_SRC_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
906: P_COPY_MODE IN VARCHAR2,
907: P_CALLING_MODULE IN VARCHAR2,
908: P_VERSION_LEVEL_FLAG IN VARCHAR2,
909: P_CALLED_MODE IN VARCHAR2,

Line 1068: l_wp_version_flag PA_BUDGET_VERSIONS.WP_VERSION_FLAG%TYPE;

1064:
1065: l_NULL_NumTabTyp PA_PLSQL_DATATYPES.NumTabTyp;
1066:
1067: -- Indicates if the Target version is a Workplan.
1068: l_wp_version_flag PA_BUDGET_VERSIONS.WP_VERSION_FLAG%TYPE;
1069:
1070: BEGIN
1071: IF p_pa_debug_mode = 'Y' THEN
1072: PA_DEBUG.SET_CURR_FUNCTION

Line 1092: FROM pa_budget_versions

1088:
1089: BEGIN
1090: SELECT nvl(wp_version_flag,'N')
1091: INTO l_wp_version_flag
1092: FROM pa_budget_versions
1093: WHERE budget_version_id = p_fp_cols_rec.x_budget_version_id;
1094: EXCEPTION WHEN NO_DATA_FOUND THEN
1095: IF p_pa_debug_mode = 'Y' THEN
1096: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

Line 2082: l_wp_version_flag PA_BUDGET_VERSIONS.WP_VERSION_FLAG%TYPE;

2078:
2079: l_NULL_NumTabTyp PA_PLSQL_DATATYPES.NumTabTyp;
2080:
2081: -- Indicates if the Target version is a Workplan.
2082: l_wp_version_flag PA_BUDGET_VERSIONS.WP_VERSION_FLAG%TYPE;
2083:
2084: BEGIN
2085:
2086: IF p_pa_debug_mode = 'Y' THEN

Line 2105: FROM pa_budget_versions

2101:
2102: BEGIN
2103: SELECT nvl(wp_version_flag,'N')
2104: INTO l_wp_version_flag
2105: FROM pa_budget_versions
2106: WHERE budget_version_id = p_fp_cols_rec.x_budget_version_id;
2107: EXCEPTION WHEN NO_DATA_FOUND THEN
2108: IF p_pa_debug_mode = 'Y' THEN
2109: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG