DBA Data[Home] [Help]

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.13.12010000.2 2008/09/17 08:05:36 srgnanas 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 781: P_EVENT_REC out nocopy ota_evt_shd.g_rec_type,

777: -- complete event row.
778: --
779: procedure GET_EVENT_DETAILS (
780: P_EVENT_ID number,
781: P_EVENT_REC out nocopy ota_evt_shd.g_rec_type,
782: P_EVENT_EXISTS out nocopy boolean
783: ) is
784: --
785: W_PROC varchar2 (72)

Line 824: OTA_EVT_SHD.FETCH_EVENT_DETAILS (

820: P_API_NAME => G_PACKAGE,
821: P_ARGUMENT => 'P_EVENT_ID',
822: P_ARGUMENT_VALUE => P_EVENT_ID);
823: --
824: OTA_EVT_SHD.FETCH_EVENT_DETAILS (
825: P_EVENT_ID => P_EVENT_ID,
826: P_EVENT_EXISTS => W_EVENT_EXISTS);
827: --
828: if W_EVENT_EXISTS then

Line 1013: end ota_evt_shd;

1009: return (W_TOTAL);
1010: --
1011: end INVOICED_AMOUNT_TOTAL;
1012: --
1013: end ota_evt_shd;