APPS.AS_RESOURCE_MERGE_PUB dependencies on AS_RESOURCE_MERGE_PUB

Line 1: PACKAGE BODY AS_RESOURCE_MERGE_PUB as

1: PACKAGE BODY AS_RESOURCE_MERGE_PUB as
2: /* $Header: asxrsmrb.pls 120.2 2005/12/22 22:53:57 subabu noship $ */
3:
4: -- Start of Comments
5: -- Package name : AS_RESOURCE_MERGE_PUB

Line 5: -- Package name : AS_RESOURCE_MERGE_PUB

1: PACKAGE BODY AS_RESOURCE_MERGE_PUB as
2: /* $Header: asxrsmrb.pls 120.2 2005/12/22 22:53:57 subabu noship $ */
3:
4: -- Start of Comments
5: -- Package name : AS_RESOURCE_MERGE_PUB
6: --
7: -- Purpose : This package should be called in event subscription of
8: -- event oracle.apps.jtf.jres.resource.update.effectdate.
9: -- It will update the salesforce_id(resource_id) column in AS

Line 211: WF_CORE.CONTEXT('AS_RESOURCE_MERGE_PUB', 'update_resource_enddate',

207: return 'SUCCESS';
208:
209: EXCEPTION
210: WHEN OTHERS THEN
211: WF_CORE.CONTEXT('AS_RESOURCE_MERGE_PUB', 'update_resource_enddate',
212: p_event.getEventName(), p_subscription_guid);
213: WF_EVENT.setErrorInfo(p_event, 'ERROR');
214: UTL_FILE.PUT_LINE(l_file_ptr, 'Error number ' || to_char(SQLCODE));
215: UTL_FILE.PUT_LINE(l_file_ptr, 'Error message ' || SQLERRM);

Line 222: END AS_RESOURCE_MERGE_PUB;

218:
219: RETURN 'ERROR';
220: END update_resource_enddate;
221:
222: END AS_RESOURCE_MERGE_PUB;