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

Line 4363: PA_PROJ_PROGRESS_ATTR_PKG.INSERT_ROW(

4359: l_task_weight_basis_code := p_TASK_WEIGHT_BASIS_CODE;
4360: END IF;
4361: --end bug 3010538
4362:
4363: PA_PROJ_PROGRESS_ATTR_PKG.INSERT_ROW(
4364: X_PROJ_PROGRESS_ATTR_ID => X_PROJ_PROGRESS_ATTR_ID
4365: ,x_project_id => p_project_id
4366: ,X_OBJECT_TYPE => P_OBJECT_TYPE
4367: ,X_OBJECT_ID => P_OBJECT_ID

Line 4476: from pa_proj_progress_attr

4472: l_TASK_WEIGHT_BASIS_CODE VARCHAR2(30);
4473:
4474: CURSOR cur_task_weight_bas_code IS
4475: select task_weight_basis_code
4476: from pa_proj_progress_attr
4477: where proj_progress_attr_id = p_proj_progress_attr_id;
4478: l_old_tk_wght_basis_code VARCHAR2(30);
4479: l_updt_struc_ver_id NUMBER;
4480:

Line 4515: FROM PA_PROJ_PROGRESS_ATTR

4511: CURSOR cur_prg_attr
4512: IS
4513: SELECT WQ_ENABLE_FLAG, REMAIN_EFFORT_ENABLE_FLAG,
4514: PERCENT_COMP_ENABLE_FLAG
4515: FROM PA_PROJ_PROGRESS_ATTR
4516: WHERE PROJ_PROGRESS_ATTR_ID = p_PROJ_PROGRESS_ATTR_ID;
4517:
4518: -- Bug # 4576303.
4519: cursor cur_tasks_exist (c_str_ver_id NUMBER) is

Line 4794: PA_PROJ_PROGRESS_ATTR_PKG.UPDATE_ROW(

4790: l_task_weight_basis_code := p_TASK_WEIGHT_BASIS_CODE;
4791: END IF;
4792: --end bug 3010538
4793:
4794: PA_PROJ_PROGRESS_ATTR_PKG.UPDATE_ROW(
4795: X_PROJ_PROGRESS_ATTR_ID => P_PROJ_PROGRESS_ATTR_ID
4796: ,X_project_id => p_project_id
4797: ,X_OBJECT_TYPE => p_OBJECT_TYPE
4798: ,X_OBJECT_ID => p_OBJECT_ID

Line 4882: FROM pa_proj_progress_attr

4878:
4879: CURSOR cur_ppp
4880: IS
4881: SELECT rowid
4882: FROM pa_proj_progress_attr
4883: WHERE project_id = p_project_id
4884: AND object_type = p_object_type
4885: AND object_id = p_object_id
4886: AND structure_type = p_structure_type; -- Amit

Line 4918: PA_PROJ_PROGRESS_ATTR_PKG.DELETE_ROW( l_ppp_row_id

4914: OPEN cur_ppp;
4915: FETCH cur_ppp INTO l_ppp_row_id;
4916: CLOSE cur_ppp;
4917:
4918: PA_PROJ_PROGRESS_ATTR_PKG.DELETE_ROW( l_ppp_row_id
4919: );
4920:
4921: x_return_status := FND_API.G_RET_STS_SUCCESS;
4922:

Line 6972: from pa_proj_progress_attr pppa

6968:
6969: cursor cur_proj_prog_attr
6970: is
6971: select pppa.task_weight_basis_code
6972: from pa_proj_progress_attr pppa
6973: where project_id=p_project_id
6974: and structure_type ='WORKPLAN'
6975: ;
6976:

Line 8482: delete from pa_proj_progress_attr

8478:
8479: delete from pa_progress_rollup
8480: where project_id = p_project_id;
8481:
8482: delete from pa_proj_progress_attr
8483: where project_id = p_project_id;
8484:
8485: delete from pa_proj_workplan_attr
8486: where project_id = p_project_id;

Line 8842: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

8838: l_msg_data VARCHAR2(250) ;
8839: l_object_type VARCHAR2(30) ;
8840: l_structure_version_id NUMBER ;
8841: l_task_version_id NUMBER ;
8842: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
8843: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
8844: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
8845: L_LOWEST_LEVEL_TASK VARCHAR2(1);
8846: l_last_progress_date DATE;

Line 8843: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

8839: l_object_type VARCHAR2(30) ;
8840: l_structure_version_id NUMBER ;
8841: l_task_version_id NUMBER ;
8842: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
8843: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
8844: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
8845: L_LOWEST_LEVEL_TASK VARCHAR2(1);
8846: l_last_progress_date DATE;
8847: l_plan_version_id NUMBER;

Line 8844: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

8840: l_structure_version_id NUMBER ;
8841: l_task_version_id NUMBER ;
8842: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
8843: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
8844: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
8845: L_LOWEST_LEVEL_TASK VARCHAR2(1);
8846: l_last_progress_date DATE;
8847: l_plan_version_id NUMBER;
8848:

Line 8864: FROM pa_proj_progress_attr

8860:
8861: CURSOR c_get_task_weight_method(c_project_id NUMBER, c_structure_type VARCHAR2)
8862: IS
8863: SELECT task_weight_basis_code
8864: FROM pa_proj_progress_attr
8865: WHERE project_id = c_project_id
8866: AND structure_type = c_structure_type;
8867:
8868: CURSOR c_get_latest_pub_task_ver(c_proj_element_id NUMBER, c_project_id NUMBER)

Line 9149: update pa_proj_progress_attr

9145: -- Begin code fix for bug # 3974859.
9146:
9147: If p_structure_type = 'WORKPLAN' then
9148:
9149: update pa_proj_progress_attr
9150: set next_progress_update_date = p_as_of_date
9151: where project_id = p_project_id
9152: and object_type = 'PA_STRUCTURES'
9153: and structure_type = 'WORKPLAN';

Line 10754: FROM pa_proj_progress_attr

10750:
10751: CURSOR c_get_task_weight_method(c_project_id NUMBER, c_structure_type VARCHAR2)
10752: IS
10753: SELECT task_weight_basis_code
10754: FROM pa_proj_progress_attr
10755: WHERE project_id = c_project_id
10756: AND structure_type = c_structure_type;
10757:
10758: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

Line 10758: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

10754: FROM pa_proj_progress_attr
10755: WHERE project_id = c_project_id
10756: AND structure_type = c_structure_type;
10757:
10758: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE ;
10759: l_baselined_str_ver_id NUMBER ;
10760: -- Bug 4136239 : Added l_call_rollup, l_call_update_progress
10761: l_call_rollup VARCHAR2(1):='N' ;
10762: l_call_update_progress VARCHAR2(1):='N' ;

Line 10944: --FROM PA_PROJ_PROGRESS_ATTR

10940: -- Bug 3952006 : Begin
10941: -- Commented the below code and added cursor call
10942: --SELECT task_weight_basis_code
10943: --INTO l_wp_rollup_method
10944: --FROM PA_PROJ_PROGRESS_ATTR
10945: --WHERE project_id = p_project_id
10946: --AND STRUCTURE_TYPE = 'FINANCIAL';
10947:
10948: OPEN c_get_task_weight_method(p_project_id, 'WORKPLAN');

Line 11147: FROM pa_proj_progress_attr pppa

11143: and current_flag = 'Y';
11144:
11145: CURSOR cur_proj_prog_attr IS
11146: SELECT pppa.task_weight_basis_code
11147: FROM pa_proj_progress_attr pppa
11148: WHERE project_id=p_project_id
11149: AND structure_type ='WORKPLAN'
11150: ;
11151:

Line 11367: L_TASK_WEIGHT_BASIS_CODE pa_proj_progress_attr.task_weight_basis_code%TYPE;

11363: l_login_id NUMBER := fnd_global.login_id;
11364: l_published_by_party_id NUMBER := PA_UTILS.get_party_id(l_user_id);
11365: L_LATEST_PUB_WP_VERSION_ID NUMBER;
11366: L_PRE_PUB_STR_VER_ID NUMBER;
11367: L_TASK_WEIGHT_BASIS_CODE pa_proj_progress_attr.task_weight_basis_code%TYPE;
11368: L_OBJECT_VERSION_ID NUMBER;
11369: L_PROGRESS_STATUS_CODE pa_progress_rollup.progress_status_code%TYPE;
11370: L_ACTUAL_START_DATE DATE;
11371: L_ACTUAL_FINISH_DATE DATE;

Line 13734: from pa_proj_progress_attr

13730:
13731: -- cursor to get progress rollup attrs
13732: cursor rollup_method is
13733: select TASK_WEIGHT_BASIS_CODE
13734: from pa_proj_progress_attr
13735: where project_id = l_project_id
13736: and structure_type = 'WORKPLAN';
13737:
13738: -- cursor to get planned value for task

Line 14033: update pa_proj_progress_attr

14029:
14030: --- update next_progress_cycle_date column to stamp the date upto which
14031: --- actuals are pulled in
14032: forall l_index in 1..proj_ids_tbl.count
14033: update pa_proj_progress_attr
14034: set next_progress_update_date = proj_thru_dates_tbl(l_index)
14035: where project_id = proj_ids_tbl(l_index)
14036: and object_type = 'PA_STRUCTURES'
14037: and structure_type = 'WORKPLAN';

Line 18497: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

18493: l_structure_shared VARCHAR2(1) ;
18494: l_brief_overview VARCHAR2(250) ;
18495: l_progress_comment VARCHAR2(4000) ;
18496: l_pm_product_code VARCHAR2(30) ;
18497: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE ;
18498: l_lowest_level_task VARCHAR2(1) ;
18499:
18500:
18501: l_prog_pa_period_name VARCHAR2(30) ;

Line 18536: FROM pa_proj_progress_attr

18532:
18533: CURSOR c_get_task_weight_method(c_project_id NUMBER, c_structure_type VARCHAR2)
18534: IS
18535: SELECT task_weight_basis_code
18536: FROM pa_proj_progress_attr
18537: WHERE project_id = c_project_id
18538: AND structure_type = c_structure_type;
18539:
18540:

Line 19476: from pa_proj_progress_attr pppa

19472:
19473: --added by maansari for
19474: cursor cur_task_weight IS
19475: select pppa.task_weight_basis_code
19476: from pa_proj_progress_attr pppa
19477: where pppa.project_id = p_project_id
19478: and pppa.structure_type = 'WORKPLAN';
19479:
19480: l_as_of_date DATE;

Line 19658: , pa_proj_progress_attr prog

19654: CURSOR c_get_distinct_str_ver_id IS
19655: SELECT distinct asgn.project_id project_id, asgn.structure_version_id structure_version_id
19656: FROM pa_task_asgmts_v asgn
19657: , pa_proj_elem_ver_structure str
19658: , pa_proj_progress_attr prog
19659: , pa_proj_structure_types pstype
19660: WHERE asgn.person_id = p_person_id
19661: AND asgn.structure_version_id = str.element_version_id
19662: AND asgn.project_id = str.project_id

Line 19673: , pa_proj_progress_attr prog

19669: UNION
19670: SELECT distinct elem.project_id project_id, str.element_version_id structure_version_id
19671: FROM pa_proj_elements elem
19672: , pa_proj_elem_ver_structure str
19673: , pa_proj_progress_attr prog
19674: , pa_proj_structure_types pstype
19675: WHERE elem.manager_person_id = p_person_id
19676: AND elem.object_type = 'PA_TASKS'
19677: AND elem.project_id = str.project_id

Line 21159: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

21155: l_msg_data VARCHAR2(250) ;
21156: l_object_type VARCHAR2(30) ;
21157: l_structure_version_id NUMBER ;
21158: l_task_version_id NUMBER ;
21159: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21160: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21161: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21162: l_last_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21163: L_LOWEST_LEVEL_TASK VARCHAR2(1);

Line 21160: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

21156: l_object_type VARCHAR2(30) ;
21157: l_structure_version_id NUMBER ;
21158: l_task_version_id NUMBER ;
21159: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21160: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21161: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21162: l_last_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21163: L_LOWEST_LEVEL_TASK VARCHAR2(1);
21164: l_last_progress_date DATE;

Line 21161: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

21157: l_structure_version_id NUMBER ;
21158: l_task_version_id NUMBER ;
21159: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21160: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21161: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21162: l_last_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21163: L_LOWEST_LEVEL_TASK VARCHAR2(1);
21164: l_last_progress_date DATE;
21165: l_flag VARCHAR2(1);

Line 21162: l_last_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

21158: l_task_version_id NUMBER ;
21159: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21160: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21161: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21162: l_last_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
21163: L_LOWEST_LEVEL_TASK VARCHAR2(1);
21164: l_last_progress_date DATE;
21165: l_flag VARCHAR2(1);
21166:

Line 21179: FROM pa_proj_progress_attr

21175:
21176: CURSOR c_get_task_weight_method(c_project_id NUMBER, c_structure_type VARCHAR2)
21177: IS
21178: SELECT task_weight_basis_code
21179: FROM pa_proj_progress_attr
21180: WHERE project_id = c_project_id
21181: AND structure_type = c_structure_type;
21182:
21183: CURSOR c_get_latest_pub_task_ver(c_proj_element_id NUMBER, c_project_id NUMBER)

Line 21554: UPDATE pa_proj_progress_attr

21550: END IF;
21551: END IF;
21552:
21553: IF p_structure_type = 'WORKPLAN' THEN
21554: UPDATE pa_proj_progress_attr
21555: SET next_progress_update_date = p_as_of_date_tbl(i)
21556: WHERE project_id = p_project_id_tbl(i)
21557: AND object_type = 'PA_STRUCTURES'
21558: AND structure_type = 'WORKPLAN';