DBA Data[Home] [Help]

APPS.GCS_CONS_IMPACT_ANALYSIS_PKG dependencies on WF_EVENT

Line 759: p_event in out nocopy wf_event_t)

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;

Line 828: l_load_id := TO_NUMBER(WF_EVENT.getValueForParameter('LOAD_ID',

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:

Line 830: l_ledger_id := TO_NUMBER(WF_EVENT.getValueForParameter('LEDGER_ID',

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,

Line 961: p_event in out nocopy wf_event_t)

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:

Line 994: l_change_type_code := WF_EVENT.getValueForParameter('CHANGE_TYPE_CODE',

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',

Line 996: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('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:

Line 998: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',

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,

Line 1148: p_event in out nocopy wf_event_t)

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);

Line 1177: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTRY_ID',

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:

Line 1179: l_orig_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ORIG_ENTRY_ID',

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,

Line 1281: p_event in out nocopy wf_event_t)

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;

Line 1344: l_from_currency := WF_EVENT.getValueForParameter('FROM_CURRENCY',

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',

Line 1346: l_to_currency := WF_EVENT.getValueForParameter('TO_CURRENCY',

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');

Line 1348: l_from_conversion_date := TO_DATE(WF_EVENT.getValueForParameter('FROM_CONVERSION_DATE',

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),

Line 1351: l_to_conversion_date := TO_DATE(NVL(WF_EVENT.getValueForParameter('TO_CONVERSION_DATE',

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');

Line 1356: l_conversion_type := WF_EVENT.getValueForParameter('CONVERSION_TYPE',

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,

Line 1419: p_event in out nocopy wf_event_t)

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:

Line 1442: l_cal_period_id := TO_NUMBER(WF_EVENT.getValueForParameter('PERIOD_ID',

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',

Line 1444: l_entity_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTITY_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:

Line 1446: l_hierarchy_id := TO_NUMBER(WF_EVENT.getValueForParameter('HIERARCHY_ID',

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,

Line 1858: p_event in out nocopy wf_event_t)

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);

Line 1886: l_entry_id := TO_NUMBER(WF_EVENT.getValueForParameter('ENTRY_ID',

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,