APPS.OKE_ALLOCATION_PVT dependencies on OKE_API

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

7: --
8:
9: G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKE_ALLOCATION_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
15: G_OBJECT_TYPE CONSTANT VARCHAR2(30) := 'OKE_K_HEADERS';

Line 26: (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,

22: -- Allocation_Rec_In_Type
23: --
24:
25: TYPE allocation_rec_in_type is RECORD
26: (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,
27: funding_source_id NUMBER := OKE_API.G_MISS_NUM ,
28: object_id NUMBER := OKE_API.G_MISS_NUM ,
29: k_line_id NUMBER := OKE_API.G_MISS_NUM ,
30: project_id NUMBER := OKE_API.G_MISS_NUM ,

Line 27: funding_source_id NUMBER := OKE_API.G_MISS_NUM ,

23: --
24:
25: TYPE allocation_rec_in_type is RECORD
26: (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,
27: funding_source_id NUMBER := OKE_API.G_MISS_NUM ,
28: object_id NUMBER := OKE_API.G_MISS_NUM ,
29: k_line_id NUMBER := OKE_API.G_MISS_NUM ,
30: project_id NUMBER := OKE_API.G_MISS_NUM ,
31: task_id NUMBER := OKE_API.G_MISS_NUM ,

Line 28: object_id NUMBER := OKE_API.G_MISS_NUM ,

24:
25: TYPE allocation_rec_in_type is RECORD
26: (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,
27: funding_source_id NUMBER := OKE_API.G_MISS_NUM ,
28: object_id NUMBER := OKE_API.G_MISS_NUM ,
29: k_line_id NUMBER := OKE_API.G_MISS_NUM ,
30: project_id NUMBER := OKE_API.G_MISS_NUM ,
31: task_id NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_id NUMBER := OKE_API.G_MISS_NUM ,

Line 29: k_line_id NUMBER := OKE_API.G_MISS_NUM ,

25: TYPE allocation_rec_in_type is RECORD
26: (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,
27: funding_source_id NUMBER := OKE_API.G_MISS_NUM ,
28: object_id NUMBER := OKE_API.G_MISS_NUM ,
29: k_line_id NUMBER := OKE_API.G_MISS_NUM ,
30: project_id NUMBER := OKE_API.G_MISS_NUM ,
31: task_id NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_id NUMBER := OKE_API.G_MISS_NUM ,
33: project_funding_id NUMBER := OKE_API.G_MISS_NUM ,

Line 30: project_id NUMBER := OKE_API.G_MISS_NUM ,

26: (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,
27: funding_source_id NUMBER := OKE_API.G_MISS_NUM ,
28: object_id NUMBER := OKE_API.G_MISS_NUM ,
29: k_line_id NUMBER := OKE_API.G_MISS_NUM ,
30: project_id NUMBER := OKE_API.G_MISS_NUM ,
31: task_id NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_id NUMBER := OKE_API.G_MISS_NUM ,
33: project_funding_id NUMBER := OKE_API.G_MISS_NUM ,
34: amount NUMBER := OKE_API.G_MISS_NUM ,

Line 31: task_id NUMBER := OKE_API.G_MISS_NUM ,

27: funding_source_id NUMBER := OKE_API.G_MISS_NUM ,
28: object_id NUMBER := OKE_API.G_MISS_NUM ,
29: k_line_id NUMBER := OKE_API.G_MISS_NUM ,
30: project_id NUMBER := OKE_API.G_MISS_NUM ,
31: task_id NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_id NUMBER := OKE_API.G_MISS_NUM ,
33: project_funding_id NUMBER := OKE_API.G_MISS_NUM ,
34: amount NUMBER := OKE_API.G_MISS_NUM ,
35: hard_limit NUMBER := OKE_API.G_MISS_NUM ,

Line 32: agreement_id NUMBER := OKE_API.G_MISS_NUM ,

28: object_id NUMBER := OKE_API.G_MISS_NUM ,
29: k_line_id NUMBER := OKE_API.G_MISS_NUM ,
30: project_id NUMBER := OKE_API.G_MISS_NUM ,
31: task_id NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_id NUMBER := OKE_API.G_MISS_NUM ,
33: project_funding_id NUMBER := OKE_API.G_MISS_NUM ,
34: amount NUMBER := OKE_API.G_MISS_NUM ,
35: hard_limit NUMBER := OKE_API.G_MISS_NUM ,
36: fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

Line 33: project_funding_id NUMBER := OKE_API.G_MISS_NUM ,

29: k_line_id NUMBER := OKE_API.G_MISS_NUM ,
30: project_id NUMBER := OKE_API.G_MISS_NUM ,
31: task_id NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_id NUMBER := OKE_API.G_MISS_NUM ,
33: project_funding_id NUMBER := OKE_API.G_MISS_NUM ,
34: amount NUMBER := OKE_API.G_MISS_NUM ,
35: hard_limit NUMBER := OKE_API.G_MISS_NUM ,
36: fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
37: funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

Line 34: amount NUMBER := OKE_API.G_MISS_NUM ,

30: project_id NUMBER := OKE_API.G_MISS_NUM ,
31: task_id NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_id NUMBER := OKE_API.G_MISS_NUM ,
33: project_funding_id NUMBER := OKE_API.G_MISS_NUM ,
34: amount NUMBER := OKE_API.G_MISS_NUM ,
35: hard_limit NUMBER := OKE_API.G_MISS_NUM ,
36: fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
37: funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
38: start_date_active DATE := OKE_API.G_MISS_DATE ,

Line 35: hard_limit NUMBER := OKE_API.G_MISS_NUM ,

31: task_id NUMBER := OKE_API.G_MISS_NUM ,
32: agreement_id NUMBER := OKE_API.G_MISS_NUM ,
33: project_funding_id NUMBER := OKE_API.G_MISS_NUM ,
34: amount NUMBER := OKE_API.G_MISS_NUM ,
35: hard_limit NUMBER := OKE_API.G_MISS_NUM ,
36: fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
37: funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
38: start_date_active DATE := OKE_API.G_MISS_DATE ,
39: end_date_active DATE := OKE_API.G_MISS_DATE ,

Line 36: fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

32: agreement_id NUMBER := OKE_API.G_MISS_NUM ,
33: project_funding_id NUMBER := OKE_API.G_MISS_NUM ,
34: amount NUMBER := OKE_API.G_MISS_NUM ,
35: hard_limit NUMBER := OKE_API.G_MISS_NUM ,
36: fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
37: funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
38: start_date_active DATE := OKE_API.G_MISS_DATE ,
39: end_date_active DATE := OKE_API.G_MISS_DATE ,
40: fiscal_year NUMBER := OKE_API.G_MISS_NUM ,

Line 37: funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

33: project_funding_id NUMBER := OKE_API.G_MISS_NUM ,
34: amount NUMBER := OKE_API.G_MISS_NUM ,
35: hard_limit NUMBER := OKE_API.G_MISS_NUM ,
36: fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
37: funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
38: start_date_active DATE := OKE_API.G_MISS_DATE ,
39: end_date_active DATE := OKE_API.G_MISS_DATE ,
40: fiscal_year NUMBER := OKE_API.G_MISS_NUM ,
41: reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,

Line 38: start_date_active DATE := OKE_API.G_MISS_DATE ,

34: amount NUMBER := OKE_API.G_MISS_NUM ,
35: hard_limit NUMBER := OKE_API.G_MISS_NUM ,
36: fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
37: funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
38: start_date_active DATE := OKE_API.G_MISS_DATE ,
39: end_date_active DATE := OKE_API.G_MISS_DATE ,
40: fiscal_year NUMBER := OKE_API.G_MISS_NUM ,
41: reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
42: reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,

Line 39: end_date_active DATE := OKE_API.G_MISS_DATE ,

35: hard_limit NUMBER := OKE_API.G_MISS_NUM ,
36: fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
37: funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
38: start_date_active DATE := OKE_API.G_MISS_DATE ,
39: end_date_active DATE := OKE_API.G_MISS_DATE ,
40: fiscal_year NUMBER := OKE_API.G_MISS_NUM ,
41: reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
42: reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
43: reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,

Line 40: fiscal_year NUMBER := OKE_API.G_MISS_NUM ,

36: fund_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
37: funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
38: start_date_active DATE := OKE_API.G_MISS_DATE ,
39: end_date_active DATE := OKE_API.G_MISS_DATE ,
40: fiscal_year NUMBER := OKE_API.G_MISS_NUM ,
41: reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
42: reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
43: reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
44: pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

Line 41: reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,

37: funding_status VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
38: start_date_active DATE := OKE_API.G_MISS_DATE ,
39: end_date_active DATE := OKE_API.G_MISS_DATE ,
40: fiscal_year NUMBER := OKE_API.G_MISS_NUM ,
41: reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
42: reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
43: reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
44: pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
45: pa_conversion_date DATE := OKE_API.G_MISS_DATE ,

Line 42: reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,

38: start_date_active DATE := OKE_API.G_MISS_DATE ,
39: end_date_active DATE := OKE_API.G_MISS_DATE ,
40: fiscal_year NUMBER := OKE_API.G_MISS_NUM ,
41: reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
42: reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
43: reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
44: pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
45: pa_conversion_date DATE := OKE_API.G_MISS_DATE ,
46: pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,

Line 43: reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,

39: end_date_active DATE := OKE_API.G_MISS_DATE ,
40: fiscal_year NUMBER := OKE_API.G_MISS_NUM ,
41: reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
42: reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
43: reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
44: pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
45: pa_conversion_date DATE := OKE_API.G_MISS_DATE ,
46: pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,
47: -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,

Line 44: pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

40: fiscal_year NUMBER := OKE_API.G_MISS_NUM ,
41: reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
42: reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
43: reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
44: pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
45: pa_conversion_date DATE := OKE_API.G_MISS_DATE ,
46: pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,
47: -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,
48: oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

Line 45: pa_conversion_date DATE := OKE_API.G_MISS_DATE ,

41: reference1 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
42: reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
43: reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
44: pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
45: pa_conversion_date DATE := OKE_API.G_MISS_DATE ,
46: pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,
47: -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,
48: oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
49: oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 46: pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,

42: reference2 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
43: reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
44: pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
45: pa_conversion_date DATE := OKE_API.G_MISS_DATE ,
46: pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,
47: -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,
48: oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
49: oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
50: oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 47: -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,

43: reference3 VARCHAR2(80) := OKE_API.G_MISS_CHAR ,
44: pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
45: pa_conversion_date DATE := OKE_API.G_MISS_DATE ,
46: pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,
47: -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,
48: oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
49: oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
50: oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
51: oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 48: oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

44: pa_conversion_type VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
45: pa_conversion_date DATE := OKE_API.G_MISS_DATE ,
46: pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,
47: -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,
48: oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
49: oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
50: oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
51: oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
52: oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 49: oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

45: pa_conversion_date DATE := OKE_API.G_MISS_DATE ,
46: pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,
47: -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,
48: oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
49: oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
50: oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
51: oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
52: oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
53: oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 50: oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

46: pa_conversion_rate NUMBER := OKE_API.G_MISS_NUM ,
47: -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,
48: oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
49: oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
50: oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
51: oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
52: oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
53: oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
54: oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 51: oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

47: -- oke_desc_flex_name VARCHAR2(240) := OKE_API.G_MISS_CHAR ,
48: oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
49: oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
50: oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
51: oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
52: oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
53: oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
54: oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
55: oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 52: oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

48: oke_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
49: oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
50: oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
51: oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
52: oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
53: oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
54: oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
55: oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
56: oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 53: oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

49: oke_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
50: oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
51: oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
52: oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
53: oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
54: oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
55: oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
56: oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
57: oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 54: oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

50: oke_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
51: oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
52: oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
53: oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
54: oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
55: oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
56: oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
57: oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
58: oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 55: oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

51: oke_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
52: oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
53: oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
54: oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
55: oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
56: oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
57: oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
58: oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
59: oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 56: oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

52: oke_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
53: oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
54: oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
55: oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
56: oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
57: oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
58: oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
59: oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
60: oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 57: oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

53: oke_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
54: oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
55: oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
56: oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
57: oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
58: oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
59: oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
60: oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
61: oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 58: oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

54: oke_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
55: oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
56: oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
57: oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
58: oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
59: oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
60: oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
61: oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
62: oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 59: oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

55: oke_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
56: oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
57: oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
58: oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
59: oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
60: oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
61: oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
62: oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
63: oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 60: oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

56: oke_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
57: oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
58: oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
59: oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
60: oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
61: oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
62: oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
63: oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
64: revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,

Line 61: oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

57: oke_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
58: oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
59: oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
60: oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
61: oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
62: oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
63: oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
64: revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,
65: funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

Line 62: oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

58: oke_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
59: oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
60: oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
61: oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
62: oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
63: oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
64: revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,
65: funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
66: pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

Line 63: oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

59: oke_attribute11 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
60: oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
61: oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
62: oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
63: oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
64: revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,
65: funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
66: pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
67: pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 64: revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,

60: oke_attribute12 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
61: oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
62: oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
63: oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
64: revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,
65: funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
66: pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
67: pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
68: pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 65: funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

61: oke_attribute13 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
62: oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
63: oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
64: revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,
65: funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
66: pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
67: pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
68: pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
69: pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 66: pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,

62: oke_attribute14 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
63: oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
64: revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,
65: funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
66: pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
67: pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
68: pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
69: pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
70: pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 67: pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

63: oke_attribute15 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
64: revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,
65: funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
66: pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
67: pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
68: pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
69: pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
70: pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
71: pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 68: pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

64: revenue_hard_limit NUMBER := OKE_API.G_MISS_NUM ,
65: funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
66: pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
67: pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
68: pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
69: pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
70: pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
71: pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
72: pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 69: pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

65: funding_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
66: pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
67: pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
68: pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
69: pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
70: pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
71: pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
72: pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
73: pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 70: pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

66: pa_attribute_category VARCHAR2(30) := OKE_API.G_MISS_CHAR ,
67: pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
68: pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
69: pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
70: pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
71: pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
72: pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
73: pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
74: pa_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 71: pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

67: pa_attribute1 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
68: pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
69: pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
70: pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
71: pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
72: pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
73: pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
74: pa_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
75: pa_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

Line 72: pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

68: pa_attribute2 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
69: pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
70: pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
71: pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
72: pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
73: pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
74: pa_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
75: pa_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
76: pa_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR

Line 73: pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

69: pa_attribute3 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
70: pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
71: pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
72: pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
73: pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
74: pa_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
75: pa_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
76: pa_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR
77: );

Line 74: pa_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

70: pa_attribute4 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
71: pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
72: pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
73: pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
74: pa_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
75: pa_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
76: pa_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR
77: );
78:

Line 75: pa_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,

71: pa_attribute5 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
72: pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
73: pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
74: pa_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
75: pa_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
76: pa_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR
77: );
78:
79:

Line 76: pa_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR

72: pa_attribute6 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
73: pa_attribute7 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
74: pa_attribute8 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
75: pa_attribute9 VARCHAR2(150) := OKE_API.G_MISS_CHAR ,
76: pa_attribute10 VARCHAR2(150) := OKE_API.G_MISS_CHAR
77: );
78:
79:
80: --

Line 85: (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,

81: -- Allocation_Rec_Out_Type
82: --
83:
84: TYPE allocation_rec_out_type is RECORD
85: (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,
86: return_status VARCHAR2(1) := OKE_API.G_MISS_CHAR
87: );
88:
89:

Line 86: return_status VARCHAR2(1) := OKE_API.G_MISS_CHAR

82: --
83:
84: TYPE allocation_rec_out_type is RECORD
85: (fund_allocation_id NUMBER := OKE_API.G_MISS_NUM ,
86: return_status VARCHAR2(1) := OKE_API.G_MISS_CHAR
87: );
88:
89:
90: --

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

109: -- Description: This procedure is used to insert record in OKE_K_FUND_ALLOCATIONS table
110: --
111:
112: PROCEDURE add_allocation(p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
114: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
115: p_msg_count OUT NOCOPY NUMBER ,
116: p_msg_data OUT NOCOPY VARCHAR2 ,
117: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,

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

110: --
111:
112: PROCEDURE add_allocation(p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
114: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
115: p_msg_count OUT NOCOPY NUMBER ,
116: p_msg_data OUT NOCOPY VARCHAR2 ,
117: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
118: p_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE ,

Line 119: p_validation_flag IN VARCHAR2 := OKE_API.G_TRUE ,

115: p_msg_count OUT NOCOPY NUMBER ,
116: p_msg_data OUT NOCOPY VARCHAR2 ,
117: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
118: p_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE ,
119: p_validation_flag IN VARCHAR2 := OKE_API.G_TRUE ,
120: p_return_status OUT NOCOPY VARCHAR2
121: );
122:
123:

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

127: -- Description: This procedure is used to update record in OKE_K_FUND_ALLOCATIONS table
128: --
129:
130: PROCEDURE update_allocation(p_api_version IN NUMBER ,
131: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
132: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
133: p_msg_count OUT NOCOPY NUMBER ,
134: p_msg_data OUT NOCOPY VARCHAR2 ,
135: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,

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

128: --
129:
130: PROCEDURE update_allocation(p_api_version IN NUMBER ,
131: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
132: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
133: p_msg_count OUT NOCOPY NUMBER ,
134: p_msg_data OUT NOCOPY VARCHAR2 ,
135: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
136: p_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE ,

Line 137: p_validation_flag IN VARCHAR2 := OKE_API.G_TRUE ,

133: p_msg_count OUT NOCOPY NUMBER ,
134: p_msg_data OUT NOCOPY VARCHAR2 ,
135: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
136: p_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE ,
137: p_validation_flag IN VARCHAR2 := OKE_API.G_TRUE ,
138: p_return_status OUT NOCOPY VARCHAR2
139: );
140:
141:

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

145: -- Description: This procedure is used to delete record in OKE_K_FUND_ALLOCATIONS and PA_PROJECT_FUNDINGS tables
146: --
147:
148: PROCEDURE delete_allocation(p_api_version IN NUMBER ,
149: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
150: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
151: p_msg_count OUT NOCOPY NUMBER ,
152: p_msg_data OUT NOCOPY VARCHAR2 ,
153: p_fund_allocation_id IN NUMBER ,

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

146: --
147:
148: PROCEDURE delete_allocation(p_api_version IN NUMBER ,
149: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
150: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
151: p_msg_count OUT NOCOPY NUMBER ,
152: p_msg_data OUT NOCOPY VARCHAR2 ,
153: p_fund_allocation_id IN NUMBER ,
154: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

Line 154: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,

150: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
151: p_msg_count OUT NOCOPY NUMBER ,
152: p_msg_data OUT NOCOPY VARCHAR2 ,
153: p_fund_allocation_id IN NUMBER ,
154: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
155: p_return_status OUT NOCOPY VARCHAR2
156: );
157:
158: