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_PROJ_TASK_STRUC_PUB dependencies on PA_PROJ_PROGRESS_ATTR

Line 3752: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr

3748:
3749: DELETE FROM pa_proj_elem_ver_schedule where project_id = p_project_id;
3750: DELETE FROM pa_proj_elem_ver_structure where project_id = p_project_id;
3751:
3752: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr
3753: and pa_proj_workplan_attr. */
3754:
3755: BEGIN
3756:

Line 8340: INSERT INTO pa_proj_progress_attr(

8336: AND ppe.project_id = p_dest_project_id --bug 3939786
8337: ;
8338:
8339: --Copy progress attributes for financial and workplan structures
8340: INSERT INTO pa_proj_progress_attr(
8341: PROJ_PROGRESS_ATTR_ID
8342: ,OBJECT_TYPE
8343: ,OBJECT_ID
8344: ,LAST_UPDATE_DATE

Line 8362: PA_PROJ_PROGRESS_ATTR_S.nextval

8358: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES
8359: ,STRUCTURE_TYPE
8360: )
8361: SELECT
8362: PA_PROJ_PROGRESS_ATTR_S.nextval
8363: ,ppe.OBJECT_TYPE
8364: ,ppe.proj_element_ID
8365: ,sysdate
8366: ,l_user_id

Line 8381: FROM pa_proj_progress_attr pppa,

8377: ,pppa.TASK_WEIGHT_BASIS_CODE
8378: ,pppa.ALLOW_COLLAB_PROG_ENTRY
8379: ,pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES
8380: ,pppa.STRUCTURE_TYPE
8381: FROM pa_proj_progress_attr pppa,
8382: pa_proj_elements ppe
8383: WHERE ppe.project_id = p_dest_project_id
8384: AND PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.proj_element_id ) = 'Y'
8385: AND ppe.attribute15 = pppa.object_id

Line 11589: INSERT INTO pa_proj_progress_attr(

11585: AND ppe.project_id = p_dest_project_id
11586: AND ppe.object_type='PA_STRUCTURES';
11587:
11588: --Copy progress attributes for financial only structures
11589: INSERT INTO pa_proj_progress_attr(
11590: PROJ_PROGRESS_ATTR_ID
11591: ,OBJECT_TYPE
11592: ,OBJECT_ID
11593: ,LAST_UPDATE_DATE

Line 11611: PA_PROJ_PROGRESS_ATTR_S.nextval

11607: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES
11608: ,STRUCTURE_TYPE
11609: )
11610: SELECT
11611: PA_PROJ_PROGRESS_ATTR_S.nextval
11612: ,ppe.OBJECT_TYPE
11613: ,ppe.proj_element_ID
11614: ,sysdate
11615: ,l_user_id

Line 11630: FROM pa_proj_progress_attr pppa,

11626: ,pppa.TASK_WEIGHT_BASIS_CODE
11627: ,pppa.ALLOW_COLLAB_PROG_ENTRY
11628: ,pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES
11629: ,pppa.STRUCTURE_TYPE
11630: FROM pa_proj_progress_attr pppa,
11631: pa_proj_elements ppe
11632: WHERE ppe.project_id = p_dest_project_id
11633: AND ppe.attribute15 = pppa.object_id
11634: AND pppa.project_id = p_src_project_id

Line 12085: INSERT INTO pa_proj_progress_attr(

12081: AND PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.proj_element_id ) = 'Y'; /* bug 3621613 */
12082:
12083: --bug 3010538
12084: --added task weighting basis code
12085: INSERT INTO pa_proj_progress_attr(
12086: PROJ_PROGRESS_ATTR_ID
12087: ,OBJECT_TYPE
12088: ,OBJECT_ID
12089: ,LAST_UPDATE_DATE

Line 12108: PA_PROJ_PROGRESS_ATTR_S.nextval

12104: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES
12105: ,STRUCTURE_TYPE
12106: /* FP-M Bug # 3420093. Modified: copy_structures_bulk. */
12107: ) SELECT
12108: PA_PROJ_PROGRESS_ATTR_S.nextval
12109: ,ppe.OBJECT_TYPE
12110: ,ppe.proj_element_ID
12111: ,sysdate
12112: ,l_user_id

Line 12129: /*FROM pa_proj_progress_attr pppa,

12125: ,pppa.ALLOW_COLLAB_PROG_ENTRY
12126: ,pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES
12127: ,pppa.STRUCTURE_TYPE
12128: /* FP-M Bug # 3420093. Modified: copy_structures_bulk. */
12129: /*FROM pa_proj_progress_attr pppa,
12130: pa_proj_elements ppe
12131: WHERE ppe.project_id = p_dest_project_id
12132: and ppe.attribute15 = pppa.object_id --no need to join with
12133: and pppa.object_type = 'PA_STRUCTURES'

Line 12136: FROM pa_proj_progress_attr pppa,

12132: and ppe.attribute15 = pppa.object_id --no need to join with
12133: and pppa.object_type = 'PA_STRUCTURES'
12134: and ppe.object_type = 'PA_STRUCTURES'
12135: and pppa.project_id = p_src_project_id;*//*Commented below query and following criteria by SMUKKA */
12136: FROM pa_proj_progress_attr pppa,
12137: pa_proj_elements ppe
12138: WHERE ppe.project_id = p_dest_project_id
12139: and ppe.attribute15 = pppa.object_id
12140: and pppa.object_type = 'PA_STRUCTURES'

Line 12949: l_task_weight_basis PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;

12945: l_fn_str_id NUMBER;
12946: l_wp_str_id NUMBER;
12947: l_fn_str_ver_id NUMBER;
12948: l_wp_str_ver_id NUMBER;
12949: l_task_weight_basis PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;
12950: BEGIN
12951: l_task_weight_basis := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS( p_dest_project_id );
12952: IF NVL( l_task_weight_basis, 'X' ) = 'DURATION'
12953: THEN

Line 17778: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;

17774: l_update_wbs_flag pa_proj_elem_ver_structure.process_update_wbs_flag%TYPE;
17775: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
17776: l_structure_type_flag VARCHAR2(1);
17777: --Bug 3053920.
17778: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
17779:
17780: l_msg_count NUMBER := 0;
17781: l_data VARCHAR2(2000);
17782: l_msg_data VARCHAR2(2000);

Line 18557: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;

18553: l_proj_start_date DATE;
18554: l_proj_completion_date DATE;
18555: l_proj_element_id NUMBER; --structure id
18556: l_as_of_date DATE;
18557: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
18558: l_share_flag VARCHAR2(1) := 'N';
18559: l_copy_actuals_flag VARCHAR2(1) := 'Y';
18560: l_upd_new_elem_ver_id_flag VARCHAR2(1) := 'Y'; --rtarway, 3951024
18561: l_i_msg_count NUMBER := 0;

Line 20460: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;

20456: l_parent_task_ver_id_tbl parent_task_ver_id_tbl;
20457: l_duration_tbl duration_tbl;
20458: l_effort_tbl effort_tbl;
20459:
20460: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
20461:
20462: L_BASIS_MANUAL CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'MANUAL';
20463: L_BASIS_EFFORT CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'EFFORT';
20464: L_BASIS_DURATION CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'DURATION';

Line 20462: L_BASIS_MANUAL CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'MANUAL';

20458: l_effort_tbl effort_tbl;
20459:
20460: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
20461:
20462: L_BASIS_MANUAL CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'MANUAL';
20463: L_BASIS_EFFORT CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'EFFORT';
20464: L_BASIS_DURATION CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'DURATION';
20465:
20466: -- End Procedure level local variables declaration

Line 20463: L_BASIS_EFFORT CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'EFFORT';

20459:
20460: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
20461:
20462: L_BASIS_MANUAL CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'MANUAL';
20463: L_BASIS_EFFORT CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'EFFORT';
20464: L_BASIS_DURATION CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'DURATION';
20465:
20466: -- End Procedure level local variables declaration
20467:

Line 20464: L_BASIS_DURATION CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'DURATION';

20460: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
20461:
20462: L_BASIS_MANUAL CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'MANUAL';
20463: L_BASIS_EFFORT CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'EFFORT';
20464: L_BASIS_DURATION CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'DURATION';
20465:
20466: -- End Procedure level local variables declaration
20467:
20468: -- Standard local variable declaration.

Line 21141: l_task_weight_basis PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;

21137: l_fn_str_id NUMBER;
21138: l_wp_str_id NUMBER;
21139: l_fn_str_ver_id NUMBER;
21140: l_wp_str_ver_id NUMBER;
21141: l_task_weight_basis PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;
21142: l_shared VARCHAR2(1);
21143:
21144: l_msg_count NUMBER := 0;
21145: l_data VARCHAR2(2000);