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 363: FROM PA_PROJECTS_ALL

359:
360: -- Bug 7482391
361: cursor new_prj_end_date_csr(c_project_id IN NUMBER) IS
362: SELECT COMPLETION_DATE
363: FROM PA_PROJECTS_ALL
364: WHERE project_id=c_project_id;
365:
366: -- anlee
367: /*

Line 413: FROM pa_projects_all

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

Line 423: pa_projects_all ppa,

419: select
420: ppa.funding_approval_status_code,
421: pps.project_system_status_code
422: from
423: pa_projects_all ppa,
424: pa_project_statuses pps
425: where
426: ppa.project_id = x_orig_project_id
427: and ppa.funding_approval_status_code = pps.project_status_code;

Line 1127: AND APPLICATION_TABLE_NAME='PA_PROJECTS_ALL'

1123: Cursor c3 is
1124: SELECT 'YES' FROM DUAL
1125: WHERE EXISTS ( SELECT 1 FROM FND_DESCRIPTIVE_FLEXS
1126: WHERE APPLICATION_ID=275
1127: AND APPLICATION_TABLE_NAME='PA_PROJECTS_ALL'
1128: AND DESCRIPTIVE_FLEXFIELD_NAME = 'PA_PROJECTS_DESC_FLEX'
1129: AND CONTEXT_COLUMN_NAME = 'ATTRIBUTE_CATEGORY'
1130: AND DEFAULT_CONTEXT_FIELD_NAME = 'TEMPLATE_FLAG' );
1131:

Line 1711: FROM PA_PROJECTS_ALL

1707: l_return_status VARCHAR2(1);
1708: CURSOR get_proj_attr
1709: IS
1710: SELECT name, long_name, segment1, description, template_flag
1711: FROM PA_PROJECTS_ALL
1712: WHERE project_id = x_new_project_id;
1713:
1714: l_name VARCHAR2(30);
1715: l_long_name VARCHAR2(240);

Line 2777: FROM pa_projects_all

2773: DECLARE
2774:
2775: CURSOR cur_get_orig_tt_cust_flag IS
2776: SELECT enable_top_task_customer_flag
2777: FROM pa_projects_all
2778: WHERE project_id = x_orig_project_id;
2779:
2780: --sunkalya:federal Bug#5511353
2781:

Line 2787: pa_projects_all

2783: IS
2784: SELECT
2785: nvl(DATE_EFF_FUNDS_CONSUMPTION,'N')
2786: FROM
2787: pa_projects_all
2788: WHERE project_id = x_orig_project_id ;
2789: --sunkalya:federal Bug#5511353
2790:
2791: l_exclude_cust_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

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

3150: -- Fetch all the customers for the source project. Call get_customer_info to obtain the
3151: -- Valid customer details. Use this info thus obtained to insert a customer record.
3152: DECLARE
3153: -- Define the cursor to fetch the customer details from the source.
3154: CURSOR cur_cust_info(c_project_id pa_projects_all.project_id%TYPE,
3155: c_created_from_proj_id pa_projects_all.project_id%TYPE ) IS -- Added the parameter for bug 3726109
3156: SELECT
3157: cust.customer_id
3158: , cust.project_relationship_code

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

3151: -- Valid customer details. Use this info thus obtained to insert a customer record.
3152: DECLARE
3153: -- Define the cursor to fetch the customer details from the source.
3154: CURSOR cur_cust_info(c_project_id pa_projects_all.project_id%TYPE,
3155: c_created_from_proj_id pa_projects_all.project_id%TYPE ) IS -- Added the parameter for bug 3726109
3156: SELECT
3157: cust.customer_id
3158: , cust.project_relationship_code
3159: , cust.customer_bill_split

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

3177: from pa_project_copy_overrides
3178: where project_id = c_created_from_proj_id
3179: and field_name = 'CUSTOMER_NAME');
3180: --CURSORS BELOW ADDED BY ADITI for Bug 3110489 Code Change Begins
3181: CURSOR cur_contact_info(c_project_id pa_projects_all.project_id%TYPE,
3182: c_created_from_proj_id pa_projects_all.project_id%TYPE,
3183: c_customer_id pa_project_customers.customer_id%TYPE)
3184: IS
3185: select contact.customer_id,

Line 3182: c_created_from_proj_id pa_projects_all.project_id%TYPE,

3178: where project_id = c_created_from_proj_id
3179: and field_name = 'CUSTOMER_NAME');
3180: --CURSORS BELOW ADDED BY ADITI for Bug 3110489 Code Change Begins
3181: CURSOR cur_contact_info(c_project_id pa_projects_all.project_id%TYPE,
3182: c_created_from_proj_id pa_projects_all.project_id%TYPE,
3183: c_customer_id pa_project_customers.customer_id%TYPE)
3184: IS
3185: select contact.customer_id,
3186: contact.contact_id,

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

3194: where project_id = c_created_from_proj_id
3195: and field_name = 'CUSTOMER_NAME')
3196: and contact.customer_id = c_customer_id;
3197:
3198: CURSOR cur_cust_override_exists (c_created_from_proj_id pa_projects_all.project_id%TYPE )
3199: IS
3200: select 'Y'
3201: from pa_project_copy_overrides
3202: where project_id = c_created_from_proj_id

Line 5945: from pa_projects_all

5941:
5942: IS
5943: Cursor C1(param_1 Number) IS
5944: select project_id
5945: from pa_projects_all
5946: where segment1 = to_char(param_1);
5947: loop_cnt number := 0;
5948: x_id number;
5949: old_stack varchar2(630);