APPS.PA_PROJECT_CORE1 dependencies on PA_TASKS

Line 674: from pa_tasks

670:
671: -- use min(start_date) as pseudo original project start
672: cursor c2 is
673: select min(start_date) min_start
674: from pa_tasks
675: where project_id = x_orig_project_id;
676:
677: c2_rec c2%rowtype;
678:

Line 5066: Update pa_tasks

5062: where project_id = x_new_project_id;
5063:
5064: IF nvl(l_enable_top_task_cust_flag,'N') ='Y' Then
5065: If x_customer_id is not null then
5066: Update pa_tasks
5067: set customer_id =x_customer_id
5068: where project_id=x_new_project_id;
5069: Else
5070: Update pa_tasks t

Line 5070: Update pa_tasks t

5066: Update pa_tasks
5067: set customer_id =x_customer_id
5068: where project_id=x_new_project_id;
5069: Else
5070: Update pa_tasks t
5071: Set t.customer_id = (select old.customer_id from pa_tasks old
5072: where old.project_id = x_orig_project_id
5073: and old.task_number = t.task_number
5074: and old.customer_id is not null)

Line 5071: Set t.customer_id = (select old.customer_id from pa_tasks old

5067: set customer_id =x_customer_id
5068: where project_id=x_new_project_id;
5069: Else
5070: Update pa_tasks t
5071: Set t.customer_id = (select old.customer_id from pa_tasks old
5072: where old.project_id = x_orig_project_id
5073: and old.task_number = t.task_number
5074: and old.customer_id is not null)
5075: where t.project_id = x_new_project_id;

Line 5080: Update pa_tasks t

5076: End if;
5077: END IF;
5078:
5079: If x_distribution_rule is not null then
5080: Update pa_tasks t
5081: set t.revenue_accrual_method =substr(x_distribution_rule, 1, instr(x_distribution_rule,'/')-1),
5082: t.invoice_method = substr(x_distribution_rule, instr(x_distribution_rule,'/')+1)
5083: where t.project_id=x_new_project_id;
5084: Else

Line 5085: Update pa_tasks t

5081: set t.revenue_accrual_method =substr(x_distribution_rule, 1, instr(x_distribution_rule,'/')-1),
5082: t.invoice_method = substr(x_distribution_rule, instr(x_distribution_rule,'/')+1)
5083: where t.project_id=x_new_project_id;
5084: Else
5085: Update pa_tasks t
5086: set t.revenue_accrual_method =(select old.revenue_accrual_method
5087: from pa_tasks old
5088: where old.project_id = x_orig_project_id
5089: and old.task_number = t.task_number

Line 5087: from pa_tasks old

5083: where t.project_id=x_new_project_id;
5084: Else
5085: Update pa_tasks t
5086: set t.revenue_accrual_method =(select old.revenue_accrual_method
5087: from pa_tasks old
5088: where old.project_id = x_orig_project_id
5089: and old.task_number = t.task_number
5090: and old.revenue_accrual_method is not null),
5091: t.invoice_method = (select old.invoice_method

Line 5092: from pa_tasks old

5088: where old.project_id = x_orig_project_id
5089: and old.task_number = t.task_number
5090: and old.revenue_accrual_method is not null),
5091: t.invoice_method = (select old.invoice_method
5092: from pa_tasks old
5093: where old.project_id = x_orig_project_id
5094: and old.task_number = t.task_number
5095: and old.invoice_method is not null)
5096: where t.project_id = x_new_project_id;

Line 5691: and new.object_type = 'PA_TASKS'

5687: from pa_proj_elements orig, pa_proj_elements new
5688: where orig.project_id = x_orig_project_id
5689: and new.element_number = orig.element_number
5690: and new.project_id = x_new_project_id
5691: and new.object_type = 'PA_TASKS'
5692: and orig.object_type = 'PA_TASKS';
5693:
5694: c_atch c_attach_tasks%rowtype ;
5695:

Line 5692: and orig.object_type = 'PA_TASKS';

5688: where orig.project_id = x_orig_project_id
5689: and new.element_number = orig.element_number
5690: and new.project_id = x_new_project_id
5691: and new.object_type = 'PA_TASKS'
5692: and orig.object_type = 'PA_TASKS';
5693:
5694: c_atch c_attach_tasks%rowtype ;
5695:
5696: begin

Line 5704: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',

5700: into c_atch ;
5701: if c_attach_tasks%notfound then
5702: exit ;
5703: end if;
5704: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',
5705: c_atch.orig_task_id,
5706: null, null, null, null,
5707: 'PA_TASKS',
5708: c_atch.new_task_id,

Line 5707: 'PA_TASKS',

5703: end if;
5704: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',
5705: c_atch.orig_task_id,
5706: null, null, null, null,
5707: 'PA_TASKS',
5708: c_atch.new_task_id,
5709: null, null, null, null,
5710: FND_GLOBAL.USER_ID,
5711: FND_GLOBAL.LOGIN_ID,