APPS.OTA_EVT_SHD dependencies on OTA_EVT_SHD

Line 1: PACKAGE BODY OTA_EVT_SHD as

1: PACKAGE BODY OTA_EVT_SHD as
2: /* $Header: otevt01t.pkb 120.19 2011/04/07 13:34:40 shwnayak ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_evt_shd.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_evt_shd.'; -- Global package name
9: --
10: -- Working records within procedures
11: --
12: G_FETCHED_REC ota_evt_shd.g_rec_type;

Line 12: G_FETCHED_REC ota_evt_shd.g_rec_type;

8: g_package varchar2(33) := ' ota_evt_shd.'; -- Global package name
9: --
10: -- Working records within procedures
11: --
12: G_FETCHED_REC ota_evt_shd.g_rec_type;
13: G_NULL_REC ota_evt_shd.g_rec_type;
14: --
15: -- ----------------------------------------------------------------------------
16: -- |------------------------< return_api_dml_status >-------------------------|

Line 13: G_NULL_REC ota_evt_shd.g_rec_type;

9: --
10: -- Working records within procedures
11: --
12: G_FETCHED_REC ota_evt_shd.g_rec_type;
13: G_NULL_REC ota_evt_shd.g_rec_type;
14: --
15: -- ----------------------------------------------------------------------------
16: -- |------------------------< return_api_dml_status >-------------------------|
17: -- ----------------------------------------------------------------------------

Line 786: P_EVENT_REC out nocopy ota_evt_shd.g_rec_type,

782: -- complete event row.
783: --
784: procedure GET_EVENT_DETAILS (
785: P_EVENT_ID number,
786: P_EVENT_REC out nocopy ota_evt_shd.g_rec_type,
787: P_EVENT_EXISTS out nocopy boolean
788: ) is
789: --
790: W_PROC varchar2 (72)

Line 829: OTA_EVT_SHD.FETCH_EVENT_DETAILS (

825: P_API_NAME => G_PACKAGE,
826: P_ARGUMENT => 'P_EVENT_ID',
827: P_ARGUMENT_VALUE => P_EVENT_ID);
828: --
829: OTA_EVT_SHD.FETCH_EVENT_DETAILS (
830: P_EVENT_ID => P_EVENT_ID,
831: P_EVENT_EXISTS => W_EVENT_EXISTS);
832: --
833: if W_EVENT_EXISTS then

Line 1018: end ota_evt_shd;

1014: return (W_TOTAL);
1015: --
1016: end INVOICED_AMOUNT_TOTAL;
1017: --
1018: end ota_evt_shd;