[Home] [Help]
177:
178: -- Launch the Workflow
179: fnd_file.put_line(fnd_file.log, 'Launching Workflow');
180: --Bugfix 5197891: Pass the corrrect owner rather than null value for workflow
181: WF_ENGINE.CreateProcess('DATASUB',
182: l_event_key,
183: 'GCSDATASUB',
184: l_event_key,
185: FND_GLOBAL.USER_NAME);
182: l_event_key,
183: 'GCSDATASUB',
184: l_event_key,
185: FND_GLOBAL.USER_NAME);
186: WF_ENGINE.SetItemAttrNumber('DATASUB',
187: l_event_key,
188: 'LOAD_ID',
189: p_load_id);
190: WF_ENGINE.StartProcess('DATASUB', l_event_key);
186: WF_ENGINE.SetItemAttrNumber('DATASUB',
187: l_event_key,
188: 'LOAD_ID',
189: p_load_id);
190: WF_ENGINE.StartProcess('DATASUB', l_event_key);
191:
192: SELECT status_code
193: INTO l_status_code
194: FROM gcs_data_sub_dtls
1592: g_api || '.CHECK_IDT_REQUIRED.begin',
1593: '<
1594: END IF;
1595:
1596: get_datasub_dtls(p_load_id => WF_ENGINE.GetItemAttrNumber(p_itemtype,
1597: p_itemkey,
1598: 'LOAD_ID',
1599: FALSE),
1600: p_datasub_info => l_datasub_info);
1629: g_api || '.EXECUTE_IDT.begin',
1630: '<
1631: END IF;
1632:
1633: get_datasub_dtls(p_load_id => WF_ENGINE.GetItemAttrNumber(p_itemtype,
1634: p_itemkey,
1635: 'LOAD_ID',
1636: FALSE),
1637: p_datasub_info => l_datasub_info);
1673: g_api || '.CHECK_VALIDATION_REQUIRED.begin',
1674: '<
1675: END IF;
1676:
1677: get_datasub_dtls(p_load_id => WF_ENGINE.GetItemAttrNumber(p_itemtype,
1678: p_itemkey,
1679: 'LOAD_ID',
1680: FALSE),
1681: p_datasub_info => l_datasub_info);
1710: g_api || '.EXECUTE_VALIDATION.begin',
1711: '<
1712: END IF;
1713:
1714: get_datasub_dtls(p_load_id => WF_ENGINE.GetItemAttrNumber(p_itemtype,
1715: p_itemkey,
1716: 'LOAD_ID',
1717: FALSE),
1718: p_datasub_info => l_datasub_info);
1758: g_api || '.INIT_DATASUB_PROCESS.begin',
1759: '<
1760: END IF;
1761:
1762: get_datasub_dtls(p_load_id => WF_ENGINE.GetItemAttrNumber(p_itemtype,
1763: p_itemkey,
1764: 'LOAD_ID',
1765: FALSE),
1766: p_datasub_info => l_datasub_info);
1824: WHEN NO_DATA_FOUND THEN
1825: l_execution_mode := 'S';
1826: END;
1827:
1828: WF_ENGINE.SetItemAttrText(p_itemtype,
1829: p_itemkey,
1830: 'CURRENCYTYPE',
1831: l_currency_type_code);
1832: WF_ENGINE.SetItemAttrText(p_itemtype,
1828: WF_ENGINE.SetItemAttrText(p_itemtype,
1829: p_itemkey,
1830: 'CURRENCYTYPE',
1831: l_currency_type_code);
1832: WF_ENGINE.SetItemAttrText(p_itemtype,
1833: p_itemkey,
1834: 'FIRSTEVERPERIOD',
1835: l_first_ever_loaded);
1836: WF_ENGINE.SetItemAttrText(p_itemtype,
1832: WF_ENGINE.SetItemAttrText(p_itemtype,
1833: p_itemkey,
1834: 'FIRSTEVERPERIOD',
1835: l_first_ever_loaded);
1836: WF_ENGINE.SetItemAttrText(p_itemtype,
1837: p_itemkey,
1838: 'FUNCCURRENCYCODE',
1839: l_func_crncy_code);
1840: WF_ENGINE.SetItemAttrNumber(p_itemtype,
1836: WF_ENGINE.SetItemAttrText(p_itemtype,
1837: p_itemkey,
1838: 'FUNCCURRENCYCODE',
1839: l_func_crncy_code);
1840: WF_ENGINE.SetItemAttrNumber(p_itemtype,
1841: p_itemkey,
1842: 'LEDGERID',
1843: l_datasub_info.ledger_id);
1844: WF_ENGINE.SetItemAttrText(p_itemtype,
1840: WF_ENGINE.SetItemAttrNumber(p_itemtype,
1841: p_itemkey,
1842: 'LEDGERID',
1843: l_datasub_info.ledger_id);
1844: WF_ENGINE.SetItemAttrText(p_itemtype,
1845: p_itemkey,
1846: 'CALPERIODID',
1847: l_datasub_info.cal_period_id);
1848: WF_ENGINE.SetItemAttrText(p_itemtype,
1844: WF_ENGINE.SetItemAttrText(p_itemtype,
1845: p_itemkey,
1846: 'CALPERIODID',
1847: l_datasub_info.cal_period_id);
1848: WF_ENGINE.SetItemAttrText(p_itemtype,
1849: p_itemkey,
1850: 'EXECUTIONMODE',
1851: l_execution_mode);
1852:
1878: g_api || '.UPDATE_AMOUNTS.begin',
1879: '<
1880: END IF;
1881:
1882: l_currency_type_code := WF_ENGINE.GetItemAttrText(p_itemtype,
1883: p_itemkey,
1884: 'CURRENCYTYPE',
1885: FALSE);
1886: l_first_ever_loaded := WF_ENGINE.GetItemAttrText(p_itemtype,
1882: l_currency_type_code := WF_ENGINE.GetItemAttrText(p_itemtype,
1883: p_itemkey,
1884: 'CURRENCYTYPE',
1885: FALSE);
1886: l_first_ever_loaded := WF_ENGINE.GetItemAttrText(p_itemtype,
1887: p_itemkey,
1888: 'FIRSTEVERPERIOD',
1889: FALSE);
1890:
1887: p_itemkey,
1888: 'FIRSTEVERPERIOD',
1889: FALSE);
1890:
1891: get_datasub_dtls(p_load_id => WF_ENGINE.GetItemAttrNumber(p_itemtype,
1892: p_itemkey,
1893: 'LOAD_ID',
1894: FALSE),
1895: p_datasub_info => l_datasub_info);
1983: g_api || '.TRANSFER_DATA_TO_INTERFACE.begin',
1984: '<
1985: END IF;
1986:
1987: l_currency_type_code := WF_ENGINE.GetItemAttrText(p_itemtype,
1988: p_itemkey,
1989: 'CURRENCYTYPE',
1990: FALSE);
1991:
1988: p_itemkey,
1989: 'CURRENCYTYPE',
1990: FALSE);
1991:
1992: get_datasub_dtls(p_load_id => WF_ENGINE.GetItemAttrNumber(p_itemtype,
1993: p_itemkey,
1994: 'LOAD_ID',
1995: FALSE),
1996: p_datasub_info => l_datasub_info);
1997:
1998: --Bugfix 4969879: Remove calls to get_reference_data_info
1999:
2000: --Initialize Workflow Attributes for Dataset Code and Object Id
2001: WF_ENGINE.SetItemAttrText(p_itemtype,
2002: p_itemkey,
2003: 'DATASETCODE',
2004: l_datasub_info.dataset_code);
2005: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'XGLOBJECTID', '1000');
2001: WF_ENGINE.SetItemAttrText(p_itemtype,
2002: p_itemkey,
2003: 'DATASETCODE',
2004: l_datasub_info.dataset_code);
2005: WF_ENGINE.SetItemAttrText(p_itemtype, p_itemkey, 'XGLOBJECTID', '1000');
2006:
2007: SELECT fdgb.dimension_group_display_code,
2008: fcpa_end_date.date_assign_value,
2009: fcpa_period_num.number_assign_value
2238: g_api || '.VALIDATE_MEMBER_VALUES.begin',
2239: '<
2240: END IF;
2241:
2242: get_datasub_dtls(p_load_id => WF_ENGINE.GetItemAttrNumber(p_itemtype,
2243: p_itemkey,
2244: 'LOAD_ID',
2245: FALSE),
2246: p_datasub_info => l_datasub_info);