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 3973: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr

3969:
3970: DELETE FROM pa_proj_elem_ver_schedule where project_id = p_project_id;
3971: DELETE FROM pa_proj_elem_ver_structure where project_id = p_project_id;
3972:
3973: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr
3974: and pa_proj_workplan_attr. */
3975:
3976: BEGIN
3977:

Line 8607: INSERT INTO pa_proj_progress_attr(

8603: AND ppe.project_id = p_dest_project_id --bug 3939786
8604: ;
8605:
8606: --Copy progress attributes for financial and workplan structures
8607: INSERT INTO pa_proj_progress_attr(
8608: PROJ_PROGRESS_ATTR_ID
8609: ,OBJECT_TYPE
8610: ,OBJECT_ID
8611: ,LAST_UPDATE_DATE

Line 8629: PA_PROJ_PROGRESS_ATTR_S.nextval

8625: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES
8626: ,STRUCTURE_TYPE
8627: )
8628: SELECT
8629: PA_PROJ_PROGRESS_ATTR_S.nextval
8630: ,ppe.OBJECT_TYPE
8631: ,ppe.proj_element_ID
8632: ,sysdate
8633: ,l_user_id

Line 8648: FROM pa_proj_progress_attr pppa,

8644: ,pppa.TASK_WEIGHT_BASIS_CODE
8645: ,pppa.ALLOW_COLLAB_PROG_ENTRY
8646: ,pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES
8647: ,pppa.STRUCTURE_TYPE
8648: FROM pa_proj_progress_attr pppa,
8649: pa_proj_elements ppe
8650: WHERE ppe.project_id = p_dest_project_id
8651: AND PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.proj_element_id ) = 'Y'
8652: AND ppe.attribute15 = pppa.object_id

Line 11910: INSERT INTO pa_proj_progress_attr(

11906: AND ppe.project_id = p_dest_project_id
11907: AND ppe.object_type='PA_STRUCTURES';
11908:
11909: --Copy progress attributes for financial only structures
11910: INSERT INTO pa_proj_progress_attr(
11911: PROJ_PROGRESS_ATTR_ID
11912: ,OBJECT_TYPE
11913: ,OBJECT_ID
11914: ,LAST_UPDATE_DATE

Line 11932: PA_PROJ_PROGRESS_ATTR_S.nextval

11928: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES
11929: ,STRUCTURE_TYPE
11930: )
11931: SELECT
11932: PA_PROJ_PROGRESS_ATTR_S.nextval
11933: ,ppe.OBJECT_TYPE
11934: ,ppe.proj_element_ID
11935: ,sysdate
11936: ,l_user_id

Line 11951: FROM pa_proj_progress_attr pppa,

11947: ,pppa.TASK_WEIGHT_BASIS_CODE
11948: ,pppa.ALLOW_COLLAB_PROG_ENTRY
11949: ,pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES
11950: ,pppa.STRUCTURE_TYPE
11951: FROM pa_proj_progress_attr pppa,
11952: pa_proj_elements ppe
11953: WHERE ppe.project_id = p_dest_project_id
11954: AND ppe.attribute15 = pppa.object_id
11955: AND pppa.project_id = p_src_project_id

Line 12412: INSERT INTO pa_proj_progress_attr(

12408: AND PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.proj_element_id ) = 'Y'; /* bug 3621613 */
12409:
12410: --bug 3010538
12411: --added task weighting basis code
12412: INSERT INTO pa_proj_progress_attr(
12413: PROJ_PROGRESS_ATTR_ID
12414: ,OBJECT_TYPE
12415: ,OBJECT_ID
12416: ,LAST_UPDATE_DATE

Line 12435: PA_PROJ_PROGRESS_ATTR_S.nextval

12431: ,ALLOW_PHY_PRCNT_CMP_OVERRIDES
12432: ,STRUCTURE_TYPE
12433: /* FP-M Bug # 3420093. Modified: copy_structures_bulk. */
12434: ) SELECT
12435: PA_PROJ_PROGRESS_ATTR_S.nextval
12436: ,ppe.OBJECT_TYPE
12437: ,ppe.proj_element_ID
12438: ,sysdate
12439: ,l_user_id

Line 12456: /*FROM pa_proj_progress_attr pppa,

12452: ,pppa.ALLOW_COLLAB_PROG_ENTRY
12453: ,pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES
12454: ,pppa.STRUCTURE_TYPE
12455: /* FP-M Bug # 3420093. Modified: copy_structures_bulk. */
12456: /*FROM pa_proj_progress_attr pppa,
12457: pa_proj_elements ppe
12458: WHERE ppe.project_id = p_dest_project_id
12459: and ppe.attribute15 = pppa.object_id --no need to join with
12460: and pppa.object_type = 'PA_STRUCTURES'

Line 12463: FROM pa_proj_progress_attr pppa,

12459: and ppe.attribute15 = pppa.object_id --no need to join with
12460: and pppa.object_type = 'PA_STRUCTURES'
12461: and ppe.object_type = 'PA_STRUCTURES'
12462: and pppa.project_id = p_src_project_id;*//*Commented below query and following criteria by SMUKKA */
12463: FROM pa_proj_progress_attr pppa,
12464: pa_proj_elements ppe
12465: WHERE ppe.project_id = p_dest_project_id
12466: and ppe.attribute15 = pppa.object_id
12467: and pppa.object_type = 'PA_STRUCTURES'

Line 13278: l_task_weight_basis PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;

13274: l_fn_str_id NUMBER;
13275: l_wp_str_id NUMBER;
13276: l_fn_str_ver_id NUMBER;
13277: l_wp_str_ver_id NUMBER;
13278: l_task_weight_basis PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;
13279: BEGIN
13280: l_task_weight_basis := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS( p_dest_project_id );
13281: IF NVL( l_task_weight_basis, 'X' ) = 'DURATION'
13282: THEN

Line 18514: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;

18510: l_update_wbs_flag pa_proj_elem_ver_structure.process_update_wbs_flag%TYPE;
18511: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
18512: l_structure_type_flag VARCHAR2(1);
18513: --Bug 3053920.
18514: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
18515:
18516: l_msg_count NUMBER := 0;
18517: l_data VARCHAR2(2000);
18518: l_msg_data VARCHAR2(2000);

Line 19350: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;

19346: l_proj_start_date DATE;
19347: l_proj_completion_date DATE;
19348: l_proj_element_id NUMBER; --structure id
19349: l_as_of_date DATE;
19350: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
19351: l_share_flag VARCHAR2(1) := 'N';
19352: l_copy_actuals_flag VARCHAR2(1) := 'Y';
19353: l_upd_new_elem_ver_id_flag VARCHAR2(1) := 'Y'; --rtarway, 3951024
19354: l_i_msg_count NUMBER := 0;

Line 21255: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;

21251: l_parent_task_ver_id_tbl parent_task_ver_id_tbl;
21252: l_duration_tbl duration_tbl;
21253: l_effort_tbl effort_tbl;
21254:
21255: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
21256:
21257: L_BASIS_MANUAL CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'MANUAL';
21258: L_BASIS_EFFORT CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'EFFORT';
21259: L_BASIS_DURATION CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'DURATION';

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

21253: l_effort_tbl effort_tbl;
21254:
21255: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
21256:
21257: L_BASIS_MANUAL CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'MANUAL';
21258: L_BASIS_EFFORT CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'EFFORT';
21259: L_BASIS_DURATION CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'DURATION';
21260:
21261: -- End Procedure level local variables declaration

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

21254:
21255: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
21256:
21257: L_BASIS_MANUAL CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'MANUAL';
21258: L_BASIS_EFFORT CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'EFFORT';
21259: L_BASIS_DURATION CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'DURATION';
21260:
21261: -- End Procedure level local variables declaration
21262:

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

21255: l_task_weighting_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
21256:
21257: L_BASIS_MANUAL CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'MANUAL';
21258: L_BASIS_EFFORT CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'EFFORT';
21259: L_BASIS_DURATION CONSTANT pa_proj_progress_attr.task_weight_basis_code%TYPE := 'DURATION';
21260:
21261: -- End Procedure level local variables declaration
21262:
21263: -- Standard local variable declaration.

Line 21937: l_task_weight_basis PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;

21933: l_fn_str_id NUMBER;
21934: l_wp_str_id NUMBER;
21935: l_fn_str_ver_id NUMBER;
21936: l_wp_str_ver_id NUMBER;
21937: l_task_weight_basis PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;
21938: l_shared VARCHAR2(1);
21939:
21940: l_msg_count NUMBER := 0;
21941: l_data VARCHAR2(2000);