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_receivables_term_id IN NUMBER default null , /*skuchima bug 14344021*/
43: p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
44: x_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,

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

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

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

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

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

59: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
60: x_return_status OUT NOCOPY VARCHAR2 ,
61: x_msg_count OUT NOCOPY NUMBER ,
62: x_msg_data OUT NOCOPY VARCHAR2 ,
63: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
64: p_agreement_type IN VARCHAR2 ,
65: p_receivables_term_id IN NUMBER default null , /*skuchima bug 14344021*/
66: p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
67: x_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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