eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_BUDGET_VERSIONS

Line 15: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

11: * for list of valid parameter values.
12: **/
13: PROCEDURE GENERATE_BUDGET_AMT_WRP
14: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
15: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
16: P_CALLED_MODE IN VARCHAR2,
17: P_COMMIT_FLAG IN VARCHAR2,
18: P_INIT_MSG_FLAG IN VARCHAR2,
19: P_CHECK_SRC_ERRORS_FLAG IN VARCHAR2,

Line 27: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

23: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
24:
25: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP';
26:
27: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
28: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
29: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
30: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
31: l_commit_flag VARCHAR2(1);

Line 47: l_source_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

43: -- g_mrc_exception EXCEPTION;
44:
45: l_wp_track_cost_flag VARCHAR2(1);
46:
47: l_source_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
48:
49: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
50:
51: l_res_as_id PA_PLSQL_DATATYPES.IdTabTyp; /* Bug 4160375 */

Line 49: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

45: l_wp_track_cost_flag VARCHAR2(1);
46:
47: l_source_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
48:
49: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
50:
51: l_res_as_id PA_PLSQL_DATATYPES.IdTabTyp; /* Bug 4160375 */
52: BEGIN
53: --hr_utility.trace_on(null,'mftest');

Line 152: FROM pa_budget_versions

148: --acquire version lock
149:
150: SELECT record_version_number
151: INTO l_record_version_number
152: FROM pa_budget_versions
153: WHERE budget_version_id = p_budget_version_id;
154: IF p_pa_debug_mode = 'Y' THEN
155: pa_fp_gen_amount_utils.fp_debug
156: (p_called_mode => p_called_mode,

Line 575: FROM pa_proj_fp_options opt, pa_budget_versions bv

571: 'COST', opt.gen_src_cost_plan_version_id,
572: 'REVENUE',opt.gen_src_rev_plan_version_id,
573: 'ALL',opt.gen_src_all_plan_version_id)
574: INTO l_source_bv_id
575: FROM pa_proj_fp_options opt, pa_budget_versions bv
576: WHERE bv.budget_version_id = opt.fin_plan_version_id
577: AND bv.budget_version_id = p_budget_version_id ;
578: END IF;
579:

Line 892: UPDATE PA_BUDGET_VERSIONS SET PLAN_PROCESSING_CODE = 'E'

888: END;
889:
890: PROCEDURE UPDATE_BUDG_VERSION(p_budget_version_id IN NUMBER ) IS
891: BEGIN
892: UPDATE PA_BUDGET_VERSIONS SET PLAN_PROCESSING_CODE = 'E'
893: WHERE BUDGET_VERSION_ID = p_budget_version_id;
894: COMMIT;
895: END;
896:

Line 901: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

897: /* Procedure to generate budget amount when
898: planning level is Resource Schedule */
899: PROCEDURE GENERATE_BUDGET_AMT_RES_SCH
900: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
901: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
902: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
903: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
904: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
905: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

Line 906: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

902: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
903: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
904: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
905: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
906: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
907: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
908: P_CALLED_MODE IN VARCHAR2,
909: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
910: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

Line 1392: ,pa_budget_versions bv

1388: ,pp.labor_sch_type
1389: ,pp.non_labor_sch_type
1390: ,pp.name project_name
1391: FROM pa_proj_fp_options pfo
1392: ,pa_budget_versions bv
1393: ,pa_projects_all pp
1394: WHERE pfo.fin_plan_version_id = bv.budget_version_id
1395: AND bv.budget_version_id = p_budget_version_id
1396: AND pp.project_id = bv.project_id

Line 1609: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

1605: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1606: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1607:
1608:
1609: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1610: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;
1611: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
1612:
1613: --Declaring PL/SQL tables for bulk binding

Line 1610: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;

1606: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1607:
1608:
1609: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1610: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;
1611: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
1612:
1613: --Declaring PL/SQL tables for bulk binding
1614: l_proj_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 1611: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;

1607:
1608:
1609: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1610: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;
1611: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
1612:
1613: --Declaring PL/SQL tables for bulk binding
1614: l_proj_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
1615: l_proj_start_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 4397: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

4393: END GENERATE_BUDGET_AMT_RES_SCH;
4394:
4395: PROCEDURE CREATE_RES_ASG
4396: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
4397: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4398: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
4399: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
4400: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4401: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,

Line 4401: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,

4397: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4398: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
4399: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
4400: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4401: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
4402: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4403: X_MSG_COUNT OUT NOCOPY NUMBER,
4404: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
4405:

Line 4637: l_wp_version_flag pa_budget_Versions.wp_version_flag%TYPE;

4633: l_rec_ver_number_1 NUMBER:=1;
4634:
4635: l_count NUMBER;
4636: l_count1 NUMBER;
4637: l_wp_version_flag pa_budget_Versions.wp_version_flag%TYPE;
4638: l_gen_src_code pa_proj_fp_options.gen_all_src_code%TYPE := null;
4639:
4640: --Bug 4052036. This tbl will hold the ra ids that are inserted in this API
4641: l_ins_ra_id_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4682: FROM pa_budget_versions

4678: END IF;
4679:
4680: SELECT NVL(wp_version_flag,'N')
4681: INTO l_wp_version_flag
4682: FROM pa_budget_versions
4683: WHERE budget_version_id=P_BUDGET_VERSION_ID;
4684:
4685: FORALL i IN 1..l_res_list_member_id.count
4686: INSERT INTO PA_RESOURCE_ASSIGNMENTS(RESOURCE_ASSIGNMENT_ID,

Line 5169: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

5165: /* Procedure to update the reosurce_assignment_id
5166: in the resource assignment table*/
5167: PROCEDURE UPDATE_RES_ASG
5168: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5169: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5170: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
5171: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
5172: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5173: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,

Line 5173: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,

5169: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5170: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
5171: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
5172: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5173: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
5174: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5175: X_MSG_COUNT OUT NOCOPY NUMBER,
5176: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5177:

Line 5586: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

5582: by the previous source in the same run.
5583: */
5584: PROCEDURE DEL_MANUAL_BDGT_LINES
5585: ( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5586: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5587: PX_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
5588: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
5589: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5590: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5686: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

5682: END DEL_MANUAL_BDGT_LINES;
5683:
5684: PROCEDURE UPDATE_INIT_AMOUNTS
5685: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5686: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5687: P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
5688: --this pl/sql table will have newly created res_asg_id from the source
5689: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5690: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5747: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

5743: /* Procedure to update the latest amount
5744: generation date in the budget versions table*/
5745: PROCEDURE UPDATE_BV_FOR_GEN_DATE
5746: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5747: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5748: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
5749: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5750: X_MSG_COUNT OUT NOCOPY NUMBER,
5751: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 5748: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,

5744: generation date in the budget versions table*/
5745: PROCEDURE UPDATE_BV_FOR_GEN_DATE
5746: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5747: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5748: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
5749: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5750: X_MSG_COUNT OUT NOCOPY NUMBER,
5751: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5752:

Line 5769: UPDATE PA_BUDGET_VERSIONS

5765: pa_debug.set_curr_function( p_function => 'UPDATE_BV_FOR_GEN_DATE'
5766: ,p_debug_mode => p_pa_debug_mode);
5767: END IF;
5768:
5769: UPDATE PA_BUDGET_VERSIONS
5770: SET LAST_AMT_GEN_DATE = l_sysdate,
5771: LAST_UPDATE_DATE = l_sysdate,
5772: LAST_UPDATED_BY = l_last_updated_by,
5773: CREATION_DATE = l_sysdate,

Line 5803: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

5799: END UPDATE_BV_FOR_GEN_DATE;
5800:
5801: PROCEDURE GET_GENERATED_RES_ASG
5802: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5803: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5804: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
5805: P_CHK_DUPLICATE_FLAG IN VARCHAR2,
5806: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5807: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5895: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

5891: missing currencies to all the workplan versions
5892: ******************************************************************************/
5893: PROCEDURE INSERT_TXN_CURRENCY
5894: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5895: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5896: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5897: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5898: X_MSG_COUNT OUT NOCOPY NUMBER,
5899: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 5914: l_wp_version_flag pa_budget_versions.wp_version_flag%type;

5910: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
5911: l_last_update_login NUMBER := FND_GLOBAL.login_id;
5912: l_sysdate DATE := SYSDATE;
5913:
5914: l_wp_version_flag pa_budget_versions.wp_version_flag%type;
5915:
5916: BEGIN
5917: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5918: X_MSG_COUNT := 0;

Line 5971: FROM pa_budget_versions

5967: type and then all the working workplan versions*/
5968:
5969: SELECT nvl(wp_version_flag,'N')
5970: INTO l_wp_version_flag
5971: FROM pa_budget_versions
5972: WHERE budget_version_id = p_budget_version_id;
5973:
5974: IF l_wp_version_flag = 'N' THEN
5975:

Line 5992: FROM pa_budget_versions bv,

5988: ,pfo.proj_fp_options_id
5989: BULK COLLECT INTO
5990: l_budget_version_id_tbl,
5991: l_proj_fp_options_id_tbl
5992: FROM pa_budget_versions bv,
5993: --bug 3919127 pa_proj_elem_ver_structure ver,
5994: pa_proj_fp_options pfo
5995: WHERE bv.project_id = p_project_id
5996: AND bv.wp_version_flag = 'Y'

Line 6098: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END INSERT_TXN_CURRENCY;
6096:
6097: PROCEDURE RESET_COST_AMOUNTS
6098: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6099: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6100: X_MSG_COUNT OUT NOCOPY NUMBER,
6101: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6102: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS';

Line 6152: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6148: END RESET_COST_AMOUNTS;
6149:
6150: PROCEDURE GEN_REV_BDGT_AMT_RES_SCH_WRP
6151: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
6152: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6153: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6154: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6155: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6156: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

Line 6157: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6153: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6154: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6155: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6156: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6157: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6158: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
6159: P_CALLED_MODE IN VARCHAR2,
6160: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
6161: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

Line 6701: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6697: END GEN_REV_BDGT_AMT_RES_SCH_WRP;
6698:
6699: PROCEDURE GEN_WP_REV_BDGT_AMT_WRP
6700: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6701: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6702: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6703: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6704: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6705: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 6705: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6701: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6702: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6703: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6704: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6705: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6706: P_RETAIN_MANUAL_FLAG IN VARCHAR2,
6707: P_CALLED_MODE IN VARCHAR2,
6708: P_INC_CHG_DOC_FLAG IN VARCHAR2,
6709: P_INC_BILL_EVENT_FLAG IN VARCHAR2,