APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on PA_PROJECTS_ALL

Line 92: l_pc_code pa_projects_all.project_currency_code%type;

88: l_msg_count NUMBER;
89: l_data VARCHAR2(1000);
90: l_msg_data VARCHAR2(1000);
91: l_msg_index_out NUMBER;
92: l_pc_code pa_projects_all.project_currency_code%type;
93: l_pfc_code pa_projects_all.project_currency_code%type;
94: l_project_name pa_projects_all.name%TYPE;
95: l_task_id pa_tasks.task_id%TYPE;
96: l_task_name pa_proj_elements.name%TYPE;

Line 93: l_pfc_code pa_projects_all.project_currency_code%type;

89: l_data VARCHAR2(1000);
90: l_msg_data VARCHAR2(1000);
91: l_msg_index_out NUMBER;
92: l_pc_code pa_projects_all.project_currency_code%type;
93: l_pfc_code pa_projects_all.project_currency_code%type;
94: l_project_name pa_projects_all.name%TYPE;
95: l_task_id pa_tasks.task_id%TYPE;
96: l_task_name pa_proj_elements.name%TYPE;
97: l_resource_name pa_resource_list_members.alias%TYPE;

Line 94: l_project_name pa_projects_all.name%TYPE;

90: l_msg_data VARCHAR2(1000);
91: l_msg_index_out NUMBER;
92: l_pc_code pa_projects_all.project_currency_code%type;
93: l_pfc_code pa_projects_all.project_currency_code%type;
94: l_project_name pa_projects_all.name%TYPE;
95: l_task_id pa_tasks.task_id%TYPE;
96: l_task_name pa_proj_elements.name%TYPE;
97: l_resource_name pa_resource_list_members.alias%TYPE;
98: BEGIN

Line 112: FROM pa_projects_all

108: /*Bug 4151764 neet to get project_name, task_name, resource_name for the error message*/
109:
110: SELECT project_currency_code,projfunc_currency_code, name
111: INTO l_pc_code , l_pfc_code, l_project_name
112: FROM pa_projects_all
113: WHERE project_id = p_project_id;
114:
115: IF p_res_asg_id is NULL THEN
116: l_task_name := null;

Line 423: c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE,

419: --Cursor used to sum the revenue amount
420: CURSOR SUM_BILL_CRSR(c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
421: c_appl_id GL_PERIOD_STATUSES.APPLICATION_ID%TYPE,
422: c_set_of_books_id PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE,
423: c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE,
424: c_multi_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
425: c_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
426: c_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE)
427: IS

Line 524: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

520: l_billstart_date PA_PLSQL_DATATYPES.DateTabTyp;
521: l_billend_date PA_PLSQL_DATATYPES.DateTabTyp;
522: l_rev_sum PA_PLSQL_DATATYPES.NumTabTyp;
523:
524: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
525:
526: l_icount NUMBER := 0;
527: l_ucount NUMBER := 0;
528: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;

Line 1385: (P_PROJECT_ID IN pa_projects_all.project_id%type,

1381:
1382: END GEN_BILLING_AMOUNTS;
1383:
1384: PROCEDURE GET_BILLING_EVENT_AMT_IN_PFC
1385: (P_PROJECT_ID IN pa_projects_all.project_id%type,
1386: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%type,
1387: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1388: P_PROJFUNC_CURRENCY_CODE IN pa_projects_all.projfunc_currency_code%type,
1389: P_PROJECT_CURRENCY_CODE IN pa_projects_all.project_currency_code%type,

Line 1388: P_PROJFUNC_CURRENCY_CODE IN pa_projects_all.projfunc_currency_code%type,

1384: PROCEDURE GET_BILLING_EVENT_AMT_IN_PFC
1385: (P_PROJECT_ID IN pa_projects_all.project_id%type,
1386: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%type,
1387: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1388: P_PROJFUNC_CURRENCY_CODE IN pa_projects_all.projfunc_currency_code%type,
1389: P_PROJECT_CURRENCY_CODE IN pa_projects_all.project_currency_code%type,
1390: X_PROJFUNC_REVENUE OUT NOCOPY NUMBER,
1391: X_PROJECT_REVENUE OUT NOCOPY NUMBER,
1392: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1389: P_PROJECT_CURRENCY_CODE IN pa_projects_all.project_currency_code%type,

1385: (P_PROJECT_ID IN pa_projects_all.project_id%type,
1386: P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%type,
1387: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1388: P_PROJFUNC_CURRENCY_CODE IN pa_projects_all.projfunc_currency_code%type,
1389: P_PROJECT_CURRENCY_CODE IN pa_projects_all.project_currency_code%type,
1390: X_PROJFUNC_REVENUE OUT NOCOPY NUMBER,
1391: X_PROJECT_REVENUE OUT NOCOPY NUMBER,
1392: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1393: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2006: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

2002:
2003: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.UPD_TMP4_TXN_RA_ID_AND_ML';
2004:
2005: l_etc_start_date DATE;
2006: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
2007:
2008: l_res_assgn_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2009: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2010: l_txn_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;