DBA Data[Home] [Help]

APPS.OKE_AGREEMENT_PVT dependencies on OKE_API

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

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';

Line 29: (object_id NUMBER := OKE_API.G_MISS_NUM ,

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

Line 30: org_total_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

Line 31: total_amount 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: );

Line 32: agreement_currency_code VARCHAR2(15) := OKE_API.G_MISS_CHAR ,

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:

Line 33: --negative_amount NUMBER := OKE_API.G_MISS_NUM

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: --

Line 34: agreement_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: --
38: -- Agreement_Tbl_Type

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

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 ,

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

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 ,

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

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 ,

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

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 ,

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

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 ,

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

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

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

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 ,

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

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