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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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
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;
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: );
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:
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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
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;
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
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: );
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:
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
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;
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
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
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 :=
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
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 :=
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
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 :=
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
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