DBA Data[Home] [Help]

APPS.OKE_TERMS_PUB dependencies on OKE_TERM_PVT

Line 7: SUBTYPE term_rec_type IS oke_term_pvt.term_rec_type;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_TERMS_PUB';
5: G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
6:
7: SUBTYPE term_rec_type IS oke_term_pvt.term_rec_type;
8:
9:
10: /* Creates a row in oke_k_terms. must provide all key values
11: k_header_id,k_line_id,term_code,term_value_pk1,term_value_pk2

Line 23: p_term_rec IN oke_term_pvt.term_rec_type,

19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2,
22:
23: p_term_rec IN oke_term_pvt.term_rec_type,
24: x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type);
25:
26: PROCEDURE create_term(
27: p_api_version IN NUMBER,

Line 24: x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type);

20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2,
22:
23: p_term_rec IN oke_term_pvt.term_rec_type,
24: x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type);
25:
26: PROCEDURE create_term(
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 33: p_term_tbl IN oke_term_pvt.term_tbl_type,

29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32:
33: p_term_tbl IN oke_term_pvt.term_tbl_type,
34: x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type);
35:
36:
37: /* delete uses all of the 5 key attributes to delete a particular row

Line 34: x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type);

30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32:
33: p_term_tbl IN oke_term_pvt.term_tbl_type,
34: x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type);
35:
36:
37: /* delete uses all of the 5 key attributes to delete a particular row
38: use NULL for k_line_id if target belongs to a contract line.

Line 47: p_term_rec IN oke_term_pvt.term_rec_type);

43: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_term_rec IN oke_term_pvt.term_rec_type);
48:
49:
50: PROCEDURE delete_term(
51: p_api_version IN NUMBER,

Line 56: p_term_tbl IN oke_term_pvt.term_tbl_type);

52: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,
55: x_msg_data OUT NOCOPY VARCHAR2,
56: p_term_tbl IN oke_term_pvt.term_tbl_type);
57:
58:
59: /* to delete a line's term specify cle and trm.
60: to delete a header's term specify chr and trm.

Line 85: p_term_rec IN oke_term_pvt.term_rec_type);

81: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_term_rec IN oke_term_pvt.term_rec_type);
86:
87: PROCEDURE validate_term(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 93: p_term_tbl IN oke_term_pvt.term_tbl_type);

89: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_term_tbl IN oke_term_pvt.term_tbl_type);
94:
95: */
96:
97:

Line 136: p_term_rec IN OKE_TERM_PVT.term_rec_type);

132: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_term_rec IN OKE_TERM_PVT.term_rec_type);
137:
138: PROCEDURE lock_term(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 144: p_term_tbl IN oke_term_pvt.term_tbl_type);

140: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_term_tbl IN oke_term_pvt.term_tbl_type);
145:
146: END OKE_TERMS_PUB;
147: