DBA Data[Home] [Help]

APPS.OKL_PDT_STYS_PUB dependencies on OKC_API

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

6: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
7: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
8: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
9:
10: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_PQY_VALUES_PUB';
12:
13: SUBTYPE psyv_rec_type IS okl_psy_pvt.psyv_rec_type;
14: SUBTYPE psyv_tbl_type IS okl_psy_pvt.psyv_tbl_type;

Line 20: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

16: PROCEDURE add_language;
17:
18: PROCEDURE insert_pdt_stys(
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
24: p_psyv_rec IN psyv_rec_type,

Line 29: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

25: x_psyv_rec OUT NOCOPY psyv_rec_type);
26:
27: PROCEDURE insert_pdt_stys(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_psyv_tbl IN psyv_tbl_type,

Line 38: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

34: x_psyv_tbl OUT NOCOPY psyv_tbl_type);
35:
36: PROCEDURE lock_pdt_stys(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_msg_count OUT NOCOPY NUMBER,
41: x_msg_data OUT NOCOPY VARCHAR2,
42: p_psyv_rec IN psyv_rec_type);

Line 46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

42: p_psyv_rec IN psyv_rec_type);
43:
44: PROCEDURE lock_pdt_stys(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,
49: x_msg_data OUT NOCOPY VARCHAR2,
50: p_psyv_tbl IN psyv_tbl_type);

Line 54: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

50: p_psyv_tbl IN psyv_tbl_type);
51:
52: PROCEDURE update_pdt_stys(
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_psyv_rec IN psyv_rec_type,

Line 63: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

59: x_psyv_rec OUT NOCOPY psyv_rec_type);
60:
61: PROCEDURE update_pdt_stys(
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_psyv_tbl IN psyv_tbl_type,

Line 72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

68: x_psyv_tbl OUT NOCOPY psyv_tbl_type);
69:
70: PROCEDURE delete_pdt_stys(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_psyv_rec IN psyv_rec_type);

Line 80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

76: p_psyv_rec IN psyv_rec_type);
77:
78: PROCEDURE delete_pdt_stys(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_psyv_tbl IN psyv_tbl_type);

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

84: p_psyv_tbl IN psyv_tbl_type);
85:
86: PROCEDURE validate_pdt_stys(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_psyv_rec IN psyv_rec_type);

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

92: p_psyv_rec IN psyv_rec_type);
93:
94: PROCEDURE validate_pdt_stys(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_psyv_tbl IN psyv_tbl_type);