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 1239: FROM pa_ind_rate_schedules

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

Line 4661: pa_ind_rate_schedules sch

4657: WHERE ind_compiled_set_id IN
4658: (SELECT ics.ind_compiled_set_id
4659: FROM pa_ind_compiled_sets ics,
4660: pa_ind_rate_sch_revisions rev,
4661: pa_ind_rate_schedules sch
4662: WHERE ics.ind_rate_sch_revision_id =
4663: rev.ind_rate_sch_revision_id
4664: AND rev.ind_rate_sch_id = sch.ind_rate_sch_id
4665: AND sch.task_id = p_task_id);

Line 4671: pa_ind_rate_schedules sch

4667: DELETE FROM pa_ind_compiled_sets
4668: WHERE ind_rate_sch_revision_id IN
4669: (SELECT rev.ind_rate_sch_revision_id
4670: FROM pa_ind_rate_sch_revisions rev,
4671: pa_ind_rate_schedules sch
4672: WHERE rev.ind_rate_sch_id = sch.ind_rate_sch_id
4673: AND sch.task_id = p_task_id );
4674:
4675: DELETE FROM pa_ind_rate_sch_revisions

Line 4678: FROM pa_ind_rate_schedules

4674:
4675: DELETE FROM pa_ind_rate_sch_revisions
4676: WHERE ind_rate_sch_id IN
4677: (SELECT ind_rate_sch_id
4678: FROM pa_ind_rate_schedules
4679: WHERE task_id = p_task_id );
4680:
4681: DELETE FROM pa_ind_rate_schedules WHERE task_id = p_task_id;
4682:

Line 4681: DELETE FROM pa_ind_rate_schedules WHERE task_id = p_task_id;

4677: (SELECT ind_rate_sch_id
4678: FROM pa_ind_rate_schedules
4679: WHERE task_id = p_task_id );
4680:
4681: DELETE FROM pa_ind_rate_schedules WHERE task_id = p_task_id;
4682:
4683: DELETE FROM pa_project_asset_assignments WHERE task_id = p_task_id;
4684:
4685: DELETE FROM pa_percent_completes WHERE task_id = p_task_id;

Line 5247: FROM pa_ind_rate_schedules

5243:
5244: CURSOR l_ind_rate_schedule_type_csr( p_cost_ind_rate_sch_id NUMBER)
5245: IS
5246: SELECT ind_rate_schedule_type
5247: FROM pa_ind_rate_schedules
5248: WHERE ind_rate_sch_id = p_cost_ind_rate_sch_id;
5249:
5250: -- Fix for Bug # 1335417
5251: l_temp_var_sch_type VARCHAR2(1);

Line 5260: FROM pa_ind_rate_schedules

5256:
5257: CURSOR l_cost_ind_rate_sch_id_csr( p_cost_ind_rate_sch_id NUMBER)
5258: IS
5259: SELECT 'x'
5260: FROM pa_ind_rate_schedules
5261: WHERE ind_rate_sch_id = p_cost_ind_rate_sch_id;
5262:
5263: -- Fix for Bug # 1272548
5264: l_temp_var VARCHAR2(1);

Line 7969: FROM pa_ind_rate_schedules

7965: if p_rev_ind_rate_sch_id <> g_rev_ind_rate_sch_id then -- added for bug 3795253
7966: BEGIN
7967:
7968: SELECT ind_rate_schedule_type INTO l_rev_rate_sch_type
7969: FROM pa_ind_rate_schedules
7970: WHERE ind_rate_sch_id = p_rev_ind_rate_sch_id
7971: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
7972: g_rev_rate_sch_type := l_rev_rate_sch_type; -- added for bug 3795253
7973: g_rev_ind_rate_sch_id := p_rev_ind_rate_sch_id; -- added for bug 3795253

Line 8005: FROM pa_ind_rate_schedules

8001: and l_task_rec.REV_IND_RATE_SCH_ID <> g_rev_ind_rate_sch_id -- Added for bug 3795253
8002: THEN
8003:
8004: SELECT ind_rate_schedule_type INTO l_rev_rate_sch_type
8005: FROM pa_ind_rate_schedules
8006: WHERE ind_rate_sch_id = l_task_rec.REV_IND_RATE_SCH_ID;
8007:
8008: g_rev_rate_sch_type := l_rev_rate_sch_type; -- added for bug 3795253
8009: g_rev_ind_rate_sch_id := l_task_rec.REV_IND_RATE_SCH_ID; -- added for bug 3795253

Line 8031: FROM pa_ind_rate_schedules

8027:
8028: BEGIN
8029:
8030: SELECT ind_rate_schedule_type INTO l_inv_rate_sch_type
8031: FROM pa_ind_rate_schedules
8032: WHERE ind_rate_sch_id = p_inv_ind_rate_sch_id
8033: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
8034:
8035: g_inv_rate_sch_type := l_inv_rate_sch_type; -- added for bug 3795253

Line 8068: FROM pa_ind_rate_schedules

8064: THEN
8065:
8066:
8067: SELECT ind_rate_schedule_type INTO l_inv_rate_sch_type
8068: FROM pa_ind_rate_schedules
8069: WHERE ind_rate_sch_id = l_task_rec.INV_IND_RATE_SCH_ID;
8070: g_inv_rate_sch_type := l_inv_rate_sch_type; -- added for bug 3795253
8071: g_inv_ind_rate_sch_id := l_task_rec.INV_IND_RATE_SCH_ID; -- added for bug 3795253
8072: -- Bug 3657709

Line 10967: FROM pa_ind_rate_schedules

10963:
10964: CURSOR l_rev_rate_schedule_type_csr( p_rev_ind_rate_sch_id NUMBER)
10965: IS
10966: SELECT ind_rate_schedule_type
10967: FROM pa_ind_rate_schedules
10968: WHERE ind_rate_sch_id = p_rev_ind_rate_sch_id
10969: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
10970:
10971: CURSOR l_inv_rate_schedule_type_csr( p_inv_ind_rate_sch_id NUMBER)

Line 10974: FROM pa_ind_rate_schedules

10970:
10971: CURSOR l_inv_rate_schedule_type_csr( p_inv_ind_rate_sch_id NUMBER)
10972: IS
10973: SELECT ind_rate_schedule_type
10974: FROM pa_ind_rate_schedules
10975: WHERE ind_rate_sch_id = p_inv_ind_rate_sch_id
10976: AND trunc(sysdate) between trunc(start_date_active) and nvl(end_date_active,trunc(sysdate));
10977:
10978: --R12: Bug 4363092 - removed nvl for org_id in below cursor