DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_GROUP_DENORM_PVT

Line 1: PACKAGE body JTF_RS_GROUP_DENORM_PVT AS

1: PACKAGE body JTF_RS_GROUP_DENORM_PVT AS
2: /* $Header: jtfrsvdb.pls 120.1 2005/06/13 21:15:33 baianand ship $ */
3: -- API Name : JTF_RS_GROUP_DENORM_PVT
4: -- Type : Private
5: -- Purpose : Inserts/Update the JTF_RS_GROUP_DENORM_PVT table based on changes in jtf_rs_group_relations

Line 3: -- API Name : JTF_RS_GROUP_DENORM_PVT

1: PACKAGE body JTF_RS_GROUP_DENORM_PVT AS
2: /* $Header: jtfrsvdb.pls 120.1 2005/06/13 21:15:33 baianand ship $ */
3: -- API Name : JTF_RS_GROUP_DENORM_PVT
4: -- Type : Private
5: -- Purpose : Inserts/Update the JTF_RS_GROUP_DENORM_PVT table based on changes in jtf_rs_group_relations
6: -- Modification History
7: -- DATE NAME PURPOSE

Line 5: -- Purpose : Inserts/Update the JTF_RS_GROUP_DENORM_PVT table based on changes in jtf_rs_group_relations

1: PACKAGE body JTF_RS_GROUP_DENORM_PVT AS
2: /* $Header: jtfrsvdb.pls 120.1 2005/06/13 21:15:33 baianand ship $ */
3: -- API Name : JTF_RS_GROUP_DENORM_PVT
4: -- Type : Private
5: -- Purpose : Inserts/Update the JTF_RS_GROUP_DENORM_PVT table based on changes in jtf_rs_group_relations
6: -- Modification History
7: -- DATE NAME PURPOSE
8: -- S Choudhury Created
9: -- Notes:

Line 11: g_pkg_name varchar2(30) := 'JTF_RS_GROUP_DENORM_PVT';

7: -- DATE NAME PURPOSE
8: -- S Choudhury Created
9: -- Notes:
10: --
11: g_pkg_name varchar2(30) := 'JTF_RS_GROUP_DENORM_PVT';
12:
13: ------- USED ONLY BY "NO CONNECT BY" SECTION - BEGIN
14: TYPE REL_RECORD_TYPE IS RECORD
15: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 390: JTF_RS_GROUP_DENORM_PVT.CREATE_RES_GROUPS(

386: IF (denorm_cur%FOUND)
387: THEN
388: jtf_rs_groups_denorm_pkg.delete_row(X_DENORM_GRP_ID => l_DENORM_GRP_ID);
389:
390: JTF_RS_GROUP_DENORM_PVT.CREATE_RES_GROUPS(
391: P_API_VERSION => 1.0,
392: P_INIT_MSG_LIST => null,
393: P_COMMIT => null,
394: p_group_id => p_group_id,

Line 1358: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL,r_child.group_id, x_return_status, x_msg_count, x_msg_data);

1354:
1355: --rebuild the hiearchy of all the child records of the group
1356: FOR r_child IN c_child(p_group_id)
1357: LOOP
1358: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL,r_child.group_id, x_return_status, x_msg_count, x_msg_data);
1359: END LOOP;
1360:
1361: --rebuild the group hiearchy again
1362: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);

Line 1362: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);

1358: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL,r_child.group_id, x_return_status, x_msg_count, x_msg_data);
1359: END LOOP;
1360:
1361: --rebuild the group hiearchy again
1362: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);
1363:
1364: IF fnd_api.to_boolean (p_commit)
1365: THEN
1366: COMMIT WORK;

Line 1773: jtf_rs_group_denorm_pvt.insert_groups_parent(

1769: fetch check_parent_cur into check_parent_rec;
1770: if (check_parent_cur%found)
1771: then
1772: l_found := TRUE;
1773: jtf_rs_group_denorm_pvt.insert_groups_parent(
1774: p_api_version => 1.0,
1775: p_commit => 'T',
1776: p_group_id => l_child_tab(i).p_group_id,
1777: x_return_status => x_return_status,

Line 2457: JTF_RS_GROUP_DENORM_PVT.CREATE_RES_Groups(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);

2453: end loop;
2454:
2455:
2456: --rebuild the group hiearchy again
2457: JTF_RS_GROUP_DENORM_PVT.CREATE_RES_Groups(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);
2458:
2459: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL, p_group_id, x_return_status, x_msg_count, x_msg_data);
2460:
2461: --rebuild the hierarchy for reporting managers

Line 2459: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL, p_group_id, x_return_status, x_msg_count, x_msg_data);

2455:
2456: --rebuild the group hiearchy again
2457: JTF_RS_GROUP_DENORM_PVT.CREATE_RES_Groups(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);
2458:
2459: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL, p_group_id, x_return_status, x_msg_count, x_msg_data);
2460:
2461: --rebuild the hierarchy for reporting managers
2462:
2463: IF fnd_api.to_boolean (p_commit)

Line 3431: JTF_RS_GROUP_DENORM_PVT.Insert_Groups_No_Con(1.0,NULL, NULL,l_child_tab(i).p_group_id, x_return_status, x_msg_count, x_msg_data);

3427:
3428: --rebuild the hiearchy of all the child records of the group
3429: FOR I IN 1 .. l_child_tab.COUNT
3430: LOOP
3431: JTF_RS_GROUP_DENORM_PVT.Insert_Groups_No_Con(1.0,NULL, NULL,l_child_tab(i).p_group_id, x_return_status, x_msg_count, x_msg_data);
3432: END LOOP;
3433:
3434: --rebuild the group hiearchy again
3435: JTF_RS_GROUP_DENORM_PVT.insert_groups_no_con(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);

Line 3435: JTF_RS_GROUP_DENORM_PVT.insert_groups_no_con(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);

3431: JTF_RS_GROUP_DENORM_PVT.Insert_Groups_No_Con(1.0,NULL, NULL,l_child_tab(i).p_group_id, x_return_status, x_msg_count, x_msg_data);
3432: END LOOP;
3433:
3434: --rebuild the group hiearchy again
3435: JTF_RS_GROUP_DENORM_PVT.insert_groups_no_con(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);
3436:
3437: IF fnd_api.to_boolean (p_commit)
3438: THEN
3439: COMMIT WORK;

Line 3762: jtf_rs_group_denorm_pvt.insert_groups_parent_no_con(

3758: fetch check_parent_cur into check_parent_rec;
3759: if (check_parent_cur%found)
3760: then
3761: l_found := TRUE;
3762: jtf_rs_group_denorm_pvt.insert_groups_parent_no_con(
3763: p_api_version => 1.0,
3764: p_init_msg_list => NULL,
3765: p_commit => 'T',
3766: p_group_id => l_child_tab(i).p_group_id,

Line 4177: END JTF_RS_GROUP_DENORM_PVT;

4173: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4174: END INSERT_GROUPS_PARENT_NO_CON;
4175: ------ NO CONNECT BY - SECTION - Ends
4176:
4177: END JTF_RS_GROUP_DENORM_PVT;