DBA Data[Home] [Help]

APPS.OKL_TRX_ASSETS_PUB dependencies on OKC_API

Line 9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

5: subtype thpv_tbl_type is okl_trx_assets_pvt.tavv_tbl_type;
6:
7:
8: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

6:
7:
8: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';

Line 11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

7:
8: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';

Line 12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

8: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
10: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
11: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16:

Line 19: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

15: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16:
17: -- Global variables for user hooks
18: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRX_ASSETS_PUB';
19: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
20: g_thpv_rec thpv_rec_type;
21: g_thpv_tbl thpv_tbl_type;
22:
23:

Line 26: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

22:
23:
24: PROCEDURE create_trx_ass_h_def(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: p_thpv_rec IN thpv_rec_type,

Line 35: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

31: x_thpv_rec OUT NOCOPY thpv_rec_type);
32:
33: PROCEDURE create_trx_ass_h_def(
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36: x_return_status OUT NOCOPY VARCHAR2,
37: x_msg_count OUT NOCOPY NUMBER,
38: x_msg_data OUT NOCOPY VARCHAR2,
39: p_thpv_tbl IN thpv_tbl_type,

Line 45: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

41:
42:
43: PROCEDURE update_trx_ass_h_def(
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: p_thpv_rec IN thpv_rec_type,

Line 54: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

50: x_thpv_rec OUT NOCOPY thpv_rec_type);
51:
52: PROCEDURE update_trx_ass_h_def(
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2,
58: p_thpv_tbl IN thpv_tbl_type,

Line 63: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

59: x_thpv_tbl OUT NOCOPY thpv_tbl_type);
60:
61: PROCEDURE delete_trx_ass_h_def(
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_thpv_rec IN thpv_rec_type);

Line 71: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

67: p_thpv_rec IN thpv_rec_type);
68:
69: PROCEDURE delete_trx_ass_h_def(
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: p_thpv_tbl IN thpv_tbl_type);

Line 79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

75: p_thpv_tbl IN thpv_tbl_type);
76:
77: PROCEDURE lock_trx_ass_h_def(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: p_thpv_rec IN thpv_rec_type);

Line 87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

83: p_thpv_rec IN thpv_rec_type);
84:
85: procedure lock_trx_ass_h_def(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_thpv_tbl IN thpv_tbl_type);

Line 95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

91: p_thpv_tbl IN thpv_tbl_type);
92:
93: PROCEDURE validate_trx_ass_h_def(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: p_thpv_rec IN thpv_rec_type);

Line 103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

99: p_thpv_rec IN thpv_rec_type);
100:
101: procedure validate_trx_ass_h_def(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_thpv_tbl IN thpv_tbl_type);