DBA Data[Home] [Help]

APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_PROJECTS_ALL

Line 41: X_ORG_ID PA_PROJECTS_ALL.ORG_ID%TYPE,

37: X_GEN_RET_MANUAL_LINE_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
38: X_GEN_ACTUAL_AMTS_THRU_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE,
39: X_GEN_INCL_UNSPENT_AMT_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
40: X_PLAN_IN_MULTI_CURR_FLAG PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
41: X_ORG_ID PA_PROJECTS_ALL.ORG_ID%TYPE,
42: X_PROJECT_CURRENCY_CODE PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
43: X_PROJFUNC_CURRENCY_CODE PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE,
44: X_SET_OF_BOOKS_ID PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE,
45: X_RAW_COST_FLAG PA_FIN_PLAN_AMOUNT_SETS.RAW_COST_FLAG%TYPE,

Line 42: X_PROJECT_CURRENCY_CODE PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

38: X_GEN_ACTUAL_AMTS_THRU_CODE PA_PROJ_FP_OPTIONS.GEN_COST_ACTUAL_AMTS_THRU_CODE%TYPE,
39: X_GEN_INCL_UNSPENT_AMT_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
40: X_PLAN_IN_MULTI_CURR_FLAG PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
41: X_ORG_ID PA_PROJECTS_ALL.ORG_ID%TYPE,
42: X_PROJECT_CURRENCY_CODE PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
43: X_PROJFUNC_CURRENCY_CODE PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE,
44: X_SET_OF_BOOKS_ID PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE,
45: X_RAW_COST_FLAG PA_FIN_PLAN_AMOUNT_SETS.RAW_COST_FLAG%TYPE,
46: X_BURDENED_FLAG PA_FIN_PLAN_AMOUNT_SETS.BURDENED_COST_FLAG%TYPE,

Line 43: X_PROJFUNC_CURRENCY_CODE PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE,

39: X_GEN_INCL_UNSPENT_AMT_FLAG PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
40: X_PLAN_IN_MULTI_CURR_FLAG PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
41: X_ORG_ID PA_PROJECTS_ALL.ORG_ID%TYPE,
42: X_PROJECT_CURRENCY_CODE PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
43: X_PROJFUNC_CURRENCY_CODE PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE,
44: X_SET_OF_BOOKS_ID PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE,
45: X_RAW_COST_FLAG PA_FIN_PLAN_AMOUNT_SETS.RAW_COST_FLAG%TYPE,
46: X_BURDENED_FLAG PA_FIN_PLAN_AMOUNT_SETS.BURDENED_COST_FLAG%TYPE,
47: X_REVENUE_FLAG PA_FIN_PLAN_AMOUNT_SETS.REVENUE_FLAG%TYPE,

Line 57: X_PROJECT_VALUE PA_PROJECTS_ALL.PROJECT_VALUE%TYPE,

53: X_BURDEN_RATE_FLAG PA_FIN_PLAN_AMOUNT_SETS.BURDEN_RATE_FLAG%TYPE,
54: X_PROJECT_STRUCTURE_VERSION_ID PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
55: X_PLAN_CLASS_CODE PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
56: X_VERSION_TYPE PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
57: X_PROJECT_VALUE PA_PROJECTS_ALL.PROJECT_VALUE%TYPE,
58: X_TRACK_WORKPLAN_COSTS_FLAG PA_PROJ_FP_OPTIONS.TRACK_WORKPLAN_COSTS_FLAG%TYPE,
59: X_REVENUE_DERIVATION_METHOD VARCHAR2(1), -- bug 5152892
60: X_GEN_SRC_WP_VERSION_ID NUMBER(15),
61: X_GEN_SRC_WP_VER_CODE VARCHAR2(30));

Line 79: p_project_id IN pa_projects_all.project_id%TYPE,

75: X_MSG_DATA OUT NOCOPY VARCHAR2,
76: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
77:
78: PROCEDURE Get_Curr_Original_Version_Info(
79: p_project_id IN pa_projects_all.project_id%TYPE,
80: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
81: p_version_type IN pa_budget_versions.version_type%TYPE,
82: p_status_code IN VARCHAR2 DEFAULT 'CURRENT_ORIGINAL',
83: x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE,

Line 127: TYPE PA_PROJECTS_ALL_REC IS RECORD (

123: x_task_lab_sch_type pa_tasks.labor_sch_type%TYPE,
124: x_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE,
125: x_top_task_id pa_tasks.top_task_id%TYPE);
126:
127: TYPE PA_PROJECTS_ALL_REC IS RECORD (
128: x_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE,
129: x_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE,
130: x_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE,
131: x_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE,

Line 128: x_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE,

124: x_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE,
125: x_top_task_id pa_tasks.top_task_id%TYPE);
126:
127: TYPE PA_PROJECTS_ALL_REC IS RECORD (
128: x_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE,
129: x_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE,
130: x_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE,
131: x_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE,
132: x_org_id pa_projects_all.org_id%TYPE,

Line 129: x_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE,

125: x_top_task_id pa_tasks.top_task_id%TYPE);
126:
127: TYPE PA_PROJECTS_ALL_REC IS RECORD (
128: x_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE,
129: x_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE,
130: x_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE,
131: x_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE,
132: x_org_id pa_projects_all.org_id%TYPE,
133: x_non_labor_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE,

Line 130: x_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE,

126:
127: TYPE PA_PROJECTS_ALL_REC IS RECORD (
128: x_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE,
129: x_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE,
130: x_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE,
131: x_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE,
132: x_org_id pa_projects_all.org_id%TYPE,
133: x_non_labor_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE,
134: x_project_currency_code pa_projects_all.project_currency_code%TYPE,

Line 131: x_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE,

127: TYPE PA_PROJECTS_ALL_REC IS RECORD (
128: x_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE,
129: x_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE,
130: x_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE,
131: x_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE,
132: x_org_id pa_projects_all.org_id%TYPE,
133: x_non_labor_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE,
134: x_project_currency_code pa_projects_all.project_currency_code%TYPE,
135: x_non_labor_schedule_discount pa_projects_all.non_labor_schedule_discount%TYPE,

Line 132: x_org_id pa_projects_all.org_id%TYPE,

128: x_assign_precedes_task pa_projects_all.assign_precedes_task%TYPE,
129: x_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE,
130: x_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE,
131: x_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE,
132: x_org_id pa_projects_all.org_id%TYPE,
133: x_non_labor_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE,
134: x_project_currency_code pa_projects_all.project_currency_code%TYPE,
135: x_non_labor_schedule_discount pa_projects_all.non_labor_schedule_discount%TYPE,
136: x_non_labor_sch_fixed_date pa_projects_all.non_labor_schedule_fixed_date%TYPE,

Line 133: x_non_labor_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE,

129: x_bill_job_group_id pa_projects_all.bill_job_group_id%TYPE,
130: x_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE,
131: x_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE,
132: x_org_id pa_projects_all.org_id%TYPE,
133: x_non_labor_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE,
134: x_project_currency_code pa_projects_all.project_currency_code%TYPE,
135: x_non_labor_schedule_discount pa_projects_all.non_labor_schedule_discount%TYPE,
136: x_non_labor_sch_fixed_date pa_projects_all.non_labor_schedule_fixed_date%TYPE,
137: x_non_lab_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE,

Line 134: x_project_currency_code pa_projects_all.project_currency_code%TYPE,

130: x_carrying_out_organization_id pa_projects_all.carrying_out_organization_id%TYPE,
131: x_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE,
132: x_org_id pa_projects_all.org_id%TYPE,
133: x_non_labor_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE,
134: x_project_currency_code pa_projects_all.project_currency_code%TYPE,
135: x_non_labor_schedule_discount pa_projects_all.non_labor_schedule_discount%TYPE,
136: x_non_labor_sch_fixed_date pa_projects_all.non_labor_schedule_fixed_date%TYPE,
137: x_non_lab_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE,
138: x_project_type pa_projects_all.project_type%TYPE,

Line 135: x_non_labor_schedule_discount pa_projects_all.non_labor_schedule_discount%TYPE,

131: x_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE,
132: x_org_id pa_projects_all.org_id%TYPE,
133: x_non_labor_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE,
134: x_project_currency_code pa_projects_all.project_currency_code%TYPE,
135: x_non_labor_schedule_discount pa_projects_all.non_labor_schedule_discount%TYPE,
136: x_non_labor_sch_fixed_date pa_projects_all.non_labor_schedule_fixed_date%TYPE,
137: x_non_lab_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE,
138: x_project_type pa_projects_all.project_type%TYPE,
139: x_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE,

Line 136: x_non_labor_sch_fixed_date pa_projects_all.non_labor_schedule_fixed_date%TYPE,

132: x_org_id pa_projects_all.org_id%TYPE,
133: x_non_labor_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE,
134: x_project_currency_code pa_projects_all.project_currency_code%TYPE,
135: x_non_labor_schedule_discount pa_projects_all.non_labor_schedule_discount%TYPE,
136: x_non_labor_sch_fixed_date pa_projects_all.non_labor_schedule_fixed_date%TYPE,
137: x_non_lab_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE,
138: x_project_type pa_projects_all.project_type%TYPE,
139: x_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE,
140: x_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE,

Line 137: x_non_lab_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE,

133: x_non_labor_bill_rate_org_id pa_projects_all.non_labor_bill_rate_org_id%TYPE,
134: x_project_currency_code pa_projects_all.project_currency_code%TYPE,
135: x_non_labor_schedule_discount pa_projects_all.non_labor_schedule_discount%TYPE,
136: x_non_labor_sch_fixed_date pa_projects_all.non_labor_schedule_fixed_date%TYPE,
137: x_non_lab_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE,
138: x_project_type pa_projects_all.project_type%TYPE,
139: x_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE,
140: x_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE,
141: x_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE,

Line 138: x_project_type pa_projects_all.project_type%TYPE,

134: x_project_currency_code pa_projects_all.project_currency_code%TYPE,
135: x_non_labor_schedule_discount pa_projects_all.non_labor_schedule_discount%TYPE,
136: x_non_labor_sch_fixed_date pa_projects_all.non_labor_schedule_fixed_date%TYPE,
137: x_non_lab_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE,
138: x_project_type pa_projects_all.project_type%TYPE,
139: x_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE,
140: x_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE,
141: x_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE,
142: x_labor_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE,

Line 139: x_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE,

135: x_non_labor_schedule_discount pa_projects_all.non_labor_schedule_discount%TYPE,
136: x_non_labor_sch_fixed_date pa_projects_all.non_labor_schedule_fixed_date%TYPE,
137: x_non_lab_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE,
138: x_project_type pa_projects_all.project_type%TYPE,
139: x_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE,
140: x_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE,
141: x_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE,
142: x_labor_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE,
143: x_labor_sch_type pa_projects_all.labor_sch_type%TYPE,

Line 140: x_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE,

136: x_non_labor_sch_fixed_date pa_projects_all.non_labor_schedule_fixed_date%TYPE,
137: x_non_lab_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE,
138: x_project_type pa_projects_all.project_type%TYPE,
139: x_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE,
140: x_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE,
141: x_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE,
142: x_labor_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE,
143: x_labor_sch_type pa_projects_all.labor_sch_type%TYPE,
144: x_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE);

Line 141: x_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE,

137: x_non_lab_std_bill_rt_sch_id pa_projects_all.non_lab_std_bill_rt_sch_id%TYPE,
138: x_project_type pa_projects_all.project_type%TYPE,
139: x_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE,
140: x_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE,
141: x_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE,
142: x_labor_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE,
143: x_labor_sch_type pa_projects_all.labor_sch_type%TYPE,
144: x_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE);
145:

Line 142: x_labor_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE,

138: x_project_type pa_projects_all.project_type%TYPE,
139: x_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE,
140: x_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE,
141: x_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE,
142: x_labor_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE,
143: x_labor_sch_type pa_projects_all.labor_sch_type%TYPE,
144: x_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE);
145:
146: TYPE PROJ_FP_OPTIONS_REC IS RECORD (

Line 143: x_labor_sch_type pa_projects_all.labor_sch_type%TYPE,

139: x_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE,
140: x_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE,
141: x_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE,
142: x_labor_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE,
143: x_labor_sch_type pa_projects_all.labor_sch_type%TYPE,
144: x_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE);
145:
146: TYPE PROJ_FP_OPTIONS_REC IS RECORD (
147: x_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE,

Line 144: x_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE);

140: x_emp_bill_rate_schedule_id pa_projects_all.emp_bill_rate_schedule_id%TYPE,
141: x_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE,
142: x_labor_bill_rate_org_id pa_projects_all.labor_bill_rate_org_id%TYPE,
143: x_labor_sch_type pa_projects_all.labor_sch_type%TYPE,
144: x_non_labor_sch_type pa_projects_all.non_labor_sch_type%TYPE);
145:
146: TYPE PROJ_FP_OPTIONS_REC IS RECORD (
147: x_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE,
148: x_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE,

Line 169: X_PA_PROJECTS_ALL_REC OUT NOCOPY PA_PROJECTS_ALL_REC,

165: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.txn_currency_code%TYPE,
166: X_RES_FORMAT_ID OUT NOCOPY PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,
167: X_RESOURCE_ASN_REC OUT NOCOPY RESOURCE_ASN_REC,
168: X_PA_TASKS_REC OUT NOCOPY PA_TASKS_REC,
169: X_PA_PROJECTS_ALL_REC OUT NOCOPY PA_PROJECTS_ALL_REC,
170: X_PROJ_FP_OPTIONS_REC OUT NOCOPY PROJ_FP_OPTIONS_REC,
171: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
172: X_MSG_COUNT OUT NOCOPY NUMBER,
173: X_MSG_DATA OUT NOCOPY VARCHAR2);