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.

[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on STANDARD

Line 4329: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE

4325: IF l_ins_task_elem_version_id_tbl.COUNT > 0 THEN
4326: FORALL i IN l_ins_task_elem_version_id_tbl.FIRST .. l_ins_task_elem_version_id_tbl.LAST
4327: INSERT INTO PA_RESOURCE_ASSIGNMENTS (
4328: RESOURCE_ASSIGNMENT_ID,BUDGET_VERSION_ID,PROJECT_ID,TASK_ID,RESOURCE_LIST_MEMBER_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY
4329: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE
4330: ,PROJECT_ASSIGNMENT_ID,PLAN_ERROR_CODE,TOTAL_PLAN_REVENUE,TOTAL_PLAN_RAW_COST,TOTAL_PLAN_BURDENED_COST,TOTAL_PLAN_QUANTITY
4331: ,AVERAGE_DISCOUNT_PERCENTAGE,TOTAL_BORROWED_REVENUE,TOTAL_TP_REVENUE_IN,TOTAL_TP_REVENUE_OUT,TOTAL_REVENUE_ADJ
4332: ,TOTAL_LENT_RESOURCE_COST,TOTAL_TP_COST_IN,TOTAL_TP_COST_OUT,TOTAL_COST_ADJ,TOTAL_UNASSIGNED_TIME_COST
4333: ,TOTAL_UTILIZATION_PERCENT,TOTAL_UTILIZATION_HOURS,TOTAL_UTILIZATION_ADJ,TOTAL_CAPACITY,TOTAL_HEAD_COUNT

Line 4361: ,NULL -- STANDARD_BILL_RATE

4357: ,fnd_global.user_id -- CREATED_BY
4358: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4359: ,l_unit_of_measure_tbl(l_ppl_index) -- UNIT_OF_MEASURE
4360: ,NULL -- TRACK_AS_LABOR_FLAG
4361: ,NULL -- STANDARD_BILL_RATE
4362: ,NULL -- AVERAGE_BILL_RATE
4363: ,NULL -- AVERAGE_COST_RATE
4364: ,-1 -- PROJECT_ASSIGNMENT_ID
4365: ,NULL -- PLAN_ERROR_CODE

Line 4620: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE

4616: -------------------------------------------------------------------
4617: FORALL j IN l_eligible_rlm_ids_tbl.FIRST .. l_eligible_rlm_ids_tbl.LAST
4618: INSERT INTO PA_RESOURCE_ASSIGNMENTS (
4619: RESOURCE_ASSIGNMENT_ID,BUDGET_VERSION_ID,PROJECT_ID,TASK_ID,RESOURCE_LIST_MEMBER_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY
4620: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE
4621: ,PROJECT_ASSIGNMENT_ID,PLAN_ERROR_CODE,TOTAL_PLAN_REVENUE,TOTAL_PLAN_RAW_COST,TOTAL_PLAN_BURDENED_COST,TOTAL_PLAN_QUANTITY
4622: ,AVERAGE_DISCOUNT_PERCENTAGE,TOTAL_BORROWED_REVENUE,TOTAL_TP_REVENUE_IN,TOTAL_TP_REVENUE_OUT,TOTAL_REVENUE_ADJ
4623: ,TOTAL_LENT_RESOURCE_COST,TOTAL_TP_COST_IN,TOTAL_TP_COST_OUT,TOTAL_COST_ADJ,TOTAL_UNASSIGNED_TIME_COST
4624: ,TOTAL_UTILIZATION_PERCENT,TOTAL_UTILIZATION_HOURS,TOTAL_UTILIZATION_ADJ,TOTAL_CAPACITY,TOTAL_HEAD_COUNT

Line 4653: ,NULL -- STANDARD_BILL_RATE

4649: ,fnd_global.user_id -- CREATED_BY
4650: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4651: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
4652: ,NULL -- TRACK_AS_LABOR_FLAG
4653: ,NULL -- STANDARD_BILL_RATE
4654: ,NULL -- AVERAGE_BILL_RATE
4655: ,NULL -- AVERAGE_COST_RATE
4656: ,nvl(l_project_assignment_id_tbl(j),-1) -- PROJECT_ASSIGNMENT_ID
4657: ,NULL -- PLAN_ERROR_CODE

Line 5161: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE

5157:
5158: FORALL j IN l_eligible_rlm_ids_tbl.FIRST .. l_eligible_rlm_ids_tbl.LAST SAVE EXCEPTIONS
5159: INSERT INTO PA_RESOURCE_ASSIGNMENTS (
5160: RESOURCE_ASSIGNMENT_ID,BUDGET_VERSION_ID,PROJECT_ID,TASK_ID,RESOURCE_LIST_MEMBER_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY
5161: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE
5162: ,PROJECT_ASSIGNMENT_ID,PLAN_ERROR_CODE,TOTAL_PLAN_REVENUE,TOTAL_PLAN_RAW_COST,TOTAL_PLAN_BURDENED_COST,TOTAL_PLAN_QUANTITY
5163: ,AVERAGE_DISCOUNT_PERCENTAGE,TOTAL_BORROWED_REVENUE,TOTAL_TP_REVENUE_IN,TOTAL_TP_REVENUE_OUT,TOTAL_REVENUE_ADJ
5164: ,TOTAL_LENT_RESOURCE_COST,TOTAL_TP_COST_IN,TOTAL_TP_COST_OUT,TOTAL_COST_ADJ,TOTAL_UNASSIGNED_TIME_COST
5165: ,TOTAL_UTILIZATION_PERCENT,TOTAL_UTILIZATION_HOURS,TOTAL_UTILIZATION_ADJ,TOTAL_CAPACITY,TOTAL_HEAD_COUNT

Line 5196: ,NULL -- STANDARD_BILL_RATE

5192: ,fnd_global.user_id -- CREATED_BY
5193: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
5194: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
5195: ,NULL -- TRACK_AS_LABOR_FLAG
5196: ,NULL -- STANDARD_BILL_RATE
5197: ,NULL -- AVERAGE_BILL_RATE
5198: ,NULL -- AVERAGE_COST_RATE
5199: ,-1 -- PROJECT_ASSIGNMENT_ID
5200: ,NULL -- PLAN_ERROR_CODE