DBA Data[Home] [Help]

APPS.OKL_PAY_CURE_REFUNDS_PUB dependencies on OKC_API

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

10: -- GLOBAL VARIABLES
11: ---------------------------------------------------------------------------
12: G_PKG_NAME CONSTANT VARCHAR2(200)
13: := 'OKL_PAY_CURE_REFUNDS_PUB';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200)
16: := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
17: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
18: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';

Line 32: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

28: okl_pay_cure_refunds_pvt.pay_cure_refunds_tbl_type;
29:
30: PROCEDURE create_refund_hdr
31: ( p_api_version IN NUMBER
32: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
33: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
34: ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
35: ,x_cure_refund_header_id OUT NOCOPY NUMBER
36: ,x_return_status OUT NOCOPY VARCHAR2

Line 33: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

29:
30: PROCEDURE create_refund_hdr
31: ( p_api_version IN NUMBER
32: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
33: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
34: ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
35: ,x_cure_refund_header_id OUT NOCOPY NUMBER
36: ,x_return_status OUT NOCOPY VARCHAR2
37: ,x_msg_count OUT NOCOPY NUMBER

Line 43: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

39: );
40:
41: PROCEDURE update_refund_hdr
42: ( p_api_version IN NUMBER
43: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
44: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
45: ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
46: ,x_return_status OUT NOCOPY VARCHAR2
47: ,x_msg_count OUT NOCOPY NUMBER

Line 44: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

40:
41: PROCEDURE update_refund_hdr
42: ( p_api_version IN NUMBER
43: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
44: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
45: ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
46: ,x_return_status OUT NOCOPY VARCHAR2
47: ,x_msg_count OUT NOCOPY NUMBER
48: ,x_msg_data OUT NOCOPY VARCHAR2

Line 53: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

49: );
50:
51: PROCEDURE submit_cure_refund_hdr
52: ( p_api_version IN NUMBER
53: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
54: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
55: ,p_refund_header_id IN NUMBER
56: ,x_return_status OUT NOCOPY VARCHAR2
57: ,x_msg_count OUT NOCOPY NUMBER

Line 54: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

50:
51: PROCEDURE submit_cure_refund_hdr
52: ( p_api_version IN NUMBER
53: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
54: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
55: ,p_refund_header_id IN NUMBER
56: ,x_return_status OUT NOCOPY VARCHAR2
57: ,x_msg_count OUT NOCOPY NUMBER
58: ,x_msg_data OUT NOCOPY VARCHAR2

Line 63: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

59: );
60:
61: PROCEDURE delete_refund_hdr
62: ( p_api_version IN NUMBER
63: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
64: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
65: ,p_refund_header_id IN NUMBER
66: ,x_return_status OUT NOCOPY VARCHAR2
67: ,x_msg_count OUT NOCOPY NUMBER

Line 64: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

60:
61: PROCEDURE delete_refund_hdr
62: ( p_api_version IN NUMBER
63: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
64: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
65: ,p_refund_header_id IN NUMBER
66: ,x_return_status OUT NOCOPY VARCHAR2
67: ,x_msg_count OUT NOCOPY NUMBER
68: ,x_msg_data OUT NOCOPY VARCHAR2

Line 73: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

69: );
70:
71: PROCEDURE approve_cure_refunds
72: ( p_api_version IN NUMBER
73: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
74: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
75: ,p_refund_header_id IN NUMBER
76: ,x_return_status OUT NOCOPY VARCHAR2
77: ,x_msg_count OUT NOCOPY NUMBER

Line 74: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

70:
71: PROCEDURE approve_cure_refunds
72: ( p_api_version IN NUMBER
73: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
74: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
75: ,p_refund_header_id IN NUMBER
76: ,x_return_status OUT NOCOPY VARCHAR2
77: ,x_msg_count OUT NOCOPY NUMBER
78: ,x_msg_data OUT NOCOPY VARCHAR2

Line 86: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

82:
83:
84: PROCEDURE create_refund_headers
85: ( p_api_version IN NUMBER
86: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
87: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
88: ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
89: ,x_cure_refund_header_id OUT NOCOPY NUMBER
90: ,x_return_status OUT NOCOPY VARCHAR2

Line 87: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

83:
84: PROCEDURE create_refund_headers
85: ( p_api_version IN NUMBER
86: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
87: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
88: ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
89: ,x_cure_refund_header_id OUT NOCOPY NUMBER
90: ,x_return_status OUT NOCOPY VARCHAR2
91: ,x_msg_count OUT NOCOPY NUMBER

Line 97: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

93: );
94:
95: PROCEDURE update_refund_headers
96: ( p_api_version IN NUMBER
97: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
98: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99: ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
100: ,x_return_status OUT NOCOPY VARCHAR2
101: ,x_msg_count OUT NOCOPY NUMBER

Line 98: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

94:
95: PROCEDURE update_refund_headers
96: ( p_api_version IN NUMBER
97: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
98: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99: ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
100: ,x_return_status OUT NOCOPY VARCHAR2
101: ,x_msg_count OUT NOCOPY NUMBER
102: ,x_msg_data OUT NOCOPY VARCHAR2

Line 107: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

103: );
104:
105: PROCEDURE create_refund_details
106: ( p_api_version IN NUMBER
107: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
108: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
109: ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
110: ,x_return_status OUT NOCOPY VARCHAR2
111: ,x_msg_count OUT NOCOPY NUMBER

Line 108: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

104:
105: PROCEDURE create_refund_details
106: ( p_api_version IN NUMBER
107: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
108: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
109: ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
110: ,x_return_status OUT NOCOPY VARCHAR2
111: ,x_msg_count OUT NOCOPY NUMBER
112: ,x_msg_data OUT NOCOPY VARCHAR2

Line 117: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

113: );
114:
115: PROCEDURE update_refund_details
116: ( p_api_version IN NUMBER
117: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
118: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
119: ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
120: ,x_return_status OUT NOCOPY VARCHAR2
121: ,x_msg_count OUT NOCOPY NUMBER

Line 118: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

114:
115: PROCEDURE update_refund_details
116: ( p_api_version IN NUMBER
117: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
118: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
119: ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
120: ,x_return_status OUT NOCOPY VARCHAR2
121: ,x_msg_count OUT NOCOPY NUMBER
122: ,x_msg_data OUT NOCOPY VARCHAR2

Line 127: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

123: );
124:
125: PROCEDURE delete_refund_details
126: ( p_api_version IN NUMBER
127: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
128: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
129: ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
130: ,x_return_status OUT NOCOPY VARCHAR2
131: ,x_msg_count OUT NOCOPY NUMBER

Line 128: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

124:
125: PROCEDURE delete_refund_details
126: ( p_api_version IN NUMBER
127: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
128: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
129: ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
130: ,x_return_status OUT NOCOPY VARCHAR2
131: ,x_msg_count OUT NOCOPY NUMBER
132: ,x_msg_data OUT NOCOPY VARCHAR2