8:
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'OKE_AGREEMENT_PVT';
10: G_API_VERSION_NUMBER NUMBER := 1.0;
11: G_DESCRIPTION VARCHAR2(100) := 'Created by Oracle Project Contracts';
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
16: G_PRODUCT_CODE CONSTANT VARCHAR2(3) := 'OKE';
25: -- Agreement_Rec_Type
26: --
27:
28: TYPE agreement_rec_type is RECORD
29: (object_id NUMBER := OKE_API.G_MISS_NUM ,
30: org_total_amount NUMBER := OKE_API.G_MISS_NUM ,
31: total_amount NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_currency_code VARCHAR2(15) := OKE_API.G_MISS_CHAR ,
33: --negative_amount NUMBER := OKE_API.G_MISS_NUM
26: --
27:
28: TYPE agreement_rec_type is RECORD
29: (object_id NUMBER := OKE_API.G_MISS_NUM ,
30: org_total_amount NUMBER := OKE_API.G_MISS_NUM ,
31: total_amount NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_currency_code VARCHAR2(15) := OKE_API.G_MISS_CHAR ,
33: --negative_amount NUMBER := OKE_API.G_MISS_NUM
34: agreement_id NUMBER := OKE_API.G_MISS_NUM
27:
28: TYPE agreement_rec_type is RECORD
29: (object_id NUMBER := OKE_API.G_MISS_NUM ,
30: org_total_amount NUMBER := OKE_API.G_MISS_NUM ,
31: total_amount NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_currency_code VARCHAR2(15) := OKE_API.G_MISS_CHAR ,
33: --negative_amount NUMBER := OKE_API.G_MISS_NUM
34: agreement_id NUMBER := OKE_API.G_MISS_NUM
35: );
28: TYPE agreement_rec_type is RECORD
29: (object_id NUMBER := OKE_API.G_MISS_NUM ,
30: org_total_amount NUMBER := OKE_API.G_MISS_NUM ,
31: total_amount NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_currency_code VARCHAR2(15) := OKE_API.G_MISS_CHAR ,
33: --negative_amount NUMBER := OKE_API.G_MISS_NUM
34: agreement_id NUMBER := OKE_API.G_MISS_NUM
35: );
36:
29: (object_id NUMBER := OKE_API.G_MISS_NUM ,
30: org_total_amount NUMBER := OKE_API.G_MISS_NUM ,
31: total_amount NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_currency_code VARCHAR2(15) := OKE_API.G_MISS_CHAR ,
33: --negative_amount NUMBER := OKE_API.G_MISS_NUM
34: agreement_id NUMBER := OKE_API.G_MISS_NUM
35: );
36:
37: --
30: org_total_amount NUMBER := OKE_API.G_MISS_NUM ,
31: total_amount NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_currency_code VARCHAR2(15) := OKE_API.G_MISS_CHAR ,
33: --negative_amount NUMBER := OKE_API.G_MISS_NUM
34: agreement_id NUMBER := OKE_API.G_MISS_NUM
35: );
36:
37: --
38: -- Agreement_Tbl_Type
56: --
57: --
58:
59: PROCEDURE create_agreement(p_api_version IN NUMBER ,
60: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
61: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
62: p_msg_count OUT NOCOPY NUMBER ,
63: p_msg_data OUT NOCOPY VARCHAR2 ,
64: p_agreement_type IN VARCHAR2 ,
57: --
58:
59: PROCEDURE create_agreement(p_api_version IN NUMBER ,
60: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
61: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
62: p_msg_count OUT NOCOPY NUMBER ,
63: p_msg_data OUT NOCOPY VARCHAR2 ,
64: p_agreement_type IN VARCHAR2 ,
65: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,
74: --
75: --
76:
77: PROCEDURE update_agreement(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: p_msg_count OUT NOCOPY NUMBER ,
81: p_msg_data OUT NOCOPY VARCHAR2 ,
82: p_agreement_type IN VARCHAR2 ,
75: --
76:
77: PROCEDURE update_agreement(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: p_msg_count OUT NOCOPY NUMBER ,
81: p_msg_data OUT NOCOPY VARCHAR2 ,
82: p_agreement_type IN VARCHAR2 ,
83: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,
93: --
94: --
95:
96: PROCEDURE update_pa_funding(p_api_version IN NUMBER ,
97: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
98: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
99: p_msg_count OUT NOCOPY NUMBER ,
100: p_msg_data OUT NOCOPY VARCHAR2 ,
101: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
94: --
95:
96: PROCEDURE update_pa_funding(p_api_version IN NUMBER ,
97: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
98: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
99: p_msg_count OUT NOCOPY NUMBER ,
100: p_msg_data OUT NOCOPY VARCHAR2 ,
101: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
102: p_return_status OUT NOCOPY VARCHAR2
110: --
111: --
112:
113: PROCEDURE add_pa_funding(p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
115: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
116: p_msg_count OUT NOCOPY NUMBER ,
117: p_msg_data OUT NOCOPY VARCHAR2 ,
118: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
111: --
112:
113: PROCEDURE add_pa_funding(p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
115: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
116: p_msg_count OUT NOCOPY NUMBER ,
117: p_msg_data OUT NOCOPY VARCHAR2 ,
118: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
119: p_return_status OUT NOCOPY VARCHAR2