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_PVT dependencies on PA_IND_RATE_SCHEDULES

Line 17: g_rev_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE := NULL; -- added for bug 3975253 (or can also init to PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

13: G_KEY_MEMBER_CODE CONSTANT VARCHAR2(100) :='ORG_ROLE';
14: l_pm_product_code VARCHAR2(2) :='Z'; /*for bug 2413400 a new variable defined.*/
15:
16: -- scope of these four global variables pertains within this package body
17: g_rev_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE := NULL; -- added for bug 3975253 (or can also init to PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
18: g_rev_rate_sch_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE := NULL; -- added for bug 3975253
19: g_inv_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE := NULL; -- added for bug 3975253
20: g_inv_rate_sch_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE := NULL; -- added for bug 3975253
21:

Line 18: g_rev_rate_sch_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE := NULL; -- added for bug 3975253

14: l_pm_product_code VARCHAR2(2) :='Z'; /*for bug 2413400 a new variable defined.*/
15:
16: -- scope of these four global variables pertains within this package body
17: g_rev_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE := NULL; -- added for bug 3975253 (or can also init to PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
18: g_rev_rate_sch_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE := NULL; -- added for bug 3975253
19: g_inv_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE := NULL; -- added for bug 3975253
20: g_inv_rate_sch_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE := NULL; -- added for bug 3975253
21:
22: /*code added for bug no:2413400 */

Line 19: g_inv_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE := NULL; -- added for bug 3975253

15:
16: -- scope of these four global variables pertains within this package body
17: g_rev_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE := NULL; -- added for bug 3975253 (or can also init to PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
18: g_rev_rate_sch_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE := NULL; -- added for bug 3975253
19: g_inv_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE := NULL; -- added for bug 3975253
20: g_inv_rate_sch_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE := NULL; -- added for bug 3975253
21:
22: /*code added for bug no:2413400 */
23: Cursor p_product_code_csr (p_pm_product_code IN VARCHAR2)

Line 20: g_inv_rate_sch_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE := NULL; -- added for bug 3975253

16: -- scope of these four global variables pertains within this package body
17: g_rev_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE := NULL; -- added for bug 3975253 (or can also init to PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
18: g_rev_rate_sch_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE := NULL; -- added for bug 3975253
19: g_inv_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE := NULL; -- added for bug 3975253
20: g_inv_rate_sch_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE := NULL; -- added for bug 3975253
21:
22: /*code added for bug no:2413400 */
23: Cursor p_product_code_csr (p_pm_product_code IN VARCHAR2)
24: Is

Line 1241: FROM pa_ind_rate_schedules

1237:
1238: CURSOR l_ind_rate_schedule_type_csr( p_cost_ind_rate_sch_id NUMBER)
1239: IS
1240: SELECT ind_rate_schedule_type
1241: FROM pa_ind_rate_schedules
1242: WHERE ind_rate_sch_id = p_cost_ind_rate_sch_id;
1243:
1244: --Bug 3279981
1245: --The revenue acrual method for the task needs to be defaulted from the (new) project

Line 4858: pa_ind_rate_schedules sch

4854: WHERE ind_compiled_set_id IN
4855: (SELECT ics.ind_compiled_set_id
4856: FROM pa_ind_compiled_sets ics,
4857: pa_ind_rate_sch_revisions rev,
4858: pa_ind_rate_schedules sch
4859: WHERE ics.ind_rate_sch_revision_id =
4860: rev.ind_rate_sch_revision_id
4861: AND rev.ind_rate_sch_id = sch.ind_rate_sch_id
4862: AND sch.task_id = p_task_id);

Line 4868: pa_ind_rate_schedules sch

4864: DELETE FROM pa_ind_compiled_sets
4865: WHERE ind_rate_sch_revision_id IN
4866: (SELECT rev.ind_rate_sch_revision_id
4867: FROM pa_ind_rate_sch_revisions rev,
4868: pa_ind_rate_schedules sch
4869: WHERE rev.ind_rate_sch_id = sch.ind_rate_sch_id
4870: AND sch.task_id = p_task_id );
4871:
4872: DELETE FROM pa_ind_rate_sch_revisions

Line 4875: FROM pa_ind_rate_schedules

4871:
4872: DELETE FROM pa_ind_rate_sch_revisions
4873: WHERE ind_rate_sch_id IN
4874: (SELECT ind_rate_sch_id
4875: FROM pa_ind_rate_schedules
4876: WHERE task_id = p_task_id );
4877:
4878: DELETE FROM pa_ind_rate_schedules WHERE task_id = p_task_id;
4879:

Line 4878: DELETE FROM pa_ind_rate_schedules WHERE task_id = p_task_id;

4874: (SELECT ind_rate_sch_id
4875: FROM pa_ind_rate_schedules
4876: WHERE task_id = p_task_id );
4877:
4878: DELETE FROM pa_ind_rate_schedules WHERE task_id = p_task_id;
4879:
4880: DELETE FROM pa_project_asset_assignments WHERE task_id = p_task_id;
4881:
4882: DELETE FROM pa_percent_completes WHERE task_id = p_task_id;

Line 5445: FROM pa_ind_rate_schedules

5441:
5442: CURSOR l_ind_rate_schedule_type_csr( p_cost_ind_rate_sch_id NUMBER)
5443: IS
5444: SELECT ind_rate_schedule_type
5445: FROM pa_ind_rate_schedules
5446: WHERE ind_rate_sch_id = p_cost_ind_rate_sch_id;
5447:
5448: -- Fix for Bug # 1335417
5449: l_temp_var_sch_type VARCHAR2(1);

Line 5458: FROM pa_ind_rate_schedules

5454:
5455: CURSOR l_cost_ind_rate_sch_id_csr( p_cost_ind_rate_sch_id NUMBER)
5456: IS
5457: SELECT 'x'
5458: FROM pa_ind_rate_schedules
5459: WHERE ind_rate_sch_id = p_cost_ind_rate_sch_id;
5460:
5461: -- Fix for Bug # 1272548
5462: l_temp_var VARCHAR2(1);

Line 8308: FROM pa_ind_rate_schedules

8304: if p_rev_ind_rate_sch_id <> g_rev_ind_rate_sch_id then -- added for bug 3795253
8305: BEGIN
8306:
8307: SELECT ind_rate_schedule_type INTO l_rev_rate_sch_type
8308: FROM pa_ind_rate_schedules
8309: WHERE ind_rate_sch_id = p_rev_ind_rate_sch_id
8310: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
8311: g_rev_rate_sch_type := l_rev_rate_sch_type; -- added for bug 3795253
8312: g_rev_ind_rate_sch_id := p_rev_ind_rate_sch_id; -- added for bug 3795253

Line 8344: FROM pa_ind_rate_schedules

8340: and l_task_rec.REV_IND_RATE_SCH_ID <> g_rev_ind_rate_sch_id -- Added for bug 3795253
8341: THEN
8342:
8343: SELECT ind_rate_schedule_type INTO l_rev_rate_sch_type
8344: FROM pa_ind_rate_schedules
8345: WHERE ind_rate_sch_id = l_task_rec.REV_IND_RATE_SCH_ID;
8346:
8347: g_rev_rate_sch_type := l_rev_rate_sch_type; -- added for bug 3795253
8348: g_rev_ind_rate_sch_id := l_task_rec.REV_IND_RATE_SCH_ID; -- added for bug 3795253

Line 8370: FROM pa_ind_rate_schedules

8366:
8367: BEGIN
8368:
8369: SELECT ind_rate_schedule_type INTO l_inv_rate_sch_type
8370: FROM pa_ind_rate_schedules
8371: WHERE ind_rate_sch_id = p_inv_ind_rate_sch_id
8372: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
8373:
8374: g_inv_rate_sch_type := l_inv_rate_sch_type; -- added for bug 3795253

Line 8407: FROM pa_ind_rate_schedules

8403: THEN
8404:
8405:
8406: SELECT ind_rate_schedule_type INTO l_inv_rate_sch_type
8407: FROM pa_ind_rate_schedules
8408: WHERE ind_rate_sch_id = l_task_rec.INV_IND_RATE_SCH_ID;
8409: g_inv_rate_sch_type := l_inv_rate_sch_type; -- added for bug 3795253
8410: g_inv_ind_rate_sch_id := l_task_rec.INV_IND_RATE_SCH_ID; -- added for bug 3795253
8411: -- Bug 3657709

Line 11317: FROM pa_ind_rate_schedules

11313:
11314: CURSOR l_rev_rate_schedule_type_csr( p_rev_ind_rate_sch_id NUMBER)
11315: IS
11316: SELECT ind_rate_schedule_type
11317: FROM pa_ind_rate_schedules
11318: WHERE ind_rate_sch_id = p_rev_ind_rate_sch_id
11319: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
11320:
11321: CURSOR l_inv_rate_schedule_type_csr( p_inv_ind_rate_sch_id NUMBER)

Line 11324: FROM pa_ind_rate_schedules

11320:
11321: CURSOR l_inv_rate_schedule_type_csr( p_inv_ind_rate_sch_id NUMBER)
11322: IS
11323: SELECT ind_rate_schedule_type
11324: FROM pa_ind_rate_schedules
11325: WHERE ind_rate_sch_id = p_inv_ind_rate_sch_id
11326: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
11327:
11328: --R12: Bug 4363092 - removed nvl for org_id in below cursor