DBA Data[Home] [Help]

APPS.OKL_SIF_RET_LEVELS_PUB dependencies on OKC_API

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

7: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
9: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
10:
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SIF_RET_LEVELS_PUB';
13:
14: SUBTYPE srlv_rec_type IS Okl_srl_Pvt.okl_sif_ret_levels_v_rec_type;
15: SUBTYPE srlv_tbl_type IS Okl_srl_Pvt.okl_sif_ret_levels_v_tbl_type;

Line 21: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

17: PROCEDURE add_language;
18:
19: PROCEDURE insert_sif_ret_levels(
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
25: p_srlv_rec IN srlv_rec_type,

Line 30: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

26: x_srlv_rec OUT NOCOPY srlv_rec_type);
27:
28: PROCEDURE insert_sif_ret_levels(
29: p_api_version IN NUMBER,
30: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2,
34: p_srlv_tbl IN srlv_tbl_type,

Line 39: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

35: x_srlv_tbl OUT NOCOPY srlv_tbl_type);
36:
37: PROCEDURE lock_sif_ret_levels(
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: x_msg_data OUT NOCOPY VARCHAR2,
43: p_srlv_rec IN srlv_rec_type);

Line 47: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

43: p_srlv_rec IN srlv_rec_type);
44:
45: PROCEDURE lock_sif_ret_levels(
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,
51: p_srlv_tbl IN srlv_tbl_type);

Line 55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

51: p_srlv_tbl IN srlv_tbl_type);
52:
53: PROCEDURE update_sif_ret_levels(
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
59: p_srlv_rec IN srlv_rec_type,

Line 64: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

60: x_srlv_rec OUT NOCOPY srlv_rec_type);
61:
62: PROCEDURE update_sif_ret_levels(
63: p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
68: p_srlv_tbl IN srlv_tbl_type,

Line 73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

69: x_srlv_tbl OUT NOCOPY srlv_tbl_type);
70:
71: PROCEDURE delete_sif_ret_levels(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: p_srlv_rec IN srlv_rec_type,

Line 82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

78: x_srlv_rec OUT NOCOPY srlv_rec_type);
79:
80: PROCEDURE delete_sif_ret_levels(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_srlv_tbl IN srlv_tbl_type,

Line 91: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

87: x_srlv_tbl OUT NOCOPY srlv_tbl_type);
88:
89: PROCEDURE validate_sif_ret_levels(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: p_srlv_rec IN srlv_rec_type,

Line 100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

96: x_srlv_rec OUT NOCOPY srlv_rec_type);
97:
98: PROCEDURE validate_sif_ret_levels(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_srlv_tbl IN srlv_tbl_type,