DBA Data[Home] [Help]

APPS.OKE_FUNDING_PUB dependencies on OKE_API

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

7:
8: G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
9: G_PKG_NAME CONSTANT VARCHAR2(40) := 'OKE_FUNDING_PUB';
10: G_PRODUCT_CODE CONSTANT VARCHAR2(3) := 'OKE';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
15: G_EXCEPTION_HALT_VALIDATION EXCEPTION;

Line 35: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

31: --
32: --
33:
34: PROCEDURE create_funding(p_api_version IN NUMBER ,
35: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
36: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
37: x_return_status OUT NOCOPY VARCHAR2 ,
38: x_msg_count OUT NOCOPY NUMBER ,
39: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 36: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

32: --
33:
34: PROCEDURE create_funding(p_api_version IN NUMBER ,
35: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
36: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
37: x_return_status OUT NOCOPY VARCHAR2 ,
38: x_msg_count OUT NOCOPY NUMBER ,
39: x_msg_data OUT NOCOPY VARCHAR2 ,
40: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

Line 40: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

36: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
37: x_return_status OUT NOCOPY VARCHAR2 ,
38: x_msg_count OUT NOCOPY NUMBER ,
39: x_msg_data OUT NOCOPY VARCHAR2 ,
40: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
41: p_agreement_type IN VARCHAR2 ,
42: p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
43: x_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,
44: p_allocation_in_tbl IN ALLOCATION_IN_TBL_TYPE ,

Line 57: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

53: --
54: --
55:
56: PROCEDURE update_funding(p_api_version IN NUMBER ,
57: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
58: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
59: x_return_status OUT NOCOPY VARCHAR2 ,
60: x_msg_count OUT NOCOPY NUMBER ,
61: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 58: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

54: --
55:
56: PROCEDURE update_funding(p_api_version IN NUMBER ,
57: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
58: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
59: x_return_status OUT NOCOPY VARCHAR2 ,
60: x_msg_count OUT NOCOPY NUMBER ,
61: x_msg_data OUT NOCOPY VARCHAR2 ,
62: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

Line 62: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

58: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
59: x_return_status OUT NOCOPY VARCHAR2 ,
60: x_msg_count OUT NOCOPY NUMBER ,
61: x_msg_data OUT NOCOPY VARCHAR2 ,
62: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
63: p_agreement_type IN VARCHAR2 ,
64: p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
65: x_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,
66: p_allocation_in_tbl IN ALLOCATION_IN_TBL_TYPE ,

Line 78: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

74: --
75: --
76:
77: PROCEDURE delete_funding(p_api_version IN NUMBER ,
78: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
79: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
80: x_return_status OUT NOCOPY VARCHAR2 ,
81: x_msg_count OUT NOCOPY NUMBER ,
82: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 79: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

75: --
76:
77: PROCEDURE delete_funding(p_api_version IN NUMBER ,
78: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
79: p_commit IN VARCHAR2 := OKE_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_funding_source_id IN NUMBER

Line 84: -- p_agreement_flag IN VARCHAR2 := OKE_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_funding_source_id IN NUMBER
84: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE
85: );
86:
87:
88: --

Line 96: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

92: --
93: --
94:
95: PROCEDURE add_allocation(p_api_version IN NUMBER ,
96: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
97: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
98: x_return_status OUT NOCOPY VARCHAR2 ,
99: x_msg_count OUT NOCOPY NUMBER ,
100: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 97: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

93: --
94:
95: PROCEDURE add_allocation(p_api_version IN NUMBER ,
96: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
97: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
98: x_return_status OUT NOCOPY VARCHAR2 ,
99: x_msg_count OUT NOCOPY NUMBER ,
100: x_msg_data OUT NOCOPY VARCHAR2 ,
101: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

Line 101: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

97: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
98: x_return_status OUT NOCOPY VARCHAR2 ,
99: x_msg_count OUT NOCOPY NUMBER ,
100: x_msg_data OUT NOCOPY VARCHAR2 ,
101: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
102: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
103: x_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE
104: );
105:

Line 115: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

111: --
112: --
113:
114: PROCEDURE update_allocation(p_api_version IN NUMBER ,
115: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
116: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
117: x_return_status OUT NOCOPY VARCHAR2 ,
118: x_msg_count OUT NOCOPY NUMBER ,
119: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 116: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

112: --
113:
114: PROCEDURE update_allocation(p_api_version IN NUMBER ,
115: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
116: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
117: x_return_status OUT NOCOPY VARCHAR2 ,
118: x_msg_count OUT NOCOPY NUMBER ,
119: x_msg_data OUT NOCOPY VARCHAR2 ,
120: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

Line 120: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

116: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
117: x_return_status OUT NOCOPY VARCHAR2 ,
118: x_msg_count OUT NOCOPY NUMBER ,
119: x_msg_data OUT NOCOPY VARCHAR2 ,
120: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
121: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
122: x_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE
123: );
124:

Line 134: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

130: --
131: --
132:
133: PROCEDURE delete_allocation(p_api_version IN NUMBER ,
134: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
135: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
136: x_return_status OUT NOCOPY VARCHAR2 ,
137: x_msg_count OUT NOCOPY NUMBER ,
138: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 135: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

131: --
132:
133: PROCEDURE delete_allocation(p_api_version IN NUMBER ,
134: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
135: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
136: x_return_status OUT NOCOPY VARCHAR2 ,
137: x_msg_count OUT NOCOPY NUMBER ,
138: x_msg_data OUT NOCOPY VARCHAR2 ,
139: p_fund_allocation_id IN NUMBER

Line 140: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE

136: x_return_status OUT NOCOPY VARCHAR2 ,
137: x_msg_count OUT NOCOPY NUMBER ,
138: x_msg_data OUT NOCOPY VARCHAR2 ,
139: p_fund_allocation_id IN NUMBER
140: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE
141: );
142:
143:
144: --

Line 152: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

148: --
149: --
150:
151: PROCEDURE create_pa_oke_funding(p_api_version IN NUMBER ,
152: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
153: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
154: x_return_status OUT NOCOPY VARCHAR2 ,
155: x_msg_count OUT NOCOPY NUMBER ,
156: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 153: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

149: --
150:
151: PROCEDURE create_pa_oke_funding(p_api_version IN NUMBER ,
152: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
153: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
154: x_return_status OUT NOCOPY VARCHAR2 ,
155: x_msg_count OUT NOCOPY NUMBER ,
156: x_msg_data OUT NOCOPY VARCHAR2 ,
157: x_funding_source_id OUT NOCOPY NUMBER ,