DBA Data[Home] [Help]

APPS.GMO_CBR_GRP dependencies on GMO_CBR_GRP

Line 1: PACKAGE BODY GMO_CBR_GRP AS

1: PACKAGE BODY GMO_CBR_GRP AS
2: /* $Header: GMOGCBRB.pls 120.21 2006/09/22 12:29:56 rvsingh noship $ */
3:
4: PROCEDURE ENABLE_CBR (ERRBUF OUT NOCOPY VARCHAR2,RETCODE OUT NOCOPY VARCHAR2) IS
5: -- Local Variables

Line 29: and b.RULE_FUNCTION in ('GMO_CBR_GRP.PROCESS_EVENT','GMO_CBR_GRP.PROCESS_INSTANCE_INSTR_SET');

25: FROM
26: wf_events_vl a,
27: wf_event_subscriptions b
28: WHERE a.GUID = b.EVENT_FILTER_GUID
29: and b.RULE_FUNCTION in ('GMO_CBR_GRP.PROCESS_EVENT','GMO_CBR_GRP.PROCESS_INSTANCE_INSTR_SET');
30:
31: --
32: -- ERES event subscriptions owned by product teams where GMO subscription exists
33: --

Line 989: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

985: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
986: END IF;
987: l_batch_prog_rec.XML_MAP_CODE := l_map_code;
988: l_batch_prog_rec.compare_xml:=l_compare_XML;
989: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
990: wf_event.AddParameterToList('BATCH_PROGRESSION_ID', l_batch_progression_id,p_event.Parameter_List);
991: return 'SUCCESS';
992: END;
993:

Line 1053: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1049: l_batch_prog_rec.ERECORD_ID := NULL;
1050: l_batch_prog_rec.XML_EREC := NULL;
1051: l_batch_prog_rec.STATUS := 'PENDING';
1052: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1053: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1054: OPEN GET_STEP_DETAILS ;
1055: LOOP
1056: FETCH GET_STEP_DETAILS INTO STEP_DETAILS_REC;
1057: EXIT WHEN GET_STEP_DETAILS%NOTFOUND;

Line 1090: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1086: l_batch_prog_rec.ERECORD_ID := NULL;
1087: l_batch_prog_rec.XML_EREC := NULL;
1088: l_batch_prog_rec.STATUS := 'PENDING';
1089: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1090: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1091: l_batch_prog_rec.PROGRESSION_ID := NULL;
1092: l_batch_prog_rec.BATCH_ID := P_BATCH_ID;
1093: l_batch_prog_rec.BATCHSTEP_ID := STEP_DETAILS_REC.BATCHSTEP_ID;
1094: l_batch_prog_rec.MATERIAL_LINE_ID := NULL;

Line 1120: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1116: l_batch_prog_rec.ERECORD_ID := NULL;
1117: l_batch_prog_rec.XML_EREC := NULL;
1118: l_batch_prog_rec.STATUS := 'PENDING';
1119: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1120: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1121: l_batch_prog_rec.PROGRESSION_ID := NULL;
1122: l_batch_prog_rec.BATCH_ID := P_BATCH_ID;
1123: l_batch_prog_rec.BATCHSTEP_ID := STEP_DETAILS_REC.BATCHSTEP_ID;
1124: l_batch_prog_rec.MATERIAL_LINE_ID := NULL;

Line 1150: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1146: l_batch_prog_rec.ERECORD_ID := NULL;
1147: l_batch_prog_rec.XML_EREC := NULL;
1148: l_batch_prog_rec.STATUS := 'PENDING';
1149: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1150: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1151: END LOOP;
1152: CLOSE GET_STEP_DETAILS;
1153: l_batch_prog_rec.PROGRESSION_ID := NULL;
1154: l_batch_prog_rec.BATCH_ID := P_BATCH_ID;

Line 1182: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1178: l_batch_prog_rec.ERECORD_ID := NULL;
1179: l_batch_prog_rec.XML_EREC := NULL;
1180: l_batch_prog_rec.STATUS := 'PENDING';
1181: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1182: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1183: l_batch_prog_rec.PROGRESSION_ID := NULL;
1184: l_batch_prog_rec.BATCH_ID := P_BATCH_ID;
1185: l_batch_prog_rec.BATCHSTEP_ID := NULL;
1186: l_batch_prog_rec.MATERIAL_LINE_ID := NULL;

Line 1213: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1209: l_batch_prog_rec.XML_EREC := NULL;
1210: l_batch_prog_rec.STATUS := 'PENDING';
1211: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1212: l_batch_prog_rec.compare_xml:='N';
1213: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: null;
1217: END;

Line 1532: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1528: l_batch_prog_rec.XML_EREC := l_event_data;
1529: l_batch_prog_rec.STATUS := P_BATCHPROGRESSION_STATUS;
1530: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1531: l_batch_prog_rec.COMPARE_XML := 'N';
1532: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1533:
1534: EXCEPTION
1535: WHEN OTHERS THEN
1536: FND_MESSAGE.SET_NAME('GMO','FND_AS_UNEXPECTED_ERROR');

Line 1542: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.GMO_CBR_GRP.PROCESS_INSTR_XML', FALSE);

1538: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1539: FND_MSG_PUB.ADD;
1540: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count, p_data => l_msg_data);
1541: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1542: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.GMO_CBR_GRP.PROCESS_INSTR_XML', FALSE);
1543: end if;
1544: END PROCESS_INSTR_XML;
1545:
1546: FUNCTION PROCESS_INSTANCE_INSTR_SET(P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS

Line 1644: 'gmo.plsql.GMO_CBR_GRP.DELETE_PROGRESSION_ROW',

1640: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1641: X_RETURN_STATUS := 'E';
1642: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1643: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1644: 'gmo.plsql.GMO_CBR_GRP.DELETE_PROGRESSION_ROW',
1645: FALSE
1646: );
1647: end if;
1648: END IF;

Line 1654: END GMO_CBR_GRP;

1650: END DELETE_PROGRESSION_ROW;
1651:
1652:
1653:
1654: END GMO_CBR_GRP;