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 79: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

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 ,

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

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 ,

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

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 ,

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

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

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

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 ,

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

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