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_PROJECTS_ALL

Line 367: FROM PA_PROJECTS_ALL

363:
364: -- Bug 7482391
365: cursor new_prj_end_date_csr(c_project_id IN NUMBER) IS
366: SELECT COMPLETION_DATE
367: FROM PA_PROJECTS_ALL
368: WHERE project_id=c_project_id;
369:
370: -- anlee
371: /*

Line 417: FROM pa_projects_all

413: ----End selective copy project options. Tracking bug No 3464332
414: --Bug 3279981 FP_M Project Setup development
415: CURSOR cur_get_orig_bill_info IS
416: SELECT enable_top_task_inv_mth_flag, revenue_accrual_method, invoice_method
417: FROM pa_projects_all
418: WHERE project_id = x_orig_project_id;
419:
420: -- 4055319 Added below cursor to retrieve source's funding approval status code
421:

Line 427: pa_projects_all ppa,

423: select
424: ppa.funding_approval_status_code,
425: pps.project_system_status_code
426: from
427: pa_projects_all ppa,
428: pa_project_statuses pps
429: where
430: ppa.project_id = x_orig_project_id
431: and ppa.funding_approval_status_code = pps.project_status_code;

Line 1139: AND APPLICATION_TABLE_NAME='PA_PROJECTS_ALL'

1135: Cursor c3 is
1136: SELECT 'YES' FROM DUAL
1137: WHERE EXISTS ( SELECT 1 FROM FND_DESCRIPTIVE_FLEXS
1138: WHERE APPLICATION_ID=275
1139: AND APPLICATION_TABLE_NAME='PA_PROJECTS_ALL'
1140: AND DESCRIPTIVE_FLEXFIELD_NAME = 'PA_PROJECTS_DESC_FLEX'
1141: AND CONTEXT_COLUMN_NAME = 'ATTRIBUTE_CATEGORY'
1142: AND DEFAULT_CONTEXT_FIELD_NAME = 'TEMPLATE_FLAG' );
1143:

Line 1747: FROM PA_PROJECTS_ALL

1743: l_return_status VARCHAR2(1);
1744: CURSOR get_proj_attr
1745: IS
1746: SELECT name, long_name, segment1, description, template_flag
1747: FROM PA_PROJECTS_ALL
1748: WHERE project_id = x_new_project_id;
1749:
1750: l_name VARCHAR2(30);
1751: l_long_name VARCHAR2(240);

Line 2820: FROM pa_projects_all

2816: DECLARE
2817:
2818: CURSOR cur_get_orig_tt_cust_flag IS
2819: SELECT enable_top_task_customer_flag
2820: FROM pa_projects_all
2821: WHERE project_id = x_orig_project_id;
2822:
2823: --sunkalya:federal Bug#5511353
2824:

Line 2830: pa_projects_all

2826: IS
2827: SELECT
2828: nvl(DATE_EFF_FUNDS_CONSUMPTION,'N')
2829: FROM
2830: pa_projects_all
2831: WHERE project_id = x_orig_project_id ;
2832: --sunkalya:federal Bug#5511353
2833:
2834: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 3197: CURSOR cur_cust_info(c_project_id pa_projects_all.project_id%TYPE,

3193: -- Fetch all the customers for the source project. Call get_customer_info to obtain the
3194: -- Valid customer details. Use this info thus obtained to insert a customer record.
3195: DECLARE
3196: -- Define the cursor to fetch the customer details from the source.
3197: CURSOR cur_cust_info(c_project_id pa_projects_all.project_id%TYPE,
3198: c_created_from_proj_id pa_projects_all.project_id%TYPE ) IS -- Added the parameter for bug 3726109
3199: SELECT
3200: cust.customer_id
3201: , cust.project_relationship_code

Line 3198: c_created_from_proj_id pa_projects_all.project_id%TYPE ) IS -- Added the parameter for bug 3726109

3194: -- Valid customer details. Use this info thus obtained to insert a customer record.
3195: DECLARE
3196: -- Define the cursor to fetch the customer details from the source.
3197: CURSOR cur_cust_info(c_project_id pa_projects_all.project_id%TYPE,
3198: c_created_from_proj_id pa_projects_all.project_id%TYPE ) IS -- Added the parameter for bug 3726109
3199: SELECT
3200: cust.customer_id
3201: , cust.project_relationship_code
3202: , cust.customer_bill_split

Line 3224: CURSOR cur_contact_info(c_project_id pa_projects_all.project_id%TYPE,

3220: from pa_project_copy_overrides
3221: where project_id = c_created_from_proj_id
3222: and field_name = 'CUSTOMER_NAME');
3223: --CURSORS BELOW ADDED BY ADITI for Bug 3110489 Code Change Begins
3224: CURSOR cur_contact_info(c_project_id pa_projects_all.project_id%TYPE,
3225: c_created_from_proj_id pa_projects_all.project_id%TYPE,
3226: c_customer_id pa_project_customers.customer_id%TYPE)
3227: IS
3228: select contact.customer_id,

Line 3225: c_created_from_proj_id pa_projects_all.project_id%TYPE,

3221: where project_id = c_created_from_proj_id
3222: and field_name = 'CUSTOMER_NAME');
3223: --CURSORS BELOW ADDED BY ADITI for Bug 3110489 Code Change Begins
3224: CURSOR cur_contact_info(c_project_id pa_projects_all.project_id%TYPE,
3225: c_created_from_proj_id pa_projects_all.project_id%TYPE,
3226: c_customer_id pa_project_customers.customer_id%TYPE)
3227: IS
3228: select contact.customer_id,
3229: contact.contact_id,

Line 3241: CURSOR cur_cust_override_exists (c_created_from_proj_id pa_projects_all.project_id%TYPE )

3237: where project_id = c_created_from_proj_id
3238: and field_name = 'CUSTOMER_NAME')
3239: and contact.customer_id = c_customer_id;
3240:
3241: CURSOR cur_cust_override_exists (c_created_from_proj_id pa_projects_all.project_id%TYPE )
3242: IS
3243: select 'Y'
3244: from pa_project_copy_overrides
3245: where project_id = c_created_from_proj_id

Line 6013: from pa_projects_all

6009:
6010: IS
6011: Cursor C1(param_1 Number) IS
6012: select project_id
6013: from pa_projects_all
6014: where segment1 = to_char(param_1);
6015: loop_cnt number := 0;
6016: x_id number;
6017: old_stack varchar2(630);