DBA Data[Home] [Help]

APPS.OKC_PDP_PVT dependencies on OKC_PROCESS_DEF_PARAMETERS_V

Line 45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,

41: INDEX BY BINARY_INTEGER;
42: TYPE pdpv_rec_type IS RECORD (
43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,

43: id NUMBER := OKC_API.G_MISS_NUM,
44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,

44: object_version_number NUMBER := OKC_API.G_MISS_NUM,
45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

Line 49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,

45: sfwt_flag OKC_PROCESS_DEF_PARAMETERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,

Line 50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,

46: pdf_id NUMBER := OKC_API.G_MISS_NUM,
47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,

Line 51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,

47: name OKC_PROCESS_DEF_PARAMETERS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,

48: user_name OKC_PROCESS_DEF_PARAMETERS_V.USER_NAME%TYPE := OKC_API.G_MISS_CHAR,
49: data_type OKC_PROCESS_DEF_PARAMETERS_V.DATA_TYPE%TYPE := OKC_API.G_MISS_CHAR,
50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,

50: default_value OKC_PROCESS_DEF_PARAMETERS_V.DEFAULT_VALUE%TYPE := OKC_API.G_MISS_CHAR,
51: required_yn OKC_PROCESS_DEF_PARAMETERS_V.REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

52: description OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
53: application_id NUMBER := OKC_API.G_MISS_NUM,
54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

54: seeded_flag OKC_PROCESS_DEF_PARAMETERS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
62: description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);

Line 60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,

56: creation_date OKC_PROCESS_DEF_PARAMETERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
62: description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
63: g_miss_pdpv_rec pdpv_rec_type;
64: TYPE pdpv_tbl_type IS TABLE OF pdpv_rec_type

Line 61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,

57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
62: description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
63: g_miss_pdpv_rec pdpv_rec_type;
64: TYPE pdpv_tbl_type IS TABLE OF pdpv_rec_type
65: INDEX BY BINARY_INTEGER;

Line 62: description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);

58: last_update_date OKC_PROCESS_DEF_PARAMETERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM,
60: jtot_object_code OKC_PROCESS_DEF_PARAMETERS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: NAME_COLUMN OKC_PROCESS_DEF_PARAMETERS_V.NAME_COLUMN%TYPE := OKC_API.G_MISS_CHAR,
62: description_column OKC_PROCESS_DEF_PARAMETERS_V.DESCRIPTION_COLUMN%TYPE := OKC_API.G_MISS_CHAR);
63: g_miss_pdpv_rec pdpv_rec_type;
64: TYPE pdpv_tbl_type IS TABLE OF pdpv_rec_type
65: INDEX BY BINARY_INTEGER;
66: ---------------------------------------------------------------------------

Line 89: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_PROCESS_DEF_PARAMETERS_V';

85: -- GLOBAL VARIABLES
86: ---------------------------------------------------------------------------
87: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PDP_PVT';
88: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
89: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_PROCESS_DEF_PARAMETERS_V';
90: ---------------------------------------------------------------------------
91: -- GLOBAL EXCEPTION
92: ---------------------------------------------------------------------------
93: G_EXCEPTION_HALT_VALIDATION EXCEPTION;