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_AMOUNT_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 98: x_project_id pa_resource_assignments.project_id%TYPE,

94: X_MSG_DATA OUT NOCOPY VARCHAR2,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
96:
97: TYPE RESOURCE_ASN_REC IS RECORD (
98: x_project_id pa_resource_assignments.project_id%TYPE,
99: x_rate_task_id pa_resource_assignments.task_id%TYPE,
100: x_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE,
101: x_resource_class_code pa_resource_assignments.resource_class_code%TYPE,
102: x_organization_id pa_resource_assignments.organization_id%TYPE,

Line 99: x_rate_task_id pa_resource_assignments.task_id%TYPE,

95: X_RETURN_STATUS OUT NOCOPY VARCHAR2);
96:
97: TYPE RESOURCE_ASN_REC IS RECORD (
98: x_project_id pa_resource_assignments.project_id%TYPE,
99: x_rate_task_id pa_resource_assignments.task_id%TYPE,
100: x_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE,
101: x_resource_class_code pa_resource_assignments.resource_class_code%TYPE,
102: x_organization_id pa_resource_assignments.organization_id%TYPE,
103: x_job_id pa_resource_assignments.job_id%TYPE,

Line 100: x_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE,

96:
97: TYPE RESOURCE_ASN_REC IS RECORD (
98: x_project_id pa_resource_assignments.project_id%TYPE,
99: x_rate_task_id pa_resource_assignments.task_id%TYPE,
100: x_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE,
101: x_resource_class_code pa_resource_assignments.resource_class_code%TYPE,
102: x_organization_id pa_resource_assignments.organization_id%TYPE,
103: x_job_id pa_resource_assignments.job_id%TYPE,
104: x_person_id pa_resource_assignments.person_id%TYPE,

Line 101: x_resource_class_code pa_resource_assignments.resource_class_code%TYPE,

97: TYPE RESOURCE_ASN_REC IS RECORD (
98: x_project_id pa_resource_assignments.project_id%TYPE,
99: x_rate_task_id pa_resource_assignments.task_id%TYPE,
100: x_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE,
101: x_resource_class_code pa_resource_assignments.resource_class_code%TYPE,
102: x_organization_id pa_resource_assignments.organization_id%TYPE,
103: x_job_id pa_resource_assignments.job_id%TYPE,
104: x_person_id pa_resource_assignments.person_id%TYPE,
105: x_expenditure_type pa_resource_assignments.expenditure_type%TYPE,

Line 102: x_organization_id pa_resource_assignments.organization_id%TYPE,

98: x_project_id pa_resource_assignments.project_id%TYPE,
99: x_rate_task_id pa_resource_assignments.task_id%TYPE,
100: x_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE,
101: x_resource_class_code pa_resource_assignments.resource_class_code%TYPE,
102: x_organization_id pa_resource_assignments.organization_id%TYPE,
103: x_job_id pa_resource_assignments.job_id%TYPE,
104: x_person_id pa_resource_assignments.person_id%TYPE,
105: x_expenditure_type pa_resource_assignments.expenditure_type%TYPE,
106: x_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE,

Line 103: x_job_id pa_resource_assignments.job_id%TYPE,

99: x_rate_task_id pa_resource_assignments.task_id%TYPE,
100: x_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE,
101: x_resource_class_code pa_resource_assignments.resource_class_code%TYPE,
102: x_organization_id pa_resource_assignments.organization_id%TYPE,
103: x_job_id pa_resource_assignments.job_id%TYPE,
104: x_person_id pa_resource_assignments.person_id%TYPE,
105: x_expenditure_type pa_resource_assignments.expenditure_type%TYPE,
106: x_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE,
107: x_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE,

Line 104: x_person_id pa_resource_assignments.person_id%TYPE,

100: x_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE,
101: x_resource_class_code pa_resource_assignments.resource_class_code%TYPE,
102: x_organization_id pa_resource_assignments.organization_id%TYPE,
103: x_job_id pa_resource_assignments.job_id%TYPE,
104: x_person_id pa_resource_assignments.person_id%TYPE,
105: x_expenditure_type pa_resource_assignments.expenditure_type%TYPE,
106: x_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE,
107: x_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE,
108: x_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE,

Line 105: x_expenditure_type pa_resource_assignments.expenditure_type%TYPE,

101: x_resource_class_code pa_resource_assignments.resource_class_code%TYPE,
102: x_organization_id pa_resource_assignments.organization_id%TYPE,
103: x_job_id pa_resource_assignments.job_id%TYPE,
104: x_person_id pa_resource_assignments.person_id%TYPE,
105: x_expenditure_type pa_resource_assignments.expenditure_type%TYPE,
106: x_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE,
107: x_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE,
108: x_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE,
109: x_item_category_id pa_resource_assignments.item_category_id%TYPE,

Line 106: x_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE,

102: x_organization_id pa_resource_assignments.organization_id%TYPE,
103: x_job_id pa_resource_assignments.job_id%TYPE,
104: x_person_id pa_resource_assignments.person_id%TYPE,
105: x_expenditure_type pa_resource_assignments.expenditure_type%TYPE,
106: x_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE,
107: x_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE,
108: x_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE,
109: x_item_category_id pa_resource_assignments.item_category_id%TYPE,
110: x_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE,

Line 107: x_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE,

103: x_job_id pa_resource_assignments.job_id%TYPE,
104: x_person_id pa_resource_assignments.person_id%TYPE,
105: x_expenditure_type pa_resource_assignments.expenditure_type%TYPE,
106: x_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE,
107: x_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE,
108: x_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE,
109: x_item_category_id pa_resource_assignments.item_category_id%TYPE,
110: x_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE,
111: x_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE,

Line 108: x_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE,

104: x_person_id pa_resource_assignments.person_id%TYPE,
105: x_expenditure_type pa_resource_assignments.expenditure_type%TYPE,
106: x_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE,
107: x_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE,
108: x_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE,
109: x_item_category_id pa_resource_assignments.item_category_id%TYPE,
110: x_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE,
111: x_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE,
112: x_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE,

Line 109: x_item_category_id pa_resource_assignments.item_category_id%TYPE,

105: x_expenditure_type pa_resource_assignments.expenditure_type%TYPE,
106: x_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE,
107: x_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE,
108: x_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE,
109: x_item_category_id pa_resource_assignments.item_category_id%TYPE,
110: x_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE,
111: x_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE,
112: x_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE,
113: x_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE);

Line 110: x_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE,

106: x_non_labor_resource pa_resource_assignments.non_labor_resource%TYPE,
107: x_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE,
108: x_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE,
109: x_item_category_id pa_resource_assignments.item_category_id%TYPE,
110: x_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE,
111: x_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE,
112: x_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE,
113: x_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE);
114:

Line 111: x_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE,

107: x_bom_resource_id pa_resource_assignments.bom_resource_id%TYPE,
108: x_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE,
109: x_item_category_id pa_resource_assignments.item_category_id%TYPE,
110: x_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE,
111: x_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE,
112: x_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE,
113: x_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE);
114:
115: TYPE PA_TASKS_REC IS RECORD (

Line 112: x_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE,

108: x_inventory_item_id pa_resource_assignments.inventory_item_id%TYPE,
109: x_item_category_id pa_resource_assignments.item_category_id%TYPE,
110: x_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE,
111: x_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE,
112: x_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE,
113: x_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE);
114:
115: TYPE PA_TASKS_REC IS RECORD (
116: x_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE,

Line 113: x_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE);

109: x_item_category_id pa_resource_assignments.item_category_id%TYPE,
110: x_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE,
111: x_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE,
112: x_rate_expenditure_org_id pa_resource_assignments.rate_expenditure_org_id%TYPE,
113: x_rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE);
114:
115: TYPE PA_TASKS_REC IS RECORD (
116: x_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE,
117: x_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE,

Line 162: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

158:
159: PROCEDURE GET_VALUES_FOR_PLANNING_RATE
160: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
161: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
162: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
163: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
164: P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,
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,

Line 164: P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,

160: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
161: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
162: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
163: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
164: P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,
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,

Line 198: P_RESOURCE_CLASS_CODE pa_resource_assignments.resource_class_code%type)

194: /* This function returns the RLM ID for the given
195: project id + res list id + resource class level resource combination. */
196: FUNCTION GET_RLM_ID(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
197: P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
198: P_RESOURCE_CLASS_CODE pa_resource_assignments.resource_class_code%type)
199: RETURN NUMBER;
200:
201: /**
202: * 30-JUN-05 dkuo added parameters P_CHECK_SRC_ERRORS, X_WARNING_MESSAGE.