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_PROJECT_CORE1 dependencies on PA_TASKS

Line 686: from pa_tasks

682:
683: -- use min(start_date) as pseudo original project start
684: cursor c2 is
685: select min(start_date) min_start
686: from pa_tasks
687: where project_id = x_orig_project_id;
688:
689: c2_rec c2%rowtype;
690:

Line 5114: Update pa_tasks

5110: where project_id = x_new_project_id;
5111:
5112: IF nvl(l_enable_top_task_cust_flag,'N') ='Y' Then
5113: If x_customer_id is not null then
5114: Update pa_tasks
5115: set customer_id =x_customer_id
5116: where project_id=x_new_project_id;
5117: -- bug 16237696 : added else condition to update target project tasks
5118: -- with customer_id from source project tasks if customer is not selected from the quick entry.

Line 5127: Update pa_tasks t

5123: close csr_cust_override;
5124: end if;
5125:
5126: if l_customer_overrided IS NULL OR l_customer_overrided <> 1 then
5127: Update pa_tasks t
5128: Set t.customer_id = (select old.customer_id from pa_tasks old
5129: where old.project_id = x_orig_project_id
5130: and old.task_number = t.task_number
5131: and old.customer_id is not null)

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

5124: end if;
5125:
5126: if l_customer_overrided IS NULL OR l_customer_overrided <> 1 then
5127: Update pa_tasks t
5128: Set t.customer_id = (select old.customer_id from pa_tasks old
5129: where old.project_id = x_orig_project_id
5130: and old.task_number = t.task_number
5131: and old.customer_id is not null)
5132: where t.project_id = x_new_project_id;

Line 5138: Update pa_tasks t

5134: -- Fix for bug#9548903 When Customer at top task is checked and customer id is supplied during project creation
5135: -- We update all the Tasks with the new customer id. If Customer at top task is checked and customer id is not
5136: -- specified, we should not update all the tasks with the original customer.
5137: /*Else
5138: Update pa_tasks t
5139: Set t.customer_id = (select old.customer_id from pa_tasks old
5140: where old.project_id = x_orig_project_id
5141: and old.task_number = t.task_number
5142: and old.customer_id is not null)

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

5135: -- We update all the Tasks with the new customer id. If Customer at top task is checked and customer id is not
5136: -- specified, we should not update all the tasks with the original customer.
5137: /*Else
5138: Update pa_tasks t
5139: Set t.customer_id = (select old.customer_id from pa_tasks old
5140: where old.project_id = x_orig_project_id
5141: and old.task_number = t.task_number
5142: and old.customer_id is not null)
5143: where t.project_id = x_new_project_id;*/

Line 5148: Update pa_tasks t

5144: End if;
5145: END IF;
5146:
5147: If x_distribution_rule is not null then
5148: Update pa_tasks t
5149: set t.revenue_accrual_method =substr(x_distribution_rule, 1, instr(x_distribution_rule,'/')-1),
5150: t.invoice_method = substr(x_distribution_rule, instr(x_distribution_rule,'/')+1)
5151: where t.project_id=x_new_project_id;
5152: Else

Line 5153: Update pa_tasks t

5149: set t.revenue_accrual_method =substr(x_distribution_rule, 1, instr(x_distribution_rule,'/')-1),
5150: t.invoice_method = substr(x_distribution_rule, instr(x_distribution_rule,'/')+1)
5151: where t.project_id=x_new_project_id;
5152: Else
5153: Update pa_tasks t
5154: set t.revenue_accrual_method =(select old.revenue_accrual_method
5155: from pa_tasks old
5156: where old.project_id = x_orig_project_id
5157: and old.task_number = t.task_number

Line 5155: from pa_tasks old

5151: where t.project_id=x_new_project_id;
5152: Else
5153: Update pa_tasks t
5154: set t.revenue_accrual_method =(select old.revenue_accrual_method
5155: from pa_tasks old
5156: where old.project_id = x_orig_project_id
5157: and old.task_number = t.task_number
5158: and old.revenue_accrual_method is not null),
5159: t.invoice_method = (select old.invoice_method

Line 5160: from pa_tasks old

5156: where old.project_id = x_orig_project_id
5157: and old.task_number = t.task_number
5158: and old.revenue_accrual_method is not null),
5159: t.invoice_method = (select old.invoice_method
5160: from pa_tasks old
5161: where old.project_id = x_orig_project_id
5162: and old.task_number = t.task_number
5163: and old.invoice_method is not null)
5164: where t.project_id = x_new_project_id;

Line 5759: and new.object_type = 'PA_TASKS'

5755: from pa_proj_elements orig, pa_proj_elements new
5756: where orig.project_id = x_orig_project_id
5757: and new.element_number = orig.element_number
5758: and new.project_id = x_new_project_id
5759: and new.object_type = 'PA_TASKS'
5760: and orig.object_type = 'PA_TASKS';
5761:
5762: c_atch c_attach_tasks%rowtype ;
5763:

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

5756: where orig.project_id = x_orig_project_id
5757: and new.element_number = orig.element_number
5758: and new.project_id = x_new_project_id
5759: and new.object_type = 'PA_TASKS'
5760: and orig.object_type = 'PA_TASKS';
5761:
5762: c_atch c_attach_tasks%rowtype ;
5763:
5764: begin

Line 5772: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',

5768: into c_atch ;
5769: if c_attach_tasks%notfound then
5770: exit ;
5771: end if;
5772: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',
5773: c_atch.orig_task_id,
5774: null, null, null, null,
5775: 'PA_TASKS',
5776: c_atch.new_task_id,

Line 5775: 'PA_TASKS',

5771: end if;
5772: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',
5773: c_atch.orig_task_id,
5774: null, null, null, null,
5775: 'PA_TASKS',
5776: c_atch.new_task_id,
5777: null, null, null, null,
5778: FND_GLOBAL.USER_ID,
5779: FND_GLOBAL.LOGIN_ID,