[Home] [Help]
421: l_names_out_tbl(i) := G_OWNER_ID;
422: --decode can only be used in SQL stmt
423: SELECT Decode (l_owner_id, null, '', To_char(l_owner_id))
424: INTO l_values_out_tbl(i)
425: FROM dual;
426:
427: i := i+1;
428: l_names_out_tbl(i) := G_OWNER_NAME;
429: l_values_out_tbl(i) := Nvl(l_owner_name,'');
435: i := i+1;
436: l_names_out_tbl(i) := G_GROUP_ID;
437: SELECT Decode (l_group_id, null, '', To_char(l_group_id))
438: INTO l_values_out_tbl(i)
439: FROM dual;
440:
441: i := i+1;
442: l_names_out_tbl(i) := G_GROUP_NAME;
443: l_values_out_tbl(i) := Nvl(l_group_name,'');
445: i := i+1;
446: l_names_out_tbl(i) := G_MEMBER_ID;
447: SELECT Decode (l_member_id, null, '', To_char(l_member_id))
448: INTO l_values_out_tbl(i)
449: FROM dual;
450:
451: i := i+1;
452: l_names_out_tbl(i) := G_MEMBER_NAME;
453: l_values_out_tbl(i) := Nvl(l_member_name,'');
459: i := i+1;
460: l_names_out_tbl(i) := G_GROUP_MEMBER_REL_ID;
461: SELECT Decode (l_group_member_rel_id, null, '', To_char(l_group_member_rel_id))
462: INTO l_values_out_tbl(i)
463: FROM dual;
464:
465: i := i+1;
466: l_names_out_tbl(i) := G_NOTE;
467: l_values_out_tbl(i) := Nvl(l_note,'');
941: l_xml_str VARCHAR2(32767);
942:
943: CURSOR get_item_key_id_c IS
944: SELECT EGO_GROUP_WF_MGMT_S.NEXTVAL
945: FROM dual;
946: --
947: -- Removed as the owner is now obtained from fnd_grants
948: --
949: -- CURSOR c_get_owner_name(cp_group_id NUMBER) IS
1169: l_xml_str VARCHAR2(32767);
1170:
1171: CURSOR get_item_key_id_c IS
1172: SELECT EGO_GROUP_WF_MGMT_S.NEXTVAL
1173: FROM dual;
1174:
1175: BEGIN
1176: mdebug (' EGO_GROUP_WF_PKG.Start_Delete_Group_Process ');
1177: mdebug('1');
1260: l_item_key VARCHAR2(30);
1261:
1262: CURSOR get_item_key_id_c IS
1263: SELECT EGO_GROUP_WF_MGMT_S.NEXTVAL
1264: FROM dual;
1265:
1266: BEGIN
1267:
1268: OPEN get_item_key_id_c;
1318: l_item_key VARCHAR2(30);
1319:
1320: CURSOR get_item_key_id_c IS
1321: SELECT EGO_GROUP_WF_MGMT_S.NEXTVAL
1322: FROM dual;
1323:
1324: BEGIN
1325:
1326: OPEN get_item_key_id_c;