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.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_GROUPS_B

Line 84: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

80: PROCEDURE INSERT_GROUPS_NO_CON(
81: P_API_VERSION IN NUMBER,
82: P_INIT_MSG_LIST IN VARCHAR2,
83: P_COMMIT IN VARCHAR2,
84: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
85: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
86: X_MSG_COUNT OUT NOCOPY NUMBER,
87: X_MSG_DATA OUT NOCOPY VARCHAR2 );
88:

Line 93: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

89: PROCEDURE UPDATE_GROUPS_NO_CON(
90: P_API_VERSION IN NUMBER,
91: P_INIT_MSG_LIST IN VARCHAR2,
92: P_COMMIT IN VARCHAR2,
93: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
94: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95: X_MSG_COUNT OUT NOCOPY NUMBER,
96: X_MSG_DATA OUT NOCOPY VARCHAR2 );
97:

Line 113: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

109: PROCEDURE INSERT_GROUPS_PARENT_NO_CON(
110: P_API_VERSION IN NUMBER,
111: P_INIT_MSG_LIST IN VARCHAR2,
112: P_COMMIT IN VARCHAR2,
113: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
114: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
115: X_MSG_COUNT OUT NOCOPY NUMBER,
116: X_MSG_DATA OUT NOCOPY VARCHAR2 );
117:

Line 131: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

127: PROCEDURE CREATE_RES_GROUPS(
128: P_API_VERSION IN NUMBER,
129: P_INIT_MSG_LIST IN VARCHAR2,
130: P_COMMIT IN VARCHAR2,
131: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
132: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
133: X_MSG_COUNT OUT NOCOPY NUMBER,
134: X_MSG_DATA OUT NOCOPY VARCHAR2 )
135: IS

Line 153: FROM jtf_rs_groups_b grp

149: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
150: IS
151: SELECT grp.start_date_active,
152: grp.end_date_active
153: FROM jtf_rs_groups_b grp
154: WHERE group_id = x_group_id;
155:
156: --Declare the variables
157: --

Line 313: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

309: PROCEDURE UPDATE_RES_GROUPS(
310: P_API_VERSION IN NUMBER,
311: P_INIT_MSG_LIST IN VARCHAR2,
312: P_COMMIT IN VARCHAR2,
313: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
314: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
315: X_MSG_COUNT OUT NOCOPY NUMBER,
316: X_MSG_DATA OUT NOCOPY VARCHAR2 )
317: IS

Line 337: CURSOR denorm_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

333: L_MSG_DATA VARCHAR2(200);
334: L_MSG_COUNT number;
335:
336:
337: CURSOR denorm_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
338: IS
339: SELECT denorm_grp_id
340: FROM jtf_rs_groups_denorm
341: WHERE group_id = l_group_id

Line 445: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

441: PROCEDURE INSERT_GROUPS(
442: P_API_VERSION IN NUMBER,
443: P_INIT_MSG_LIST IN VARCHAR2,
444: P_COMMIT IN VARCHAR2,
445: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
446: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
447: X_MSG_COUNT OUT NOCOPY NUMBER,
448: X_MSG_DATA OUT NOCOPY VARCHAR2 )
449: IS

Line 473: FROM jtf_rs_groups_b grp

469: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
470: IS
471: SELECT grp.start_date_active,
472: grp.end_date_active
473: FROM jtf_rs_groups_b grp
474: WHERE group_id = x_group_id;
475:
476: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
477: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 527: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;

523:
524: cb_p_api_version number := p_api_version;
525: cb_p_init_msg_list varchar2(10) := P_INIT_MSG_LIST;
526: cb_p_commit varchar2(10) := P_COMMIT;
527: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;
528: ---------------------------------------------------------
529:
530: TYPE CHILD_TYPE IS RECORD
531: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 1220: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

1216: PROCEDURE UPDATE_GROUPS(
1217: P_API_VERSION IN NUMBER,
1218: P_INIT_MSG_LIST IN VARCHAR2,
1219: P_COMMIT IN VARCHAR2,
1220: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1221: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1222: X_MSG_COUNT OUT NOCOPY NUMBER,
1223: X_MSG_DATA OUT NOCOPY VARCHAR2 )
1224: IS

Line 1263: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;

1259:
1260: cb_p_api_version number := p_api_version;
1261: cb_p_init_msg_list varchar2(10) := P_INIT_MSG_LIST;
1262: cb_p_commit varchar2(10) := P_COMMIT;
1263: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;
1264: ---------------------------------------------------------
1265:
1266: --Declare the variables
1267: --

Line 1580: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;

1576:
1577: cb_p_api_version number := p_api_version;
1578: cb_p_init_msg_list varchar2(10) := P_INIT_MSG_LIST;
1579: cb_p_commit varchar2(10) := P_COMMIT;
1580: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;
1581: cb_p_group_relate_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_relate_id;
1582: cb_p_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_related_group_id;
1583: ---------------------------------------------------------
1584:

Line 1581: cb_p_group_relate_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_relate_id;

1577: cb_p_api_version number := p_api_version;
1578: cb_p_init_msg_list varchar2(10) := P_INIT_MSG_LIST;
1579: cb_p_commit varchar2(10) := P_COMMIT;
1580: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;
1581: cb_p_group_relate_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_relate_id;
1582: cb_p_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_related_group_id;
1583: ---------------------------------------------------------
1584:
1585: begin

Line 1582: cb_p_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_related_group_id;

1578: cb_p_init_msg_list varchar2(10) := P_INIT_MSG_LIST;
1579: cb_p_commit varchar2(10) := P_COMMIT;
1580: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;
1581: cb_p_group_relate_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_relate_id;
1582: cb_p_related_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_related_group_id;
1583: ---------------------------------------------------------
1584:
1585: begin
1586:

Line 1875: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

1871: PROCEDURE INSERT_GROUPS_PARENT(
1872: P_API_VERSION IN NUMBER,
1873: P_INIT_MSG_LIST IN VARCHAR2,
1874: P_COMMIT IN VARCHAR2,
1875: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1876: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1877: X_MSG_COUNT OUT NOCOPY NUMBER,
1878: X_MSG_DATA OUT NOCOPY VARCHAR2 )
1879: IS

Line 1902: FROM jtf_rs_groups_b grp

1898: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
1899: IS
1900: SELECT grp.start_date_active,
1901: grp.end_date_active
1902: FROM jtf_rs_groups_b grp
1903: WHERE group_id = x_group_id;
1904:
1905: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
1906: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 1934: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;

1930:
1931: cb_p_api_version number := p_api_version;
1932: cb_p_init_msg_list varchar2(10) := P_INIT_MSG_LIST;
1933: cb_p_commit varchar2(10) := P_COMMIT;
1934: cb_p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE := p_group_id;
1935: ---------------------------------------------------------
1936:
1937:
1938: --Declare the variables

Line 2293: CURSOR c_child_denorm(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,

2289: FROM JTF_RS_GROUPS_DENORM
2290: WHERE group_id = l_group_id
2291: AND parent_group_id <> l_group_id; --added this
2292:
2293: CURSOR c_child_denorm(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
2294: l_parent_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
2295: IS
2296: SELECT denorm_grp_id
2297: FROM JTF_RS_GROUPS_DENORM

Line 2294: l_parent_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )

2290: WHERE group_id = l_group_id
2291: AND parent_group_id <> l_group_id; --added this
2292:
2293: CURSOR c_child_denorm(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
2294: l_parent_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE )
2295: IS
2296: SELECT denorm_grp_id
2297: FROM JTF_RS_GROUPS_DENORM
2298: WHERE group_id = l_group_id

Line 2639: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

2635: PROCEDURE INSERT_GROUPS_NO_CON(
2636: P_API_VERSION IN NUMBER,
2637: P_INIT_MSG_LIST IN VARCHAR2,
2638: P_COMMIT IN VARCHAR2,
2639: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
2640: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2641: X_MSG_COUNT OUT NOCOPY NUMBER,
2642: X_MSG_DATA OUT NOCOPY VARCHAR2 )
2643: IS

Line 2648: FROM jtf_rs_groups_b grp

2644: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
2645: IS
2646: SELECT grp.start_date_active,
2647: grp.end_date_active
2648: FROM jtf_rs_groups_b grp
2649: WHERE group_id = x_group_id;
2650:
2651: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
2652: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 3323: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

3319: PROCEDURE UPDATE_GROUPS_NO_CON(
3320: P_API_VERSION IN NUMBER,
3321: P_INIT_MSG_LIST IN VARCHAR2,
3322: P_COMMIT IN VARCHAR2,
3323: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3324: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3325: X_MSG_COUNT OUT NOCOPY NUMBER,
3326: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3327: IS

Line 3839: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,

3835: PROCEDURE INSERT_GROUPS_PARENT_NO_CON(
3836: P_API_VERSION IN NUMBER,
3837: P_INIT_MSG_LIST IN VARCHAR2,
3838: P_COMMIT IN VARCHAR2,
3839: p_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3840: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3841: X_MSG_COUNT OUT NOCOPY NUMBER,
3842: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3843: IS

Line 3848: FROM jtf_rs_groups_b grp

3844: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
3845: IS
3846: SELECT grp.start_date_active,
3847: grp.end_date_active
3848: FROM jtf_rs_groups_b grp
3849: WHERE group_id = x_group_id;
3850:
3851: CURSOR c_dup(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
3852: x_parent_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,