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 ,
75: --
76: --
77:
78: PROCEDURE update_agreement(p_api_version IN NUMBER ,
79: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
80: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
81: p_msg_count OUT NOCOPY NUMBER ,
82: p_msg_data OUT NOCOPY VARCHAR2 ,
83: p_agreement_type IN VARCHAR2 ,
76: --
77:
78: PROCEDURE update_agreement(p_api_version IN NUMBER ,
79: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
80: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
81: p_msg_count OUT NOCOPY NUMBER ,
82: p_msg_data OUT NOCOPY VARCHAR2 ,
83: p_agreement_type IN VARCHAR2 ,
84: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,
95: --
96: --
97:
98: PROCEDURE update_pa_funding(p_api_version IN NUMBER ,
99: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
100: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
101: p_msg_count OUT NOCOPY NUMBER ,
102: p_msg_data OUT NOCOPY VARCHAR2 ,
103: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
96: --
97:
98: PROCEDURE update_pa_funding(p_api_version IN NUMBER ,
99: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
100: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
101: p_msg_count OUT NOCOPY NUMBER ,
102: p_msg_data OUT NOCOPY VARCHAR2 ,
103: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
104: p_return_status OUT NOCOPY VARCHAR2
112: --
113: --
114:
115: PROCEDURE add_pa_funding(p_api_version IN NUMBER ,
116: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
117: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
118: p_msg_count OUT NOCOPY NUMBER ,
119: p_msg_data OUT NOCOPY VARCHAR2 ,
120: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
113: --
114:
115: PROCEDURE add_pa_funding(p_api_version IN NUMBER ,
116: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
117: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
118: p_msg_count OUT NOCOPY NUMBER ,
119: p_msg_data OUT NOCOPY VARCHAR2 ,
120: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
121: p_return_status OUT NOCOPY VARCHAR2