APPS.AK_OBJECT3_PVT dependencies on FND_API

Line 35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

31: -- Version Initial version number = 1.0
32: -- History Current version number = 1.0
33: --=======================================================
34: procedure UPDATE_ATTRIBUTE (
35: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36: p_api_version_number IN NUMBER,
37: p_init_msg_tbl IN BOOLEAN := FALSE,
38: p_msg_count OUT NOCOPY NUMBER,
39: p_msg_data OUT NOCOPY VARCHAR2,

Line 44: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

40: p_return_status OUT NOCOPY VARCHAR2,
41: p_database_object_name IN VARCHAR2,
42: p_attribute_application_id IN NUMBER,
43: p_attribute_code IN VARCHAR2,
44: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
46: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
47: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 45: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,

41: p_database_object_name IN VARCHAR2,
42: p_attribute_application_id IN NUMBER,
43: p_attribute_code IN VARCHAR2,
44: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
46: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
47: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 46: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,

42: p_attribute_application_id IN NUMBER,
43: p_attribute_code IN VARCHAR2,
44: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
46: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
47: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 47: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,

43: p_attribute_code IN VARCHAR2,
44: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
46: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
47: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 48: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

44: p_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
46: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
47: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 49: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

45: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
46: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
47: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 50: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

46: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
47: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 51: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

47: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 52: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

48: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 53: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

49: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 54: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

50: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
58: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

Line 55: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

51: p_data_source_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
58: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
59: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 56: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

52: p_data_storage_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
58: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
59: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 57: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

53: p_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
58: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
59: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 58: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

54: p_base_table_column_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
58: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
59: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 59: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

55: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
58: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
59: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 60: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

56: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
58: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
59: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 61: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

57: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
58: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
59: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 62: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

58: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
59: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 63: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

59: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
60: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 64: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

60: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 65: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

61: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 66: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

62: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
63: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 67: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

63: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 68: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

64: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 69: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

65: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 70: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

66: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 71: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

67: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 72: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

68: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 73: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

69: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 74: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

70: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 75: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

71: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 76: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

72: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 77: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

73: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 78: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

74: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 79: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

75: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 80: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

76: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 81: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

77: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 82: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

78: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 83: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

79: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
87: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 84: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

80: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
87: p_creation_date IN DATE := FND_API.G_MISS_DATE,
88: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 85: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

81: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
87: p_creation_date IN DATE := FND_API.G_MISS_DATE,
88: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
89: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 86: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

82: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
87: p_creation_date IN DATE := FND_API.G_MISS_DATE,
88: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
89: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
90: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 87: p_creation_date IN DATE := FND_API.G_MISS_DATE,

83: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
87: p_creation_date IN DATE := FND_API.G_MISS_DATE,
88: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
89: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
90: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
91: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 88: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

84: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
87: p_creation_date IN DATE := FND_API.G_MISS_DATE,
88: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
89: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
90: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
91: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
92: p_pass IN NUMBER,

Line 89: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

85: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
87: p_creation_date IN DATE := FND_API.G_MISS_DATE,
88: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
89: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
90: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
91: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
92: p_pass IN NUMBER,
93: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 90: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

86: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
87: p_creation_date IN DATE := FND_API.G_MISS_DATE,
88: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
89: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
90: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
91: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
92: p_pass IN NUMBER,
93: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
94: );

Line 91: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

87: p_creation_date IN DATE := FND_API.G_MISS_DATE,
88: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
89: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
90: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
91: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
92: p_pass IN NUMBER,
93: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
94: );
95:

Line 121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

117: -- Version Initial version number = 1.0
118: -- History Current version number = 1.0
119: --=======================================================
120: procedure UPDATE_ATTRIBUTE_NAVIGATION (
121: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122: p_api_version_number IN NUMBER,
123: p_init_msg_tbl IN BOOLEAN := FALSE,
124: p_msg_count OUT NOCOPY NUMBER,
125: p_msg_data OUT NOCOPY VARCHAR2,

Line 133: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

129: p_attribute_code IN VARCHAR2,
130: p_value_varchar2 IN VARCHAR2,
131: p_value_date IN DATE,
132: p_value_number IN NUMBER,
133: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 134: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

130: p_value_varchar2 IN VARCHAR2,
131: p_value_date IN DATE,
132: p_value_number IN NUMBER,
133: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 135: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

131: p_value_date IN DATE,
132: p_value_number IN NUMBER,
133: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 136: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

132: p_value_number IN NUMBER,
133: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 137: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

133: p_to_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
134: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 138: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

134: p_to_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 139: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

135: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 140: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

136: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 141: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

137: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 142: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

138: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 143: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

139: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 144: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

140: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 145: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

141: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 146: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

142: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 147: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

143: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 148: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

144: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 149: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

145: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 150: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

146: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

147: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 152: p_creation_date IN DATE := FND_API.G_MISS_DATE,

148: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
156: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

149: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
156: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
157: p_pass IN NUMBER,

Line 154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

150: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
156: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
157: p_pass IN NUMBER,
158: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

151: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
156: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
157: p_pass IN NUMBER,
158: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
159: );

Line 156: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

152: p_creation_date IN DATE := FND_API.G_MISS_DATE,
153: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
154: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
155: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
156: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
157: p_pass IN NUMBER,
158: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
159: );
160:

Line 186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

182: -- Version Initial version number = 1.0
183: -- History Current version number = 1.0
184: --=======================================================
185: procedure UPDATE_ATTRIBUTE_VALUE (
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_api_version_number IN NUMBER,
188: p_init_msg_tbl IN BOOLEAN := FALSE,
189: p_msg_count OUT NOCOPY NUMBER,
190: p_msg_data OUT NOCOPY VARCHAR2,

Line 196: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

192: p_database_object_name IN VARCHAR2,
193: p_attribute_application_id IN NUMBER,
194: p_attribute_code IN VARCHAR2,
195: p_key_value1 IN VARCHAR2,
196: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 197: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

193: p_attribute_application_id IN NUMBER,
194: p_attribute_code IN VARCHAR2,
195: p_key_value1 IN VARCHAR2,
196: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 198: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

194: p_attribute_code IN VARCHAR2,
195: p_key_value1 IN VARCHAR2,
196: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 199: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

195: p_key_value1 IN VARCHAR2,
196: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 200: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

196: p_key_value2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 201: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

197: p_key_value3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 202: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

198: p_key_value4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_value_date IN DATE := FND_API.G_MISS_DATE,

Line 203: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

199: p_key_value5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_value_date IN DATE := FND_API.G_MISS_DATE,
207: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

Line 204: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

200: p_key_value6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_value_date IN DATE := FND_API.G_MISS_DATE,
207: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
208: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 205: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

201: p_key_value7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_value_date IN DATE := FND_API.G_MISS_DATE,
207: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
208: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
209: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 206: p_value_date IN DATE := FND_API.G_MISS_DATE,

202: p_key_value8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_value_date IN DATE := FND_API.G_MISS_DATE,
207: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
208: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
209: p_creation_date IN DATE := FND_API.G_MISS_DATE,
210: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 207: p_value_number IN NUMBER := FND_API.G_MISS_NUM,

203: p_key_value9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_value_date IN DATE := FND_API.G_MISS_DATE,
207: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
208: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
209: p_creation_date IN DATE := FND_API.G_MISS_DATE,
210: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 208: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

204: p_key_value10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_value_date IN DATE := FND_API.G_MISS_DATE,
207: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
208: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
209: p_creation_date IN DATE := FND_API.G_MISS_DATE,
210: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 209: p_creation_date IN DATE := FND_API.G_MISS_DATE,

205: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206: p_value_date IN DATE := FND_API.G_MISS_DATE,
207: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
208: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
209: p_creation_date IN DATE := FND_API.G_MISS_DATE,
210: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
213: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE

Line 210: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

206: p_value_date IN DATE := FND_API.G_MISS_DATE,
207: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
208: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
209: p_creation_date IN DATE := FND_API.G_MISS_DATE,
210: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
213: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
214: );

Line 211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

207: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
208: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
209: p_creation_date IN DATE := FND_API.G_MISS_DATE,
210: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
213: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
214: );
215:

Line 212: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

208: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
209: p_creation_date IN DATE := FND_API.G_MISS_DATE,
210: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
213: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
214: );
215:
216: --=======================================================

Line 213: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE

209: p_creation_date IN DATE := FND_API.G_MISS_DATE,
210: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
213: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
214: );
215:
216: --=======================================================
217: -- Procedure UPDATE_OBJECT

Line 240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

236: -- Version Initial version number = 1.0
237: -- History Current version number = 1.0
238: --=======================================================
239: procedure UPDATE_OBJECT (
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: p_api_version_number IN NUMBER,
242: p_init_msg_tbl IN BOOLEAN := FALSE,
243: p_msg_count OUT NOCOPY NUMBER,
244: p_msg_data OUT NOCOPY VARCHAR2,

Line 247: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

243: p_msg_count OUT NOCOPY NUMBER,
244: p_msg_data OUT NOCOPY VARCHAR2,
245: p_return_status OUT NOCOPY VARCHAR2,
246: p_database_object_name IN VARCHAR2,
247: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 248: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

244: p_msg_data OUT NOCOPY VARCHAR2,
245: p_return_status OUT NOCOPY VARCHAR2,
246: p_database_object_name IN VARCHAR2,
247: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 249: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

245: p_return_status OUT NOCOPY VARCHAR2,
246: p_database_object_name IN VARCHAR2,
247: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 250: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

246: p_database_object_name IN VARCHAR2,
247: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 251: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

247: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 252: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

248: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 253: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

249: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 254: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

250: p_primary_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 255: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

251: p_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 256: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

252: p_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 257: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

253: p_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
254: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 258: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

254: p_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 259: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

255: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 260: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

256: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 261: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

257: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 262: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

258: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
259: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 263: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

259: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 264: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

260: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 265: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

261: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 266: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

262: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 267: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

263: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 268: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

264: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
272: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 269: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

265: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
272: p_creation_date IN DATE := FND_API.G_MISS_DATE,
273: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 270: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

266: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
272: p_creation_date IN DATE := FND_API.G_MISS_DATE,
273: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
274: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 271: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

267: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
272: p_creation_date IN DATE := FND_API.G_MISS_DATE,
273: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
274: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
275: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 272: p_creation_date IN DATE := FND_API.G_MISS_DATE,

268: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
272: p_creation_date IN DATE := FND_API.G_MISS_DATE,
273: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
274: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
275: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
276: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

Line 273: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

269: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
272: p_creation_date IN DATE := FND_API.G_MISS_DATE,
273: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
274: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
275: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
276: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
277: p_pass IN NUMBER,

Line 274: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

270: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
272: p_creation_date IN DATE := FND_API.G_MISS_DATE,
273: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
274: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
275: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
276: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
277: p_pass IN NUMBER,
278: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

Line 275: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

271: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
272: p_creation_date IN DATE := FND_API.G_MISS_DATE,
273: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
274: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
275: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
276: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
277: p_pass IN NUMBER,
278: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
279: );

Line 276: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

272: p_creation_date IN DATE := FND_API.G_MISS_DATE,
273: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
274: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
275: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
276: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
277: p_pass IN NUMBER,
278: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
279: );
280:

Line 332: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

328: -- Version Initial version number = 1.0
329: -- History Current version number = 1.0
330: --=======================================================
331: procedure UPLOAD_OBJECT (
332: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
333: p_api_version_number IN NUMBER,
334: p_return_status OUT NOCOPY VARCHAR2,
335: p_index IN OUT NOCOPY NUMBER,
336: p_loader_timestamp IN DATE,

Line 337: p_line_num IN NUMBER := FND_API.G_MISS_NUM,

333: p_api_version_number IN NUMBER,
334: p_return_status OUT NOCOPY VARCHAR2,
335: p_index IN OUT NOCOPY NUMBER,
336: p_loader_timestamp IN DATE,
337: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
338: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
339: p_line_num_out OUT NOCOPY NUMBER,
340: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
341: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp,