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 4002: from pa_proj_progress_attr

3998: where task_type_id = p_task_type_id ;
3999:
4000: cursor chk_structure_ppc_enabled is
4001: select percent_comp_enable_flag
4002: from pa_proj_progress_attr
4003: where project_id = p_project_id
4004: and structure_type = p_structure_type;
4005:
4006: l_task_type_id number;

Line 4767: PA_PROJ_PROGRESS_ATTR_PKG.INSERT_ROW(

4763: l_task_weight_basis_code := p_TASK_WEIGHT_BASIS_CODE;
4764: END IF;
4765: --end bug 3010538
4766:
4767: PA_PROJ_PROGRESS_ATTR_PKG.INSERT_ROW(
4768: X_PROJ_PROGRESS_ATTR_ID => X_PROJ_PROGRESS_ATTR_ID
4769: ,x_project_id => p_project_id
4770: ,X_OBJECT_TYPE => P_OBJECT_TYPE
4771: ,X_OBJECT_ID => P_OBJECT_ID

Line 4880: from pa_proj_progress_attr

4876: l_TASK_WEIGHT_BASIS_CODE VARCHAR2(30);
4877:
4878: CURSOR cur_task_weight_bas_code IS
4879: select task_weight_basis_code
4880: from pa_proj_progress_attr
4881: where proj_progress_attr_id = p_proj_progress_attr_id;
4882: l_old_tk_wght_basis_code VARCHAR2(30);
4883: l_updt_struc_ver_id NUMBER;
4884:

Line 4919: FROM PA_PROJ_PROGRESS_ATTR

4915: CURSOR cur_prg_attr
4916: IS
4917: SELECT WQ_ENABLE_FLAG, REMAIN_EFFORT_ENABLE_FLAG,
4918: PERCENT_COMP_ENABLE_FLAG
4919: FROM PA_PROJ_PROGRESS_ATTR
4920: WHERE PROJ_PROGRESS_ATTR_ID = p_PROJ_PROGRESS_ATTR_ID;
4921:
4922: -- Bug # 4576303.
4923: cursor cur_tasks_exist (c_str_ver_id NUMBER) is

Line 5198: PA_PROJ_PROGRESS_ATTR_PKG.UPDATE_ROW(

5194: l_task_weight_basis_code := p_TASK_WEIGHT_BASIS_CODE;
5195: END IF;
5196: --end bug 3010538
5197:
5198: PA_PROJ_PROGRESS_ATTR_PKG.UPDATE_ROW(
5199: X_PROJ_PROGRESS_ATTR_ID => P_PROJ_PROGRESS_ATTR_ID
5200: ,X_project_id => p_project_id
5201: ,X_OBJECT_TYPE => p_OBJECT_TYPE
5202: ,X_OBJECT_ID => p_OBJECT_ID

Line 5286: FROM pa_proj_progress_attr

5282:
5283: CURSOR cur_ppp
5284: IS
5285: SELECT rowid
5286: FROM pa_proj_progress_attr
5287: WHERE project_id = p_project_id
5288: AND object_type = p_object_type
5289: AND object_id = p_object_id
5290: AND structure_type = p_structure_type; -- Amit

Line 5322: PA_PROJ_PROGRESS_ATTR_PKG.DELETE_ROW( l_ppp_row_id

5318: OPEN cur_ppp;
5319: FETCH cur_ppp INTO l_ppp_row_id;
5320: CLOSE cur_ppp;
5321:
5322: PA_PROJ_PROGRESS_ATTR_PKG.DELETE_ROW( l_ppp_row_id
5323: );
5324:
5325: x_return_status := FND_API.G_RET_STS_SUCCESS;
5326:

Line 7381: from pa_proj_progress_attr pppa

7377:
7378: cursor cur_proj_prog_attr
7379: is
7380: select pppa.task_weight_basis_code
7381: from pa_proj_progress_attr pppa
7382: where project_id=p_project_id
7383: and structure_type ='WORKPLAN'
7384: ;
7385:

Line 8900: delete from pa_proj_progress_attr

8896:
8897: delete from pa_progress_rollup
8898: where project_id = p_project_id;
8899:
8900: delete from pa_proj_progress_attr
8901: where project_id = p_project_id;
8902:
8903: delete from pa_proj_workplan_attr
8904: where project_id = p_project_id;

Line 9260: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

9256: l_msg_data VARCHAR2(250) ;
9257: l_object_type VARCHAR2(30) ;
9258: l_structure_version_id NUMBER ;
9259: l_task_version_id NUMBER ;
9260: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
9261: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
9262: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
9263: L_LOWEST_LEVEL_TASK VARCHAR2(1);
9264: l_last_progress_date DATE;

Line 9261: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

9257: l_object_type VARCHAR2(30) ;
9258: l_structure_version_id NUMBER ;
9259: l_task_version_id NUMBER ;
9260: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
9261: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
9262: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
9263: L_LOWEST_LEVEL_TASK VARCHAR2(1);
9264: l_last_progress_date DATE;
9265: l_plan_version_id NUMBER;

Line 9262: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

9258: l_structure_version_id NUMBER ;
9259: l_task_version_id NUMBER ;
9260: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
9261: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
9262: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
9263: L_LOWEST_LEVEL_TASK VARCHAR2(1);
9264: l_last_progress_date DATE;
9265: l_plan_version_id NUMBER;
9266:

Line 9282: FROM pa_proj_progress_attr

9278:
9279: CURSOR c_get_task_weight_method(c_project_id NUMBER, c_structure_type VARCHAR2)
9280: IS
9281: SELECT task_weight_basis_code
9282: FROM pa_proj_progress_attr
9283: WHERE project_id = c_project_id
9284: AND structure_type = c_structure_type;
9285:
9286: CURSOR c_get_latest_pub_task_ver(c_proj_element_id NUMBER, c_project_id NUMBER)

Line 9572: FROM pa_proj_progress_attr

9568: -- bug 7225884
9569: BEGIN
9570: SELECT next_progress_update_date
9571: INTO l_prev_prog_upd_date
9572: FROM pa_proj_progress_attr
9573: WHERE project_id = p_project_id
9574: AND object_type = 'PA_STRUCTURES'
9575: AND structure_type = 'WORKPLAN';
9576: EXCEPTION

Line 9582: UPDATE pa_proj_progress_attr

9578: l_prev_prog_upd_date := p_as_of_date-1;
9579: END;
9580:
9581: IF NVL(l_prev_prog_upd_date,p_as_of_date-1) <> p_as_of_date THEN
9582: UPDATE pa_proj_progress_attr
9583: SET next_progress_update_date = p_as_of_date
9584: WHERE project_id = p_project_id
9585: AND object_type = 'PA_STRUCTURES'
9586: AND structure_type = 'WORKPLAN';

Line 11196: FROM pa_proj_progress_attr

11192:
11193: CURSOR c_get_task_weight_method(c_project_id NUMBER, c_structure_type VARCHAR2)
11194: IS
11195: SELECT task_weight_basis_code
11196: FROM pa_proj_progress_attr
11197: WHERE project_id = c_project_id
11198: AND structure_type = c_structure_type;
11199:
11200: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

Line 11200: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

11196: FROM pa_proj_progress_attr
11197: WHERE project_id = c_project_id
11198: AND structure_type = c_structure_type;
11199:
11200: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE ;
11201: l_baselined_str_ver_id NUMBER ;
11202: -- Bug 4136239 : Added l_call_rollup, l_call_update_progress
11203: l_call_rollup VARCHAR2(1):='N' ;
11204: l_call_update_progress VARCHAR2(1):='N' ;

Line 11386: --FROM PA_PROJ_PROGRESS_ATTR

11382: -- Bug 3952006 : Begin
11383: -- Commented the below code and added cursor call
11384: --SELECT task_weight_basis_code
11385: --INTO l_wp_rollup_method
11386: --FROM PA_PROJ_PROGRESS_ATTR
11387: --WHERE project_id = p_project_id
11388: --AND STRUCTURE_TYPE = 'FINANCIAL';
11389:
11390: OPEN c_get_task_weight_method(p_project_id, 'WORKPLAN');

Line 11589: FROM pa_proj_progress_attr pppa

11585: and current_flag = 'Y';
11586:
11587: CURSOR cur_proj_prog_attr IS
11588: SELECT pppa.task_weight_basis_code
11589: FROM pa_proj_progress_attr pppa
11590: WHERE project_id=p_project_id
11591: AND structure_type ='WORKPLAN'
11592: ;
11593:

Line 11817: L_TASK_WEIGHT_BASIS_CODE pa_proj_progress_attr.task_weight_basis_code%TYPE;

11813: l_login_id NUMBER := fnd_global.login_id;
11814: l_published_by_party_id NUMBER := PA_UTILS.get_party_id(l_user_id);
11815: L_LATEST_PUB_WP_VERSION_ID NUMBER;
11816: L_PRE_PUB_STR_VER_ID NUMBER;
11817: L_TASK_WEIGHT_BASIS_CODE pa_proj_progress_attr.task_weight_basis_code%TYPE;
11818: L_OBJECT_VERSION_ID NUMBER;
11819: L_PROGRESS_STATUS_CODE pa_progress_rollup.progress_status_code%TYPE;
11820: L_ACTUAL_START_DATE DATE;
11821: L_ACTUAL_FINISH_DATE DATE;

Line 14227: from pa_proj_progress_attr

14223:
14224: -- cursor to get progress rollup attrs
14225: cursor rollup_method is
14226: select TASK_WEIGHT_BASIS_CODE
14227: from pa_proj_progress_attr
14228: where project_id = l_project_id
14229: and structure_type = 'WORKPLAN';
14230:
14231: -- cursor to get planned value for task

Line 14551: update pa_proj_progress_attr

14547:
14548: --- update next_progress_cycle_date column to stamp the date upto which
14549: --- actuals are pulled in
14550: forall l_index in 1..proj_ids_tbl.count
14551: update pa_proj_progress_attr
14552: set next_progress_update_date = proj_thru_dates_tbl(l_index)
14553: where project_id = proj_ids_tbl(l_index)
14554: and object_type = 'PA_STRUCTURES'
14555: and structure_type = 'WORKPLAN';

Line 19942: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE ;

19938: l_structure_shared VARCHAR2(1) ;
19939: l_brief_overview VARCHAR2(250) ;
19940: l_progress_comment VARCHAR2(4000) ;
19941: l_pm_product_code VARCHAR2(30) ;
19942: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE ;
19943: l_lowest_level_task VARCHAR2(1) ;
19944:
19945:
19946: l_prog_pa_period_name VARCHAR2(30) ;

Line 19981: FROM pa_proj_progress_attr

19977:
19978: CURSOR c_get_task_weight_method(c_project_id NUMBER, c_structure_type VARCHAR2)
19979: IS
19980: SELECT task_weight_basis_code
19981: FROM pa_proj_progress_attr
19982: WHERE project_id = c_project_id
19983: AND structure_type = c_structure_type;
19984:
19985:

Line 20939: from pa_proj_progress_attr pppa

20935:
20936: --added by maansari for
20937: cursor cur_task_weight IS
20938: select pppa.task_weight_basis_code
20939: from pa_proj_progress_attr pppa
20940: where pppa.project_id = p_project_id
20941: and pppa.structure_type = 'WORKPLAN';
20942:
20943: l_as_of_date DATE;

Line 21121: , pa_proj_progress_attr prog

21117: CURSOR c_get_distinct_str_ver_id IS
21118: SELECT distinct asgn.project_id project_id, asgn.structure_version_id structure_version_id
21119: FROM pa_task_asgmts_v asgn
21120: , pa_proj_elem_ver_structure str
21121: , pa_proj_progress_attr prog
21122: , pa_proj_structure_types pstype
21123: WHERE asgn.person_id = p_person_id
21124: AND asgn.structure_version_id = str.element_version_id
21125: AND asgn.project_id = str.project_id

Line 21136: , pa_proj_progress_attr prog

21132: UNION
21133: SELECT distinct elem.project_id project_id, str.element_version_id structure_version_id
21134: FROM pa_proj_elements elem
21135: , pa_proj_elem_ver_structure str
21136: , pa_proj_progress_attr prog
21137: , pa_proj_structure_types pstype
21138: WHERE elem.manager_person_id = p_person_id
21139: AND elem.object_type = 'PA_TASKS'
21140: AND elem.project_id = str.project_id

Line 22622: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

22618: l_msg_data VARCHAR2(250) ;
22619: l_object_type VARCHAR2(30) ;
22620: l_structure_version_id NUMBER ;
22621: l_task_version_id NUMBER ;
22622: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22623: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22624: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22625: l_last_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22626: L_LOWEST_LEVEL_TASK VARCHAR2(1);

Line 22623: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

22619: l_object_type VARCHAR2(30) ;
22620: l_structure_version_id NUMBER ;
22621: l_task_version_id NUMBER ;
22622: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22623: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22624: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22625: l_last_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22626: L_LOWEST_LEVEL_TASK VARCHAR2(1);
22627: l_last_progress_date DATE;

Line 22624: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

22620: l_structure_version_id NUMBER ;
22621: l_task_version_id NUMBER ;
22622: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22623: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22624: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22625: l_last_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22626: L_LOWEST_LEVEL_TASK VARCHAR2(1);
22627: l_last_progress_date DATE;
22628: l_flag VARCHAR2(1);

Line 22625: l_last_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;

22621: l_task_version_id NUMBER ;
22622: l_wp_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22623: l_fin_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22624: l_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22625: l_last_rollup_method pa_proj_progress_attr.task_weight_basis_code%TYPE;
22626: L_LOWEST_LEVEL_TASK VARCHAR2(1);
22627: l_last_progress_date DATE;
22628: l_flag VARCHAR2(1);
22629:

Line 22642: FROM pa_proj_progress_attr

22638:
22639: CURSOR c_get_task_weight_method(c_project_id NUMBER, c_structure_type VARCHAR2)
22640: IS
22641: SELECT task_weight_basis_code
22642: FROM pa_proj_progress_attr
22643: WHERE project_id = c_project_id
22644: AND structure_type = c_structure_type;
22645:
22646: CURSOR c_get_latest_pub_task_ver(c_proj_element_id NUMBER, c_project_id NUMBER)

Line 23024: FROM pa_proj_progress_attr

23020: IF p_structure_type = 'WORKPLAN' THEN -- bug 7225884
23021: BEGIN
23022: SELECT next_progress_update_date
23023: INTO l_prev_prog_upd_date
23024: FROM pa_proj_progress_attr
23025: WHERE project_id = p_project_id_tbl(i)
23026: AND object_type = 'PA_STRUCTURES'
23027: AND structure_type = 'WORKPLAN';
23028: EXCEPTION

Line 23034: UPDATE pa_proj_progress_attr

23030: l_prev_prog_upd_date := p_as_of_date_tbl(i)-1;
23031: END;
23032:
23033: IF NVL(l_prev_prog_upd_date,p_as_of_date_tbl(i)-1) <> p_as_of_date_tbl(i) THEN
23034: UPDATE pa_proj_progress_attr
23035: SET next_progress_update_date = p_as_of_date_tbl(i)
23036: WHERE project_id = p_project_id_tbl(i)
23037: AND object_type = 'PA_STRUCTURES'
23038: AND structure_type = 'WORKPLAN';