755: RETURN 'SUCCESS';
756: END hierarchy_altered;
757:
758: FUNCTION data_sub_load_executed(p_subscription_guid in raw,
759: p_event in out nocopy wf_event_t)
760: RETURN VARCHAR2
761:
762: IS
763: l_parameter_list wf_parameter_list_t;
824: '<
825: END IF;
826:
827: l_parameter_list := p_event.getParameterList();
828: l_load_id := TO_NUMBER(WF_EVENT.getValueForParameter('LOAD_ID',
829: l_parameter_list));
830: l_ledger_id := TO_NUMBER(WF_EVENT.getValueForParameter('LEDGER_ID',
831: l_parameter_list));
832:
826:
827: l_parameter_list := p_event.getParameterList();
828: l_load_id := TO_NUMBER(WF_EVENT.getValueForParameter('LOAD_ID',
829: l_parameter_list));
830: l_ledger_id := TO_NUMBER(WF_EVENT.getValueForParameter('LEDGER_ID',
831: l_parameter_list));
832:
833: SELECT gdsd.entity_id,
834: gdsd.cal_period_id,
957: RETURN 'SUCCESS';
958: END data_sub_load_executed;
959:
960: FUNCTION acqdisp_altered(p_subscription_guid in raw,
961: p_event in out nocopy wf_event_t)
962: RETURN VARCHAR2
963:
964: IS
965:
990: '<
991: END IF;
992:
993: l_parameter_list := p_event.getParameterList();
994: l_change_type_code := WF_EVENT.getValueForParameter('CHANGE_TYPE_CODE',
995: l_parameter_list);
996: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTRY_ID',
997: l_parameter_list));
998: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',
992:
993: l_parameter_list := p_event.getParameterList();
994: l_change_type_code := WF_EVENT.getValueForParameter('CHANGE_TYPE_CODE',
995: l_parameter_list);
996: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTRY_ID',
997: l_parameter_list));
998: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',
999: l_parameter_list));
1000:
994: l_change_type_code := WF_EVENT.getValueForParameter('CHANGE_TYPE_CODE',
995: l_parameter_list);
996: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTRY_ID',
997: l_parameter_list));
998: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',
999: l_parameter_list));
1000:
1001: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1002: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1144: RETURN 'SUCCESS';
1145: END acqdisp_altered;
1146:
1147: FUNCTION adjustment_altered(p_subscription_guid in raw,
1148: p_event in out nocopy wf_event_t)
1149: RETURN VARCHAR2
1150:
1151: IS
1152: l_entry_id NUMBER(15);
1173: END IF;
1174:
1175: l_parameter_list := p_event.getParameterList();
1176:
1177: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTRY_ID',
1178: l_parameter_list));
1179: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',
1180: l_parameter_list));
1181:
1175: l_parameter_list := p_event.getParameterList();
1176:
1177: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTRY_ID',
1178: l_parameter_list));
1179: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',
1180: l_parameter_list));
1181:
1182: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1277: RETURN 'SUCCESS';
1278: END adjustment_altered;
1279:
1280: FUNCTION daily_rates_altered(p_subscription_guid in raw,
1281: p_event in out nocopy wf_event_t)
1282: RETURN VARCHAR2
1283:
1284: IS
1285: l_parameter_list wf_parameter_list_t;
1340: END IF;
1341:
1342: l_parameter_list := p_event.getParameterList();
1343:
1344: l_from_currency := WF_EVENT.getValueForParameter('FROM_CURRENCY',
1345: l_parameter_list);
1346: l_to_currency := WF_EVENT.getValueForParameter('TO_CURRENCY',
1347: l_parameter_list);
1348: l_from_conversion_date := TO_DATE(WF_EVENT.getValueForParameter('FROM_CONVERSION_DATE',
1342: l_parameter_list := p_event.getParameterList();
1343:
1344: l_from_currency := WF_EVENT.getValueForParameter('FROM_CURRENCY',
1345: l_parameter_list);
1346: l_to_currency := WF_EVENT.getValueForParameter('TO_CURRENCY',
1347: l_parameter_list);
1348: l_from_conversion_date := TO_DATE(WF_EVENT.getValueForParameter('FROM_CONVERSION_DATE',
1349: l_parameter_list),
1350: 'YYYY/MM/DD');
1344: l_from_currency := WF_EVENT.getValueForParameter('FROM_CURRENCY',
1345: l_parameter_list);
1346: l_to_currency := WF_EVENT.getValueForParameter('TO_CURRENCY',
1347: l_parameter_list);
1348: l_from_conversion_date := TO_DATE(WF_EVENT.getValueForParameter('FROM_CONVERSION_DATE',
1349: l_parameter_list),
1350: 'YYYY/MM/DD');
1351: l_to_conversion_date := TO_DATE(NVL(WF_EVENT.getValueForParameter('TO_CONVERSION_DATE',
1352: l_parameter_list),
1347: l_parameter_list);
1348: l_from_conversion_date := TO_DATE(WF_EVENT.getValueForParameter('FROM_CONVERSION_DATE',
1349: l_parameter_list),
1350: 'YYYY/MM/DD');
1351: l_to_conversion_date := TO_DATE(NVL(WF_EVENT.getValueForParameter('TO_CONVERSION_DATE',
1352: l_parameter_list),
1353: TO_CHAR(l_from_conversion_date,
1354: 'YYYY/MM/DD')),
1355: 'YYYY/MM/DD');
1352: l_parameter_list),
1353: TO_CHAR(l_from_conversion_date,
1354: 'YYYY/MM/DD')),
1355: 'YYYY/MM/DD');
1356: l_conversion_type := WF_EVENT.getValueForParameter('CONVERSION_TYPE',
1357: l_parameter_list);
1358:
1359: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1360: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1415: RETURN 'SUCCESS';
1416: END daily_rates_altered;
1417:
1418: FUNCTION historical_rates_altered(p_subscription_guid in raw,
1419: p_event in out nocopy wf_event_t)
1420: RETURN VARCHAR2
1421:
1422: IS
1423:
1438: END IF;
1439:
1440: l_parameter_list := p_event.getParameterList();
1441:
1442: l_cal_period_id := TO_NUMBER(WF_EVENT.getValueForParameter('PERIOD_ID',
1443: l_parameter_list));
1444: l_entity_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTITY_ID',
1445: l_parameter_list));
1446: l_hierarchy_id := TO_NUMBER(WF_EVENT.getValueForParameter('HIERARCHY_ID',
1440: l_parameter_list := p_event.getParameterList();
1441:
1442: l_cal_period_id := TO_NUMBER(WF_EVENT.getValueForParameter('PERIOD_ID',
1443: l_parameter_list));
1444: l_entity_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTITY_ID',
1445: l_parameter_list));
1446: l_hierarchy_id := TO_NUMBER(WF_EVENT.getValueForParameter('HIERARCHY_ID',
1447: l_parameter_list));
1448:
1442: l_cal_period_id := TO_NUMBER(WF_EVENT.getValueForParameter('PERIOD_ID',
1443: l_parameter_list));
1444: l_entity_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTITY_ID',
1445: l_parameter_list));
1446: l_hierarchy_id := TO_NUMBER(WF_EVENT.getValueForParameter('HIERARCHY_ID',
1447: l_parameter_list));
1448:
1449: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1854: -- p_event Standard Business Event Parameter
1855: -- Notes
1856: -- Bugfix 5613302
1857: FUNCTION adjustment_disabled(p_subscription_guid in raw,
1858: p_event in out nocopy wf_event_t)
1859: RETURN VARCHAR2
1860:
1861: IS
1862: l_entry_id NUMBER(15);
1882: END IF;
1883:
1884: l_parameter_list := p_event.getParameterList();
1885:
1886: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTRY_ID',
1887: l_parameter_list));
1888:
1889: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1890: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,