1407: x_result := G_COMPLETE_STATUS;
1408: RETURN;
1409: END IF;
1410:
1411: mdebug (' AGM : Before calling EGO_PARTY_PUB.ADD_GROUP_MEMBER');
1412: EGO_PARTY_PUB.Add_Group_Member(
1413: p_api_version => 1.0,
1414: p_init_msg_list => FND_API.G_TRUE,
1415: p_commit => FND_API.G_TRUE,
1408: RETURN;
1409: END IF;
1410:
1411: mdebug (' AGM : Before calling EGO_PARTY_PUB.ADD_GROUP_MEMBER');
1412: EGO_PARTY_PUB.Add_Group_Member(
1413: p_api_version => 1.0,
1414: p_init_msg_list => FND_API.G_TRUE,
1415: p_commit => FND_API.G_TRUE,
1416: p_member_id => l_member_id,
1422: x_msg_data => l_msg_data,
1423: x_relationship_id => l_group_member_rel_id
1424: );
1425:
1426: mdebug (' AGM : Exiting out of EGO_PARTY_PUB.ADD_GROUP_MEMBER ');
1427: --store the relationship id generated, as item attribute
1428: wf_engine.SetItemAttrText( itemtype => p_item_type,
1429: itemkey => p_item_key,
1430: aname => G_GROUP_MEMBER_REL_ID,
1510: l_object_version_number := 0;
1511: END IF;
1512: CLOSE c_get_object_ver_no;
1513:
1514: mdebug(' RGMP Before calling EGO_PARTY_PUB.Remove_Group_member') ;
1515: EGO_PARTY_PUB.Remove_Group_Member(
1516: p_api_version => 1.0,
1517: p_init_msg_list => FND_API.G_TRUE,
1518: p_commit => FND_API.G_TRUE,
1511: END IF;
1512: CLOSE c_get_object_ver_no;
1513:
1514: mdebug(' RGMP Before calling EGO_PARTY_PUB.Remove_Group_member') ;
1515: EGO_PARTY_PUB.Remove_Group_Member(
1516: p_api_version => 1.0,
1517: p_init_msg_list => FND_API.G_TRUE,
1518: p_commit => FND_API.G_TRUE,
1519: p_relationship_id => l_group_member_rel_id,
1597: IF c_get_object_ver_no%NOTFOUND THEN
1598: l_object_version_number := 0;
1599: END IF;
1600: CLOSE c_get_object_ver_no;
1601: mdebug (' Calling EGO_PARTY_PUB.Delete Group ');
1602: EGO_PARTY_PUB.Delete_group
1603: (p_api_version => 1.0
1604: ,p_init_msg_list => FND_API.G_TRUE
1605: ,p_commit => FND_API.G_FALSE
1598: l_object_version_number := 0;
1599: END IF;
1600: CLOSE c_get_object_ver_no;
1601: mdebug (' Calling EGO_PARTY_PUB.Delete Group ');
1602: EGO_PARTY_PUB.Delete_group
1603: (p_api_version => 1.0
1604: ,p_init_msg_list => FND_API.G_TRUE
1605: ,p_commit => FND_API.G_FALSE
1606: ,p_group_id => l_group_id
1608: ,x_return_status => l_return_status
1609: ,x_msg_count => l_msg_count
1610: ,x_msg_data => l_msg_data
1611: );
1612: mdebug (' Exited out of EGO_PARTY_PUB.Delete Group ');
1613: x_result := G_COMPLETE_STATUS;
1614: RETURN;
1615: ELSIF (p_funcmode IN ('CANCEL', 'TIMEOUT') ) THEN
1616: x_result := G_COMPLETE_STATUS;
1819: -- CURSOR c_get_ownerid(cp_group_name VARCHAR2) IS
1820: -- SELECT grp_owner.subject_id
1821: -- FROM hz_parties grp, hz_relationships grp_owner
1822: -- WHERE grp.party_name = cp_group_name
1823: -- AND grp.application_id = EGO_PARTY_PUB.get_application_id
1824: -- AND grp.party_type = 'GROUP'
1825: -- AND grp_owner.object_id = grp.party_id
1826: -- AND grp_owner.status = 'A'
1827: -- AND SYSDATE BETWEEN grp_owner.start_date AND NVL(grp_owner.end_date, SYSDATE)