DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on STANDARD

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

3969: IF l_ins_task_elem_version_id_tbl.COUNT > 0 THEN
3970: FORALL i IN l_ins_task_elem_version_id_tbl.FIRST .. l_ins_task_elem_version_id_tbl.LAST
3971: INSERT INTO PA_RESOURCE_ASSIGNMENTS (
3972: RESOURCE_ASSIGNMENT_ID,BUDGET_VERSION_ID,PROJECT_ID,TASK_ID,RESOURCE_LIST_MEMBER_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY
3973: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE
3974: ,PROJECT_ASSIGNMENT_ID,PLAN_ERROR_CODE,TOTAL_PLAN_REVENUE,TOTAL_PLAN_RAW_COST,TOTAL_PLAN_BURDENED_COST,TOTAL_PLAN_QUANTITY
3975: ,AVERAGE_DISCOUNT_PERCENTAGE,TOTAL_BORROWED_REVENUE,TOTAL_TP_REVENUE_IN,TOTAL_TP_REVENUE_OUT,TOTAL_REVENUE_ADJ
3976: ,TOTAL_LENT_RESOURCE_COST,TOTAL_TP_COST_IN,TOTAL_TP_COST_OUT,TOTAL_COST_ADJ,TOTAL_UNASSIGNED_TIME_COST
3977: ,TOTAL_UTILIZATION_PERCENT,TOTAL_UTILIZATION_HOURS,TOTAL_UTILIZATION_ADJ,TOTAL_CAPACITY,TOTAL_HEAD_COUNT

Line 4005: ,NULL -- STANDARD_BILL_RATE

4001: ,fnd_global.user_id -- CREATED_BY
4002: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4003: ,l_unit_of_measure_tbl(l_ppl_index) -- UNIT_OF_MEASURE
4004: ,NULL -- TRACK_AS_LABOR_FLAG
4005: ,NULL -- STANDARD_BILL_RATE
4006: ,NULL -- AVERAGE_BILL_RATE
4007: ,NULL -- AVERAGE_COST_RATE
4008: ,-1 -- PROJECT_ASSIGNMENT_ID
4009: ,NULL -- PLAN_ERROR_CODE

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

4221: -------------------------------------------------------------------
4222: FORALL j IN l_eligible_rlm_ids_tbl.FIRST .. l_eligible_rlm_ids_tbl.LAST
4223: INSERT INTO PA_RESOURCE_ASSIGNMENTS (
4224: RESOURCE_ASSIGNMENT_ID,BUDGET_VERSION_ID,PROJECT_ID,TASK_ID,RESOURCE_LIST_MEMBER_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY
4225: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE
4226: ,PROJECT_ASSIGNMENT_ID,PLAN_ERROR_CODE,TOTAL_PLAN_REVENUE,TOTAL_PLAN_RAW_COST,TOTAL_PLAN_BURDENED_COST,TOTAL_PLAN_QUANTITY
4227: ,AVERAGE_DISCOUNT_PERCENTAGE,TOTAL_BORROWED_REVENUE,TOTAL_TP_REVENUE_IN,TOTAL_TP_REVENUE_OUT,TOTAL_REVENUE_ADJ
4228: ,TOTAL_LENT_RESOURCE_COST,TOTAL_TP_COST_IN,TOTAL_TP_COST_OUT,TOTAL_COST_ADJ,TOTAL_UNASSIGNED_TIME_COST
4229: ,TOTAL_UTILIZATION_PERCENT,TOTAL_UTILIZATION_HOURS,TOTAL_UTILIZATION_ADJ,TOTAL_CAPACITY,TOTAL_HEAD_COUNT

Line 4257: ,NULL -- STANDARD_BILL_RATE

4253: ,fnd_global.user_id -- CREATED_BY
4254: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4255: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
4256: ,NULL -- TRACK_AS_LABOR_FLAG
4257: ,NULL -- STANDARD_BILL_RATE
4258: ,NULL -- AVERAGE_BILL_RATE
4259: ,NULL -- AVERAGE_COST_RATE
4260: ,nvl(l_project_assignment_id_tbl(j),-1) -- PROJECT_ASSIGNMENT_ID
4261: ,NULL -- PLAN_ERROR_CODE

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

4571:
4572: FORALL j IN l_eligible_rlm_ids_tbl.FIRST .. l_eligible_rlm_ids_tbl.LAST SAVE EXCEPTIONS
4573: INSERT INTO PA_RESOURCE_ASSIGNMENTS (
4574: RESOURCE_ASSIGNMENT_ID,BUDGET_VERSION_ID,PROJECT_ID,TASK_ID,RESOURCE_LIST_MEMBER_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY
4575: ,LAST_UPDATE_LOGIN,UNIT_OF_MEASURE,TRACK_AS_LABOR_FLAG,STANDARD_BILL_RATE,AVERAGE_BILL_RATE,AVERAGE_COST_RATE
4576: ,PROJECT_ASSIGNMENT_ID,PLAN_ERROR_CODE,TOTAL_PLAN_REVENUE,TOTAL_PLAN_RAW_COST,TOTAL_PLAN_BURDENED_COST,TOTAL_PLAN_QUANTITY
4577: ,AVERAGE_DISCOUNT_PERCENTAGE,TOTAL_BORROWED_REVENUE,TOTAL_TP_REVENUE_IN,TOTAL_TP_REVENUE_OUT,TOTAL_REVENUE_ADJ
4578: ,TOTAL_LENT_RESOURCE_COST,TOTAL_TP_COST_IN,TOTAL_TP_COST_OUT,TOTAL_COST_ADJ,TOTAL_UNASSIGNED_TIME_COST
4579: ,TOTAL_UTILIZATION_PERCENT,TOTAL_UTILIZATION_HOURS,TOTAL_UTILIZATION_ADJ,TOTAL_CAPACITY,TOTAL_HEAD_COUNT

Line 4608: ,NULL -- STANDARD_BILL_RATE

4604: ,fnd_global.user_id -- CREATED_BY
4605: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
4606: ,l_unit_of_measure_tbl(j) -- UNIT_OF_MEASURE
4607: ,NULL -- TRACK_AS_LABOR_FLAG
4608: ,NULL -- STANDARD_BILL_RATE
4609: ,NULL -- AVERAGE_BILL_RATE
4610: ,NULL -- AVERAGE_COST_RATE
4611: ,-1 -- PROJECT_ASSIGNMENT_ID
4612: ,NULL -- PLAN_ERROR_CODE