DBA Data[Home] [Help]

APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_NUM_TBL_TYPE

Line 18: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

14: X_MSG_COUNT OUT NOCOPY NUMBER,
15: X_MSG_DATA OUT NOCOPY VARCHAR2)
16: IS
17: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.copy_actuals';
18: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
19: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
20: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
21: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
22: l_end_date_pji_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 19: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

15: X_MSG_DATA OUT NOCOPY VARCHAR2)
16: IS
17: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.copy_actuals';
18: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
19: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
20: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
21: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
22: l_end_date_pji_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
23: l_calendar_type VARCHAR2(15);

Line 20: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

16: IS
17: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.copy_actuals';
18: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
19: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
20: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
21: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
22: l_end_date_pji_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
23: l_calendar_type VARCHAR2(15);
24: l_record_type VARCHAR2(15);

Line 1994: P_RESOURCE_ASSGN_IDS IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

1990: **/
1991: PROCEDURE COLLECT_ACTUALS
1992: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1993: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1994: P_RESOURCE_ASSGN_IDS IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
1995: P_INIT_MSG_FLAG IN VARCHAR2 default 'Y',
1996: P_COMMIT_FLAG IN VARCHAR2 default 'N',
1997: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1998: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2010: l_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2006:
2007: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2008:
2009: l_actuals_through_date DATE;
2010: l_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2011: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
2012: l_del_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2013: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2014: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2012: l_del_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2008:
2009: l_actuals_through_date DATE;
2010: l_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2011: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
2012: l_del_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2013: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2014: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2015: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2016: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 2013: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2009: l_actuals_through_date DATE;
2010: l_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2011: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
2012: l_del_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2013: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2014: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2015: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2016: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2017: l_end_date_pji_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2014: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2010: l_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2011: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
2012: l_del_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2013: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2014: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2015: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2016: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2017: l_end_date_pji_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2018: l_calendar_type VARCHAR2(15);

Line 2015: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

2011: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
2012: l_del_resource_assgn_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2013: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2014: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2015: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2016: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
2017: l_end_date_pji_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
2018: l_calendar_type VARCHAR2(15);
2019: l_record_type VARCHAR2(15);