DBA Data[Home] [Help]

APPS.QP_CURRENCY_PUB dependencies on FND_API

Line 15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

11:
12: -- Curr_Lists record type
13:
14: TYPE Curr_Lists_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

12: -- Curr_Lists record type
13:
14: TYPE Curr_Lists_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

13:
14: TYPE Curr_Lists_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

14: TYPE Curr_Lists_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , base_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , base_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
31: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , base_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
31: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , created_by NUMBER := FND_API.G_MISS_NUM

Line 29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , base_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
31: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , created_by NUMBER := FND_API.G_MISS_NUM
33: , creation_date DATE := FND_API.G_MISS_DATE

Line 30: , base_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR

26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , base_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
31: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , created_by NUMBER := FND_API.G_MISS_NUM
33: , creation_date DATE := FND_API.G_MISS_DATE
34: , currency_header_id NUMBER := FND_API.G_MISS_NUM

Line 31: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , base_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
31: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , created_by NUMBER := FND_API.G_MISS_NUM
33: , creation_date DATE := FND_API.G_MISS_DATE
34: , currency_header_id NUMBER := FND_API.G_MISS_NUM
35: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR

Line 32: , created_by NUMBER := FND_API.G_MISS_NUM

28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , base_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
31: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , created_by NUMBER := FND_API.G_MISS_NUM
33: , creation_date DATE := FND_API.G_MISS_DATE
34: , currency_header_id NUMBER := FND_API.G_MISS_NUM
35: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 33: , creation_date DATE := FND_API.G_MISS_DATE

29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , base_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
31: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , created_by NUMBER := FND_API.G_MISS_NUM
33: , creation_date DATE := FND_API.G_MISS_DATE
34: , currency_header_id NUMBER := FND_API.G_MISS_NUM
35: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , last_updated_by NUMBER := FND_API.G_MISS_NUM
37: , last_update_date DATE := FND_API.G_MISS_DATE

Line 34: , currency_header_id NUMBER := FND_API.G_MISS_NUM

30: , base_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
31: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , created_by NUMBER := FND_API.G_MISS_NUM
33: , creation_date DATE := FND_API.G_MISS_DATE
34: , currency_header_id NUMBER := FND_API.G_MISS_NUM
35: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , last_updated_by NUMBER := FND_API.G_MISS_NUM
37: , last_update_date DATE := FND_API.G_MISS_DATE
38: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 35: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR

31: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , created_by NUMBER := FND_API.G_MISS_NUM
33: , creation_date DATE := FND_API.G_MISS_DATE
34: , currency_header_id NUMBER := FND_API.G_MISS_NUM
35: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , last_updated_by NUMBER := FND_API.G_MISS_NUM
37: , last_update_date DATE := FND_API.G_MISS_DATE
38: , last_update_login NUMBER := FND_API.G_MISS_NUM
39: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 36: , last_updated_by NUMBER := FND_API.G_MISS_NUM

32: , created_by NUMBER := FND_API.G_MISS_NUM
33: , creation_date DATE := FND_API.G_MISS_DATE
34: , currency_header_id NUMBER := FND_API.G_MISS_NUM
35: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , last_updated_by NUMBER := FND_API.G_MISS_NUM
37: , last_update_date DATE := FND_API.G_MISS_DATE
38: , last_update_login NUMBER := FND_API.G_MISS_NUM
39: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , base_rounding_factor NUMBER := FND_API.G_MISS_NUM

Line 37: , last_update_date DATE := FND_API.G_MISS_DATE

33: , creation_date DATE := FND_API.G_MISS_DATE
34: , currency_header_id NUMBER := FND_API.G_MISS_NUM
35: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , last_updated_by NUMBER := FND_API.G_MISS_NUM
37: , last_update_date DATE := FND_API.G_MISS_DATE
38: , last_update_login NUMBER := FND_API.G_MISS_NUM
39: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , base_rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , base_markup_formula_id NUMBER := FND_API.G_MISS_NUM

Line 38: , last_update_login NUMBER := FND_API.G_MISS_NUM

34: , currency_header_id NUMBER := FND_API.G_MISS_NUM
35: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , last_updated_by NUMBER := FND_API.G_MISS_NUM
37: , last_update_date DATE := FND_API.G_MISS_DATE
38: , last_update_login NUMBER := FND_API.G_MISS_NUM
39: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , base_rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , base_markup_formula_id NUMBER := FND_API.G_MISS_NUM
42: , base_markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 39: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

35: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , last_updated_by NUMBER := FND_API.G_MISS_NUM
37: , last_update_date DATE := FND_API.G_MISS_DATE
38: , last_update_login NUMBER := FND_API.G_MISS_NUM
39: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , base_rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , base_markup_formula_id NUMBER := FND_API.G_MISS_NUM
42: , base_markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , base_markup_value NUMBER := FND_API.G_MISS_NUM

Line 40: , base_rounding_factor NUMBER := FND_API.G_MISS_NUM

36: , last_updated_by NUMBER := FND_API.G_MISS_NUM
37: , last_update_date DATE := FND_API.G_MISS_DATE
38: , last_update_login NUMBER := FND_API.G_MISS_NUM
39: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , base_rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , base_markup_formula_id NUMBER := FND_API.G_MISS_NUM
42: , base_markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , base_markup_value NUMBER := FND_API.G_MISS_NUM
44: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 41: , base_markup_formula_id NUMBER := FND_API.G_MISS_NUM

37: , last_update_date DATE := FND_API.G_MISS_DATE
38: , last_update_login NUMBER := FND_API.G_MISS_NUM
39: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , base_rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , base_markup_formula_id NUMBER := FND_API.G_MISS_NUM
42: , base_markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , base_markup_value NUMBER := FND_API.G_MISS_NUM
44: , program_application_id NUMBER := FND_API.G_MISS_NUM
45: , program_id NUMBER := FND_API.G_MISS_NUM

Line 42: , base_markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR

38: , last_update_login NUMBER := FND_API.G_MISS_NUM
39: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , base_rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , base_markup_formula_id NUMBER := FND_API.G_MISS_NUM
42: , base_markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , base_markup_value NUMBER := FND_API.G_MISS_NUM
44: , program_application_id NUMBER := FND_API.G_MISS_NUM
45: , program_id NUMBER := FND_API.G_MISS_NUM
46: , program_update_date DATE := FND_API.G_MISS_DATE

Line 43: , base_markup_value NUMBER := FND_API.G_MISS_NUM

39: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , base_rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , base_markup_formula_id NUMBER := FND_API.G_MISS_NUM
42: , base_markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , base_markup_value NUMBER := FND_API.G_MISS_NUM
44: , program_application_id NUMBER := FND_API.G_MISS_NUM
45: , program_id NUMBER := FND_API.G_MISS_NUM
46: , program_update_date DATE := FND_API.G_MISS_DATE
47: , request_id NUMBER := FND_API.G_MISS_NUM

Line 44: , program_application_id NUMBER := FND_API.G_MISS_NUM

40: , base_rounding_factor NUMBER := FND_API.G_MISS_NUM
41: , base_markup_formula_id NUMBER := FND_API.G_MISS_NUM
42: , base_markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , base_markup_value NUMBER := FND_API.G_MISS_NUM
44: , program_application_id NUMBER := FND_API.G_MISS_NUM
45: , program_id NUMBER := FND_API.G_MISS_NUM
46: , program_update_date DATE := FND_API.G_MISS_DATE
47: , request_id NUMBER := FND_API.G_MISS_NUM
48: -- , row_id NUMBER := FND_API.G_MISS_NUM -- Commented by Sunil

Line 45: , program_id NUMBER := FND_API.G_MISS_NUM

41: , base_markup_formula_id NUMBER := FND_API.G_MISS_NUM
42: , base_markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , base_markup_value NUMBER := FND_API.G_MISS_NUM
44: , program_application_id NUMBER := FND_API.G_MISS_NUM
45: , program_id NUMBER := FND_API.G_MISS_NUM
46: , program_update_date DATE := FND_API.G_MISS_DATE
47: , request_id NUMBER := FND_API.G_MISS_NUM
48: -- , row_id NUMBER := FND_API.G_MISS_NUM -- Commented by Sunil
49: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 46: , program_update_date DATE := FND_API.G_MISS_DATE

42: , base_markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
43: , base_markup_value NUMBER := FND_API.G_MISS_NUM
44: , program_application_id NUMBER := FND_API.G_MISS_NUM
45: , program_id NUMBER := FND_API.G_MISS_NUM
46: , program_update_date DATE := FND_API.G_MISS_DATE
47: , request_id NUMBER := FND_API.G_MISS_NUM
48: -- , row_id NUMBER := FND_API.G_MISS_NUM -- Commented by Sunil
49: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
50: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 47: , request_id NUMBER := FND_API.G_MISS_NUM

43: , base_markup_value NUMBER := FND_API.G_MISS_NUM
44: , program_application_id NUMBER := FND_API.G_MISS_NUM
45: , program_id NUMBER := FND_API.G_MISS_NUM
46: , program_update_date DATE := FND_API.G_MISS_DATE
47: , request_id NUMBER := FND_API.G_MISS_NUM
48: -- , row_id NUMBER := FND_API.G_MISS_NUM -- Commented by Sunil
49: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
50: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
51: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 48: -- , row_id NUMBER := FND_API.G_MISS_NUM -- Commented by Sunil

44: , program_application_id NUMBER := FND_API.G_MISS_NUM
45: , program_id NUMBER := FND_API.G_MISS_NUM
46: , program_update_date DATE := FND_API.G_MISS_DATE
47: , request_id NUMBER := FND_API.G_MISS_NUM
48: -- , row_id NUMBER := FND_API.G_MISS_NUM -- Commented by Sunil
49: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
50: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
51: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
52: );

Line 49: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

45: , program_id NUMBER := FND_API.G_MISS_NUM
46: , program_update_date DATE := FND_API.G_MISS_DATE
47: , request_id NUMBER := FND_API.G_MISS_NUM
48: -- , row_id NUMBER := FND_API.G_MISS_NUM -- Commented by Sunil
49: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
50: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
51: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
52: );
53:

Line 50: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

46: , program_update_date DATE := FND_API.G_MISS_DATE
47: , request_id NUMBER := FND_API.G_MISS_NUM
48: -- , row_id NUMBER := FND_API.G_MISS_NUM -- Commented by Sunil
49: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
50: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
51: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
52: );
53:
54: TYPE Curr_Lists_Tbl_Type IS TABLE OF Curr_Lists_Rec_Type

Line 51: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

47: , request_id NUMBER := FND_API.G_MISS_NUM
48: -- , row_id NUMBER := FND_API.G_MISS_NUM -- Commented by Sunil
49: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
50: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
51: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
52: );
53:
54: TYPE Curr_Lists_Tbl_Type IS TABLE OF Curr_Lists_Rec_Type
55: INDEX BY BINARY_INTEGER;

Line 60: ( base_currency VARCHAR2(240) := FND_API.G_MISS_CHAR

56:
57: -- Curr_Lists value record type
58:
59: TYPE Curr_Lists_Val_Rec_Type IS RECORD
60: ( base_currency VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , base_markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
63: -- , row VARCHAR2(240) := FND_API.G_MISS_CHAR -- Commented by Sunil
64: );

Line 61: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR

57: -- Curr_Lists value record type
58:
59: TYPE Curr_Lists_Val_Rec_Type IS RECORD
60: ( base_currency VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , base_markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
63: -- , row VARCHAR2(240) := FND_API.G_MISS_CHAR -- Commented by Sunil
64: );
65:

Line 62: , base_markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR

58:
59: TYPE Curr_Lists_Val_Rec_Type IS RECORD
60: ( base_currency VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , base_markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
63: -- , row VARCHAR2(240) := FND_API.G_MISS_CHAR -- Commented by Sunil
64: );
65:
66: TYPE Curr_Lists_Val_Tbl_Type IS TABLE OF Curr_Lists_Val_Rec_Type

Line 63: -- , row VARCHAR2(240) := FND_API.G_MISS_CHAR -- Commented by Sunil

59: TYPE Curr_Lists_Val_Rec_Type IS RECORD
60: ( base_currency VARCHAR2(240) := FND_API.G_MISS_CHAR
61: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR
62: , base_markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
63: -- , row VARCHAR2(240) := FND_API.G_MISS_CHAR -- Commented by Sunil
64: );
65:
66: TYPE Curr_Lists_Val_Tbl_Type IS TABLE OF Curr_Lists_Val_Rec_Type
67: INDEX BY BINARY_INTEGER;

Line 72: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

68:
69: -- Curr_Details record type
70:
71: TYPE Curr_Details_Rec_Type IS RECORD
72: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 73: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

69: -- Curr_Details record type
70:
71: TYPE Curr_Details_Rec_Type IS RECORD
72: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 74: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

70:
71: TYPE Curr_Details_Rec_Type IS RECORD
72: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 75: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

71: TYPE Curr_Details_Rec_Type IS RECORD
72: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 76: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

72: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 77: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

73: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 78: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

74: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 79: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

75: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 80: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

76: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 81: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

77: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 82: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

78: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
79: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 83: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

79: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 84: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

80: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , conversion_date DATE := FND_API.G_MISS_DATE

Line 85: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

81: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , conversion_date DATE := FND_API.G_MISS_DATE
89: , conversion_date_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 86: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

82: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
83: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , conversion_date DATE := FND_API.G_MISS_DATE
89: , conversion_date_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: -- , conversion_method VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 87: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

83: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
84: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , conversion_date DATE := FND_API.G_MISS_DATE
89: , conversion_date_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: -- , conversion_method VARCHAR2(30) := FND_API.G_MISS_CHAR
91: , conversion_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 88: , conversion_date DATE := FND_API.G_MISS_DATE

84: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
85: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , conversion_date DATE := FND_API.G_MISS_DATE
89: , conversion_date_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: -- , conversion_method VARCHAR2(30) := FND_API.G_MISS_CHAR
91: , conversion_type VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , created_by NUMBER := FND_API.G_MISS_NUM

Line 89: , conversion_date_type VARCHAR2(30) := FND_API.G_MISS_CHAR

85: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
86: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , conversion_date DATE := FND_API.G_MISS_DATE
89: , conversion_date_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: -- , conversion_method VARCHAR2(30) := FND_API.G_MISS_CHAR
91: , conversion_type VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , created_by NUMBER := FND_API.G_MISS_NUM
93: , creation_date DATE := FND_API.G_MISS_DATE

Line 90: -- , conversion_method VARCHAR2(30) := FND_API.G_MISS_CHAR

86: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
87: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , conversion_date DATE := FND_API.G_MISS_DATE
89: , conversion_date_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: -- , conversion_method VARCHAR2(30) := FND_API.G_MISS_CHAR
91: , conversion_type VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , created_by NUMBER := FND_API.G_MISS_NUM
93: , creation_date DATE := FND_API.G_MISS_DATE
94: , currency_detail_id NUMBER := FND_API.G_MISS_NUM

Line 91: , conversion_type VARCHAR2(30) := FND_API.G_MISS_CHAR

87: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , conversion_date DATE := FND_API.G_MISS_DATE
89: , conversion_date_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: -- , conversion_method VARCHAR2(30) := FND_API.G_MISS_CHAR
91: , conversion_type VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , created_by NUMBER := FND_API.G_MISS_NUM
93: , creation_date DATE := FND_API.G_MISS_DATE
94: , currency_detail_id NUMBER := FND_API.G_MISS_NUM
95: , currency_header_id NUMBER := FND_API.G_MISS_NUM

Line 92: , created_by NUMBER := FND_API.G_MISS_NUM

88: , conversion_date DATE := FND_API.G_MISS_DATE
89: , conversion_date_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: -- , conversion_method VARCHAR2(30) := FND_API.G_MISS_CHAR
91: , conversion_type VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , created_by NUMBER := FND_API.G_MISS_NUM
93: , creation_date DATE := FND_API.G_MISS_DATE
94: , currency_detail_id NUMBER := FND_API.G_MISS_NUM
95: , currency_header_id NUMBER := FND_API.G_MISS_NUM
96: , end_date_active DATE := FND_API.G_MISS_DATE

Line 93: , creation_date DATE := FND_API.G_MISS_DATE

89: , conversion_date_type VARCHAR2(30) := FND_API.G_MISS_CHAR
90: -- , conversion_method VARCHAR2(30) := FND_API.G_MISS_CHAR
91: , conversion_type VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , created_by NUMBER := FND_API.G_MISS_NUM
93: , creation_date DATE := FND_API.G_MISS_DATE
94: , currency_detail_id NUMBER := FND_API.G_MISS_NUM
95: , currency_header_id NUMBER := FND_API.G_MISS_NUM
96: , end_date_active DATE := FND_API.G_MISS_DATE
97: , fixed_value NUMBER := FND_API.G_MISS_NUM

Line 94: , currency_detail_id NUMBER := FND_API.G_MISS_NUM

90: -- , conversion_method VARCHAR2(30) := FND_API.G_MISS_CHAR
91: , conversion_type VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , created_by NUMBER := FND_API.G_MISS_NUM
93: , creation_date DATE := FND_API.G_MISS_DATE
94: , currency_detail_id NUMBER := FND_API.G_MISS_NUM
95: , currency_header_id NUMBER := FND_API.G_MISS_NUM
96: , end_date_active DATE := FND_API.G_MISS_DATE
97: , fixed_value NUMBER := FND_API.G_MISS_NUM
98: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 95: , currency_header_id NUMBER := FND_API.G_MISS_NUM

91: , conversion_type VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , created_by NUMBER := FND_API.G_MISS_NUM
93: , creation_date DATE := FND_API.G_MISS_DATE
94: , currency_detail_id NUMBER := FND_API.G_MISS_NUM
95: , currency_header_id NUMBER := FND_API.G_MISS_NUM
96: , end_date_active DATE := FND_API.G_MISS_DATE
97: , fixed_value NUMBER := FND_API.G_MISS_NUM
98: , last_updated_by NUMBER := FND_API.G_MISS_NUM
99: , last_update_date DATE := FND_API.G_MISS_DATE

Line 96: , end_date_active DATE := FND_API.G_MISS_DATE

92: , created_by NUMBER := FND_API.G_MISS_NUM
93: , creation_date DATE := FND_API.G_MISS_DATE
94: , currency_detail_id NUMBER := FND_API.G_MISS_NUM
95: , currency_header_id NUMBER := FND_API.G_MISS_NUM
96: , end_date_active DATE := FND_API.G_MISS_DATE
97: , fixed_value NUMBER := FND_API.G_MISS_NUM
98: , last_updated_by NUMBER := FND_API.G_MISS_NUM
99: , last_update_date DATE := FND_API.G_MISS_DATE
100: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 97: , fixed_value NUMBER := FND_API.G_MISS_NUM

93: , creation_date DATE := FND_API.G_MISS_DATE
94: , currency_detail_id NUMBER := FND_API.G_MISS_NUM
95: , currency_header_id NUMBER := FND_API.G_MISS_NUM
96: , end_date_active DATE := FND_API.G_MISS_DATE
97: , fixed_value NUMBER := FND_API.G_MISS_NUM
98: , last_updated_by NUMBER := FND_API.G_MISS_NUM
99: , last_update_date DATE := FND_API.G_MISS_DATE
100: , last_update_login NUMBER := FND_API.G_MISS_NUM
101: , markup_formula_id NUMBER := FND_API.G_MISS_NUM

Line 98: , last_updated_by NUMBER := FND_API.G_MISS_NUM

94: , currency_detail_id NUMBER := FND_API.G_MISS_NUM
95: , currency_header_id NUMBER := FND_API.G_MISS_NUM
96: , end_date_active DATE := FND_API.G_MISS_DATE
97: , fixed_value NUMBER := FND_API.G_MISS_NUM
98: , last_updated_by NUMBER := FND_API.G_MISS_NUM
99: , last_update_date DATE := FND_API.G_MISS_DATE
100: , last_update_login NUMBER := FND_API.G_MISS_NUM
101: , markup_formula_id NUMBER := FND_API.G_MISS_NUM
102: , markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 99: , last_update_date DATE := FND_API.G_MISS_DATE

95: , currency_header_id NUMBER := FND_API.G_MISS_NUM
96: , end_date_active DATE := FND_API.G_MISS_DATE
97: , fixed_value NUMBER := FND_API.G_MISS_NUM
98: , last_updated_by NUMBER := FND_API.G_MISS_NUM
99: , last_update_date DATE := FND_API.G_MISS_DATE
100: , last_update_login NUMBER := FND_API.G_MISS_NUM
101: , markup_formula_id NUMBER := FND_API.G_MISS_NUM
102: , markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , markup_value NUMBER := FND_API.G_MISS_NUM

Line 100: , last_update_login NUMBER := FND_API.G_MISS_NUM

96: , end_date_active DATE := FND_API.G_MISS_DATE
97: , fixed_value NUMBER := FND_API.G_MISS_NUM
98: , last_updated_by NUMBER := FND_API.G_MISS_NUM
99: , last_update_date DATE := FND_API.G_MISS_DATE
100: , last_update_login NUMBER := FND_API.G_MISS_NUM
101: , markup_formula_id NUMBER := FND_API.G_MISS_NUM
102: , markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , markup_value NUMBER := FND_API.G_MISS_NUM
104: , price_formula_id NUMBER := FND_API.G_MISS_NUM

Line 101: , markup_formula_id NUMBER := FND_API.G_MISS_NUM

97: , fixed_value NUMBER := FND_API.G_MISS_NUM
98: , last_updated_by NUMBER := FND_API.G_MISS_NUM
99: , last_update_date DATE := FND_API.G_MISS_DATE
100: , last_update_login NUMBER := FND_API.G_MISS_NUM
101: , markup_formula_id NUMBER := FND_API.G_MISS_NUM
102: , markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , markup_value NUMBER := FND_API.G_MISS_NUM
104: , price_formula_id NUMBER := FND_API.G_MISS_NUM
105: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 102: , markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR

98: , last_updated_by NUMBER := FND_API.G_MISS_NUM
99: , last_update_date DATE := FND_API.G_MISS_DATE
100: , last_update_login NUMBER := FND_API.G_MISS_NUM
101: , markup_formula_id NUMBER := FND_API.G_MISS_NUM
102: , markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , markup_value NUMBER := FND_API.G_MISS_NUM
104: , price_formula_id NUMBER := FND_API.G_MISS_NUM
105: , program_application_id NUMBER := FND_API.G_MISS_NUM
106: , program_id NUMBER := FND_API.G_MISS_NUM

Line 103: , markup_value NUMBER := FND_API.G_MISS_NUM

99: , last_update_date DATE := FND_API.G_MISS_DATE
100: , last_update_login NUMBER := FND_API.G_MISS_NUM
101: , markup_formula_id NUMBER := FND_API.G_MISS_NUM
102: , markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , markup_value NUMBER := FND_API.G_MISS_NUM
104: , price_formula_id NUMBER := FND_API.G_MISS_NUM
105: , program_application_id NUMBER := FND_API.G_MISS_NUM
106: , program_id NUMBER := FND_API.G_MISS_NUM
107: , program_update_date DATE := FND_API.G_MISS_DATE

Line 104: , price_formula_id NUMBER := FND_API.G_MISS_NUM

100: , last_update_login NUMBER := FND_API.G_MISS_NUM
101: , markup_formula_id NUMBER := FND_API.G_MISS_NUM
102: , markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , markup_value NUMBER := FND_API.G_MISS_NUM
104: , price_formula_id NUMBER := FND_API.G_MISS_NUM
105: , program_application_id NUMBER := FND_API.G_MISS_NUM
106: , program_id NUMBER := FND_API.G_MISS_NUM
107: , program_update_date DATE := FND_API.G_MISS_DATE
108: , request_id NUMBER := FND_API.G_MISS_NUM

Line 105: , program_application_id NUMBER := FND_API.G_MISS_NUM

101: , markup_formula_id NUMBER := FND_API.G_MISS_NUM
102: , markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , markup_value NUMBER := FND_API.G_MISS_NUM
104: , price_formula_id NUMBER := FND_API.G_MISS_NUM
105: , program_application_id NUMBER := FND_API.G_MISS_NUM
106: , program_id NUMBER := FND_API.G_MISS_NUM
107: , program_update_date DATE := FND_API.G_MISS_DATE
108: , request_id NUMBER := FND_API.G_MISS_NUM
109: , rounding_factor NUMBER := FND_API.G_MISS_NUM

Line 106: , program_id NUMBER := FND_API.G_MISS_NUM

102: , markup_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
103: , markup_value NUMBER := FND_API.G_MISS_NUM
104: , price_formula_id NUMBER := FND_API.G_MISS_NUM
105: , program_application_id NUMBER := FND_API.G_MISS_NUM
106: , program_id NUMBER := FND_API.G_MISS_NUM
107: , program_update_date DATE := FND_API.G_MISS_DATE
108: , request_id NUMBER := FND_API.G_MISS_NUM
109: , rounding_factor NUMBER := FND_API.G_MISS_NUM
110: , selling_rounding_factor NUMBER := FND_API.G_MISS_NUM

Line 107: , program_update_date DATE := FND_API.G_MISS_DATE

103: , markup_value NUMBER := FND_API.G_MISS_NUM
104: , price_formula_id NUMBER := FND_API.G_MISS_NUM
105: , program_application_id NUMBER := FND_API.G_MISS_NUM
106: , program_id NUMBER := FND_API.G_MISS_NUM
107: , program_update_date DATE := FND_API.G_MISS_DATE
108: , request_id NUMBER := FND_API.G_MISS_NUM
109: , rounding_factor NUMBER := FND_API.G_MISS_NUM
110: , selling_rounding_factor NUMBER := FND_API.G_MISS_NUM
111: , start_date_active DATE := FND_API.G_MISS_DATE

Line 108: , request_id NUMBER := FND_API.G_MISS_NUM

104: , price_formula_id NUMBER := FND_API.G_MISS_NUM
105: , program_application_id NUMBER := FND_API.G_MISS_NUM
106: , program_id NUMBER := FND_API.G_MISS_NUM
107: , program_update_date DATE := FND_API.G_MISS_DATE
108: , request_id NUMBER := FND_API.G_MISS_NUM
109: , rounding_factor NUMBER := FND_API.G_MISS_NUM
110: , selling_rounding_factor NUMBER := FND_API.G_MISS_NUM
111: , start_date_active DATE := FND_API.G_MISS_DATE
112: , to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR

Line 109: , rounding_factor NUMBER := FND_API.G_MISS_NUM

105: , program_application_id NUMBER := FND_API.G_MISS_NUM
106: , program_id NUMBER := FND_API.G_MISS_NUM
107: , program_update_date DATE := FND_API.G_MISS_DATE
108: , request_id NUMBER := FND_API.G_MISS_NUM
109: , rounding_factor NUMBER := FND_API.G_MISS_NUM
110: , selling_rounding_factor NUMBER := FND_API.G_MISS_NUM
111: , start_date_active DATE := FND_API.G_MISS_DATE
112: , to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
113: , curr_attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 110: , selling_rounding_factor NUMBER := FND_API.G_MISS_NUM

106: , program_id NUMBER := FND_API.G_MISS_NUM
107: , program_update_date DATE := FND_API.G_MISS_DATE
108: , request_id NUMBER := FND_API.G_MISS_NUM
109: , rounding_factor NUMBER := FND_API.G_MISS_NUM
110: , selling_rounding_factor NUMBER := FND_API.G_MISS_NUM
111: , start_date_active DATE := FND_API.G_MISS_DATE
112: , to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
113: , curr_attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
114: , curr_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 111: , start_date_active DATE := FND_API.G_MISS_DATE

107: , program_update_date DATE := FND_API.G_MISS_DATE
108: , request_id NUMBER := FND_API.G_MISS_NUM
109: , rounding_factor NUMBER := FND_API.G_MISS_NUM
110: , selling_rounding_factor NUMBER := FND_API.G_MISS_NUM
111: , start_date_active DATE := FND_API.G_MISS_DATE
112: , to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
113: , curr_attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
114: , curr_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , curr_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 112: , to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR

108: , request_id NUMBER := FND_API.G_MISS_NUM
109: , rounding_factor NUMBER := FND_API.G_MISS_NUM
110: , selling_rounding_factor NUMBER := FND_API.G_MISS_NUM
111: , start_date_active DATE := FND_API.G_MISS_DATE
112: , to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
113: , curr_attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
114: , curr_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , curr_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
116: , curr_attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 113: , curr_attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR

109: , rounding_factor NUMBER := FND_API.G_MISS_NUM
110: , selling_rounding_factor NUMBER := FND_API.G_MISS_NUM
111: , start_date_active DATE := FND_API.G_MISS_DATE
112: , to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
113: , curr_attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
114: , curr_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , curr_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
116: , curr_attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , precedence NUMBER := FND_API.G_MISS_NUM

Line 114: , curr_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

110: , selling_rounding_factor NUMBER := FND_API.G_MISS_NUM
111: , start_date_active DATE := FND_API.G_MISS_DATE
112: , to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
113: , curr_attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
114: , curr_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , curr_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
116: , curr_attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , precedence NUMBER := FND_API.G_MISS_NUM
118: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 115: , curr_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

111: , start_date_active DATE := FND_API.G_MISS_DATE
112: , to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
113: , curr_attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
114: , curr_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , curr_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
116: , curr_attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , precedence NUMBER := FND_API.G_MISS_NUM
118: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 116: , curr_attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR

112: , to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
113: , curr_attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
114: , curr_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , curr_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
116: , curr_attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , precedence NUMBER := FND_API.G_MISS_NUM
118: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 117: , precedence NUMBER := FND_API.G_MISS_NUM

113: , curr_attribute_type VARCHAR2(30) := FND_API.G_MISS_CHAR
114: , curr_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , curr_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
116: , curr_attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , precedence NUMBER := FND_API.G_MISS_NUM
118: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
121: );

Line 118: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

114: , curr_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , curr_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
116: , curr_attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , precedence NUMBER := FND_API.G_MISS_NUM
118: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
121: );
122:

Line 119: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

115: , curr_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
116: , curr_attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , precedence NUMBER := FND_API.G_MISS_NUM
118: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
121: );
122:
123: TYPE Curr_Details_Tbl_Type IS TABLE OF Curr_Details_Rec_Type

Line 120: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

116: , curr_attribute_value VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , precedence NUMBER := FND_API.G_MISS_NUM
118: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
119: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
121: );
122:
123: TYPE Curr_Details_Tbl_Type IS TABLE OF Curr_Details_Rec_Type
124: INDEX BY BINARY_INTEGER;

Line 129: ( currency_detail VARCHAR2(240) := FND_API.G_MISS_CHAR

125:
126: -- Curr_Details value record type
127:
128: TYPE Curr_Details_Val_Rec_Type IS RECORD
129: ( currency_detail VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
132: , price_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , to_currency VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 130: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR

126: -- Curr_Details value record type
127:
128: TYPE Curr_Details_Val_Rec_Type IS RECORD
129: ( currency_detail VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
132: , price_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , to_currency VARCHAR2(240) := FND_API.G_MISS_CHAR
134: );

Line 131: , markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR

127:
128: TYPE Curr_Details_Val_Rec_Type IS RECORD
129: ( currency_detail VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
132: , price_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , to_currency VARCHAR2(240) := FND_API.G_MISS_CHAR
134: );
135:

Line 132: , price_formula VARCHAR2(240) := FND_API.G_MISS_CHAR

128: TYPE Curr_Details_Val_Rec_Type IS RECORD
129: ( currency_detail VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
132: , price_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , to_currency VARCHAR2(240) := FND_API.G_MISS_CHAR
134: );
135:
136: TYPE Curr_Details_Val_Tbl_Type IS TABLE OF Curr_Details_Val_Rec_Type

Line 133: , to_currency VARCHAR2(240) := FND_API.G_MISS_CHAR

129: ( currency_detail VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , markup_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
132: , price_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
133: , to_currency VARCHAR2(240) := FND_API.G_MISS_CHAR
134: );
135:
136: TYPE Curr_Details_Val_Tbl_Type IS TABLE OF Curr_Details_Val_Rec_Type
137: INDEX BY BINARY_INTEGER;

Line 208: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

204: * @rep:displayname Process Currency
205: */
206: PROCEDURE Process_Currency
207: ( p_api_version_number IN NUMBER
208: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
209: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
210: , p_commit IN VARCHAR2 := FND_API.G_FALSE
211: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
212: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 209: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

205: */
206: PROCEDURE Process_Currency
207: ( p_api_version_number IN NUMBER
208: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
209: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
210: , p_commit IN VARCHAR2 := FND_API.G_FALSE
211: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
212: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
213: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 210: , p_commit IN VARCHAR2 := FND_API.G_FALSE

206: PROCEDURE Process_Currency
207: ( p_api_version_number IN NUMBER
208: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
209: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
210: , p_commit IN VARCHAR2 := FND_API.G_FALSE
211: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
212: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
213: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
214: , p_CURR_LISTS_rec IN Curr_Lists_Rec_Type :=

Line 246: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

242: -- End of Comments
243:
244: PROCEDURE Lock_Currency
245: ( p_api_version_number IN NUMBER
246: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
247: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
248: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
249: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
250: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 247: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

243:
244: PROCEDURE Lock_Currency
245: ( p_api_version_number IN NUMBER
246: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
247: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
248: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
249: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
250: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
251: , p_CURR_LISTS_rec IN Curr_Lists_Rec_Type :=

Line 283: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

279: -- End of Comments
280:
281: PROCEDURE Get_Currency
282: ( p_api_version_number IN NUMBER
283: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
284: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
285: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
286: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
287: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 284: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

280:
281: PROCEDURE Get_Currency
282: ( p_api_version_number IN NUMBER
283: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
284: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
285: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
286: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
287: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
288: , p_currency_header_id IN NUMBER :=

Line 289: FND_API.G_MISS_NUM

285: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
286: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
287: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
288: , p_currency_header_id IN NUMBER :=
289: FND_API.G_MISS_NUM
290: , p_currency_header IN VARCHAR2 :=
291: FND_API.G_MISS_CHAR
292: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ Curr_Lists_Rec_Type
293: , x_CURR_LISTS_val_rec OUT NOCOPY /* file.sql.39 change */ Curr_Lists_Val_Rec_Type

Line 291: FND_API.G_MISS_CHAR

287: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
288: , p_currency_header_id IN NUMBER :=
289: FND_API.G_MISS_NUM
290: , p_currency_header IN VARCHAR2 :=
291: FND_API.G_MISS_CHAR
292: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ Curr_Lists_Rec_Type
293: , x_CURR_LISTS_val_rec OUT NOCOPY /* file.sql.39 change */ Curr_Lists_Val_Rec_Type
294: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ Curr_Details_Tbl_Type
295: , x_CURR_DETAILS_val_tbl OUT NOCOPY /* file.sql.39 change */ Curr_Details_Val_Tbl_Type