DBA Data[Home] [Help]

APPS.OKC_SAC_PVT dependencies on OKC_STD_ART_CLASSINGS_V

Line 23: sat_code OKC_STD_ART_CLASSINGS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,

19: INDEX BY BINARY_INTEGER;
20: TYPE sacv_rec_type IS RECORD (
21: id NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: sat_code OKC_STD_ART_CLASSINGS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: price_type OKC_STD_ART_CLASSINGS_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: scs_code OKC_STD_ART_CLASSINGS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_STD_ART_CLASSINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 24: price_type OKC_STD_ART_CLASSINGS_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,

20: TYPE sacv_rec_type IS RECORD (
21: id NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: sat_code OKC_STD_ART_CLASSINGS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: price_type OKC_STD_ART_CLASSINGS_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: scs_code OKC_STD_ART_CLASSINGS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_STD_ART_CLASSINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 25: scs_code OKC_STD_ART_CLASSINGS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,

21: id NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: sat_code OKC_STD_ART_CLASSINGS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: price_type OKC_STD_ART_CLASSINGS_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: scs_code OKC_STD_ART_CLASSINGS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_STD_ART_CLASSINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_STD_ART_CLASSINGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 27: creation_date OKC_STD_ART_CLASSINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

23: sat_code OKC_STD_ART_CLASSINGS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: price_type OKC_STD_ART_CLASSINGS_V.PRICE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: scs_code OKC_STD_ART_CLASSINGS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_STD_ART_CLASSINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_STD_ART_CLASSINGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM);
31: g_miss_sacv_rec sacv_rec_type;

Line 29: last_update_date OKC_STD_ART_CLASSINGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

25: scs_code OKC_STD_ART_CLASSINGS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_STD_ART_CLASSINGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_STD_ART_CLASSINGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: last_update_login NUMBER := OKC_API.G_MISS_NUM);
31: g_miss_sacv_rec sacv_rec_type;
32: TYPE sacv_tbl_type IS TABLE OF sacv_rec_type
33: INDEX BY BINARY_INTEGER;

Line 64: G_VIEW CONSTANT varchar2(30) := 'OKC_STD_ART_CLASSINGS_V';

60: G_EITHER_NOTNULL CONSTANT varchar2(200) := 'OKC_POPULATE_ONE';
61: G_LEN_CHK CONSTANT varchar2(200) := 'OKC_LENGTH_EXCEEDS';
62:
63: --GLOBAL VARIABLES
64: G_VIEW CONSTANT varchar2(30) := 'OKC_STD_ART_CLASSINGS_V';
65: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
66:
67:
68: --------------------------------------------------------------------------------