eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_REGION_GRP dependencies on FND_API

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

19: -- Version Initial version number = 1.0
20: -- History Current version number = 1.0
21: --=======================================================
22: procedure CREATE_ITEM (
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_api_version_number IN NUMBER,
25: p_init_msg_tbl IN BOOLEAN := FALSE,
26: p_msg_count OUT NOCOPY NUMBER,
27: p_msg_data OUT NOCOPY VARCHAR2,

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

40: p_vertical_alignment IN VARCHAR2,
41: p_horizontal_alignment IN VARCHAR2,
42: p_item_style IN VARCHAR2,
43: p_object_attribute_flag IN VARCHAR2,
44: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_update_flag IN VARCHAR2,
46: p_required_flag IN VARCHAR2,
47: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

43: p_object_attribute_flag IN VARCHAR2,
44: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_update_flag IN VARCHAR2,
46: p_required_flag IN VARCHAR2,
47: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
50: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
51: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

44: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_update_flag IN VARCHAR2,
46: p_required_flag IN VARCHAR2,
47: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
50: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
51: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

45: p_update_flag IN VARCHAR2,
46: p_required_flag IN VARCHAR2,
47: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
50: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
51: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

46: p_required_flag IN VARCHAR2,
47: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
50: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
51: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

47: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
50: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
51: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

48: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
50: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
51: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

49: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
50: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
51: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

50: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
51: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

51: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
52: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

52: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 57: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

53: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,

Line 58: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

54: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
62: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 59: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

55: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
62: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_display_height IN NUMBER := FND_API.G_MISS_NUM,

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

56: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
62: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
64: p_submit IN VARCHAR2,

Line 61: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,

57: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
58: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
62: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
64: p_submit IN VARCHAR2,
65: p_encrypt IN VARCHAR2,

Line 62: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,

58: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
59: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
62: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
64: p_submit IN VARCHAR2,
65: p_encrypt IN VARCHAR2,
66: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 63: p_display_height IN NUMBER := FND_API.G_MISS_NUM,

59: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
62: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
64: p_submit IN VARCHAR2,
65: p_encrypt IN VARCHAR2,
66: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

62: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
64: p_submit IN VARCHAR2,
65: p_encrypt IN VARCHAR2,
66: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

63: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
64: p_submit IN VARCHAR2,
65: p_encrypt IN VARCHAR2,
66: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

64: p_submit IN VARCHAR2,
65: p_encrypt IN VARCHAR2,
66: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 69: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

65: p_encrypt IN VARCHAR2,
66: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

66: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

67: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
68: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

68: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

69: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
70: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

70: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
71: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

71: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
72: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

72: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
73: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

73: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
74: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

74: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
75: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

75: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
76: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 80: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,

76: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
77: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

77: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
78: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

78: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
79: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

79: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
80: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 84: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,

80: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
81: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

81: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
82: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 86: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

82: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
83: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 87: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,

83: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
84: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 88: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

84: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
85: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 89: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,

85: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_expansion IN NUMBER := FND_API.G_MISS_NUM,

Line 90: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

86: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
87: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
94: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,

Line 91: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,

87: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
88: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
94: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
95: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 92: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

88: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
94: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
95: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 93: p_expansion IN NUMBER := FND_API.G_MISS_NUM,

89: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
90: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
94: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
95: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 94: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,

90: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
91: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
94: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
95: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute_label_long IN VARCHAR2,

Line 95: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,

91: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
92: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
94: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
95: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute_label_long IN VARCHAR2,
99: p_attribute_label_short IN VARCHAR2,

Line 96: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,

92: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
93: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
94: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
95: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute_label_long IN VARCHAR2,
99: p_attribute_label_short IN VARCHAR2,
100: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 97: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

93: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
94: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
95: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute_label_long IN VARCHAR2,
99: p_attribute_label_short IN VARCHAR2,
100: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
101: ) is

Line 100: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

96: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
97: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_attribute_label_long IN VARCHAR2,
99: p_attribute_label_short IN VARCHAR2,
100: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
101: ) is
102: l_api_version_number CONSTANT number := 1.0;
103: l_api_name CONSTANT varchar2(30) := 'Create_Item';
104: l_return_status VARCHAR2(1);

Line 109: IF NOT FND_API.Compatible_API_Call (

105: l_pass NUMBER := 2;
106: l_copy_redo_flag BOOLEAN := FALSE;
107: begin
108: -- Check API version number
109: IF NOT FND_API.Compatible_API_Call (
110: l_api_version_number, p_api_version_number, l_api_name,
111: G_PKG_NAME) then
112: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: return;

Line 112: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

108: -- Check API version number
109: IF NOT FND_API.Compatible_API_Call (
110: l_api_version_number, p_api_version_number, l_api_name,
111: G_PKG_NAME) then
112: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: return;
114: END IF;
115:
116: -- Initialize the message table if requested.

Line 208: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

204: p_copy_redo_flag => l_copy_redo_flag
205: );
206:
207: -- If API call returns with an error status...
208: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
209: (l_return_status = FND_API.G_RET_STS_ERROR) then
210: --dbms_output.put_line(l_api_name || ' Create_Item failed');
211: RAISE FND_API.G_EXC_ERROR;
212: end if;

Line 209: (l_return_status = FND_API.G_RET_STS_ERROR) then

205: );
206:
207: -- If API call returns with an error status...
208: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
209: (l_return_status = FND_API.G_RET_STS_ERROR) then
210: --dbms_output.put_line(l_api_name || ' Create_Item failed');
211: RAISE FND_API.G_EXC_ERROR;
212: end if;
213:

Line 211: RAISE FND_API.G_EXC_ERROR;

207: -- If API call returns with an error status...
208: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
209: (l_return_status = FND_API.G_RET_STS_ERROR) then
210: --dbms_output.put_line(l_api_name || ' Create_Item failed');
211: RAISE FND_API.G_EXC_ERROR;
212: end if;
213:
214: p_return_status := FND_API.G_RET_STS_SUCCESS;
215:

Line 214: p_return_status := FND_API.G_RET_STS_SUCCESS;

210: --dbms_output.put_line(l_api_name || ' Create_Item failed');
211: RAISE FND_API.G_EXC_ERROR;
212: end if;
213:
214: p_return_status := FND_API.G_RET_STS_SUCCESS;
215:
216: EXCEPTION
217: WHEN FND_API.G_EXC_ERROR THEN
218: p_return_status := FND_API.G_RET_STS_ERROR;

Line 217: WHEN FND_API.G_EXC_ERROR THEN

213:
214: p_return_status := FND_API.G_RET_STS_SUCCESS;
215:
216: EXCEPTION
217: WHEN FND_API.G_EXC_ERROR THEN
218: p_return_status := FND_API.G_RET_STS_ERROR;
219: rollback to start_create_item;
220: WHEN OTHERS THEN
221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 218: p_return_status := FND_API.G_RET_STS_ERROR;

214: p_return_status := FND_API.G_RET_STS_SUCCESS;
215:
216: EXCEPTION
217: WHEN FND_API.G_EXC_ERROR THEN
218: p_return_status := FND_API.G_RET_STS_ERROR;
219: rollback to start_create_item;
220: WHEN OTHERS THEN
221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: rollback to start_create_item;

Line 221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

217: WHEN FND_API.G_EXC_ERROR THEN
218: p_return_status := FND_API.G_RET_STS_ERROR;
219: rollback to start_create_item;
220: WHEN OTHERS THEN
221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: rollback to start_create_item;
223: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
224: SUBSTR (SQLERRM, 1, 240) );
225: FND_MSG_PUB.Add;

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

243: -- Version Initial version number = 1.0
244: -- History Current version number = 1.0
245: --=======================================================
246: procedure CREATE_REGION (
247: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
248: p_api_version_number IN NUMBER,
249: p_init_msg_tbl IN BOOLEAN := FALSE,
250: p_msg_count OUT NOCOPY NUMBER,
251: p_msg_data OUT NOCOPY VARCHAR2,

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

253: p_region_application_id IN NUMBER,
254: p_region_code IN VARCHAR2,
255: p_database_object_name IN VARCHAR2,
256: p_region_style IN VARCHAR2,
257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
259: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 258: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,

254: p_region_code IN VARCHAR2,
255: p_database_object_name IN VARCHAR2,
256: p_region_style IN VARCHAR2,
257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
259: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

255: p_database_object_name IN VARCHAR2,
256: p_region_style IN VARCHAR2,
257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
259: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

256: p_region_style IN VARCHAR2,
257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
259: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,

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

257: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
259: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

258: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
259: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

259: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
260: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_isform_flag IN VARCHAR2,

Line 264: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,

260: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_isform_flag IN VARCHAR2,
268: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

261: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_isform_flag IN VARCHAR2,
268: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

262: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_isform_flag IN VARCHAR2,
268: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

264: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
265: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_isform_flag IN VARCHAR2,
268: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

265: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
266: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_isform_flag IN VARCHAR2,
268: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

266: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
267: p_isform_flag IN VARCHAR2,
268: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 271: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

267: p_isform_flag IN VARCHAR2,
268: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 272: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,

268: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 273: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

269: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 274: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

270: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 275: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

271: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 276: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

272: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
273: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 277: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

273: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 278: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

274: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 279: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

275: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 280: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,

276: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 281: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,

277: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_name IN VARCHAR2,

Line 282: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,

278: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_name IN VARCHAR2,
286: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 283: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,

279: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_name IN VARCHAR2,
286: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
287: ) is

Line 284: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,

280: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_name IN VARCHAR2,
286: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
287: ) is
288: l_api_version_number CONSTANT number := 1.0;

Line 286: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

282: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_name IN VARCHAR2,
286: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
287: ) is
288: l_api_version_number CONSTANT number := 1.0;
289: l_api_name CONSTANT varchar2(30) := 'Create_Region';
290: l_return_status VARCHAR2(1);

Line 295: IF NOT FND_API.Compatible_API_Call (

291: l_pass NUMBER := 2;
292: l_copy_redo_flag BOOLEAN := FALSE;
293: begin
294: -- Check API version number
295: IF NOT FND_API.Compatible_API_Call (
296: l_api_version_number, p_api_version_number, l_api_name,
297: G_PKG_NAME) then
298: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: return;

Line 298: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

294: -- Check API version number
295: IF NOT FND_API.Compatible_API_Call (
296: l_api_version_number, p_api_version_number, l_api_name,
297: G_PKG_NAME) then
298: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: return;
300: END IF;
301:
302: -- Initialize the message table if requested.

Line 356: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

352: p_copy_redo_flag => l_copy_redo_flag
353: );
354:
355: -- If API call returns with an error status...
356: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
357: (l_return_status = FND_API.G_RET_STS_ERROR) then
358: --dbms_output.put_line(l_api_name || ' Create_Region failed');
359: RAISE FND_API.G_EXC_ERROR;
360: end if;

Line 357: (l_return_status = FND_API.G_RET_STS_ERROR) then

353: );
354:
355: -- If API call returns with an error status...
356: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
357: (l_return_status = FND_API.G_RET_STS_ERROR) then
358: --dbms_output.put_line(l_api_name || ' Create_Region failed');
359: RAISE FND_API.G_EXC_ERROR;
360: end if;
361:

Line 359: RAISE FND_API.G_EXC_ERROR;

355: -- If API call returns with an error status...
356: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
357: (l_return_status = FND_API.G_RET_STS_ERROR) then
358: --dbms_output.put_line(l_api_name || ' Create_Region failed');
359: RAISE FND_API.G_EXC_ERROR;
360: end if;
361:
362: p_return_status := FND_API.G_RET_STS_SUCCESS;
363:

Line 362: p_return_status := FND_API.G_RET_STS_SUCCESS;

358: --dbms_output.put_line(l_api_name || ' Create_Region failed');
359: RAISE FND_API.G_EXC_ERROR;
360: end if;
361:
362: p_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: p_return_status := FND_API.G_RET_STS_ERROR;

Line 365: WHEN FND_API.G_EXC_ERROR THEN

361:
362: p_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: p_return_status := FND_API.G_RET_STS_ERROR;
367: rollback to start_create_region;
368: WHEN OTHERS THEN
369: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 366: p_return_status := FND_API.G_RET_STS_ERROR;

362: p_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: p_return_status := FND_API.G_RET_STS_ERROR;
367: rollback to start_create_region;
368: WHEN OTHERS THEN
369: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: rollback to start_create_region;

Line 369: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

365: WHEN FND_API.G_EXC_ERROR THEN
366: p_return_status := FND_API.G_RET_STS_ERROR;
367: rollback to start_create_region;
368: WHEN OTHERS THEN
369: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: rollback to start_create_region;
371: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
372: SUBSTR (SQLERRM, 1, 240) );
373: FND_MSG_PUB.Add;

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

400: -- Version Initial version number = 1.0
401: -- History Current version number = 1.0
402: --=======================================================
403: procedure DELETE_ITEM (
404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
405: p_api_version_number IN NUMBER,
406: p_init_msg_tbl IN BOOLEAN := FALSE,
407: p_msg_count OUT NOCOPY NUMBER,
408: p_msg_data OUT NOCOPY VARCHAR2,

Line 421: IF NOT FND_API.Compatible_API_Call (

417: l_api_name CONSTANT varchar2(30) := 'Delete_Item';
418: l_return_status VARCHAR2(1);
419: begin
420: -- Check API version number
421: IF NOT FND_API.Compatible_API_Call (
422: l_api_version_number, p_api_version_number, l_api_name,
423: G_PKG_NAME) then
424: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: return;

Line 424: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

420: -- Check API version number
421: IF NOT FND_API.Compatible_API_Call (
422: l_api_version_number, p_api_version_number, l_api_name,
423: G_PKG_NAME) then
424: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: return;
426: END IF;
427:
428: -- Initialize the message table if requested.

Line 451: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

447: p_delete_cascade => p_delete_cascade
448: );
449:
450: -- If API call returns with an error status...
451: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
452: (l_return_status = FND_API.G_RET_STS_ERROR) then
453: RAISE FND_API.G_EXC_ERROR;
454: end if;
455:

Line 452: (l_return_status = FND_API.G_RET_STS_ERROR) then

448: );
449:
450: -- If API call returns with an error status...
451: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
452: (l_return_status = FND_API.G_RET_STS_ERROR) then
453: RAISE FND_API.G_EXC_ERROR;
454: end if;
455:
456: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 453: RAISE FND_API.G_EXC_ERROR;

449:
450: -- If API call returns with an error status...
451: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
452: (l_return_status = FND_API.G_RET_STS_ERROR) then
453: RAISE FND_API.G_EXC_ERROR;
454: end if;
455:
456: p_return_status := FND_API.G_RET_STS_SUCCESS;
457:

Line 456: p_return_status := FND_API.G_RET_STS_SUCCESS;

452: (l_return_status = FND_API.G_RET_STS_ERROR) then
453: RAISE FND_API.G_EXC_ERROR;
454: end if;
455:
456: p_return_status := FND_API.G_RET_STS_SUCCESS;
457:
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: p_return_status := FND_API.G_RET_STS_ERROR;

Line 459: WHEN FND_API.G_EXC_ERROR THEN

455:
456: p_return_status := FND_API.G_RET_STS_SUCCESS;
457:
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: p_return_status := FND_API.G_RET_STS_ERROR;
461: rollback to start_delete_item;
462: WHEN OTHERS THEN
463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 460: p_return_status := FND_API.G_RET_STS_ERROR;

456: p_return_status := FND_API.G_RET_STS_SUCCESS;
457:
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: p_return_status := FND_API.G_RET_STS_ERROR;
461: rollback to start_delete_item;
462: WHEN OTHERS THEN
463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: rollback to start_delete_item;

Line 463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

459: WHEN FND_API.G_EXC_ERROR THEN
460: p_return_status := FND_API.G_RET_STS_ERROR;
461: rollback to start_delete_item;
462: WHEN OTHERS THEN
463: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: rollback to start_delete_item;
465: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
466: SUBSTR (SQLERRM, 1, 240) );
467: FND_MSG_PUB.Add;

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

492: -- Version Initial version number = 1.0
493: -- History Current version number = 1.0
494: --=======================================================
495: procedure DELETE_REGION (
496: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
497: p_api_version_number IN NUMBER,
498: p_init_msg_tbl IN BOOLEAN := FALSE,
499: p_msg_count OUT NOCOPY NUMBER,
500: p_msg_data OUT NOCOPY VARCHAR2,

Line 511: IF NOT FND_API.Compatible_API_Call (

507: l_api_name CONSTANT varchar2(30) := 'Delete_Region';
508: l_return_status VARCHAR2(1);
509: begin
510: -- Check API version number
511: IF NOT FND_API.Compatible_API_Call (
512: l_api_version_number, p_api_version_number, l_api_name,
513: G_PKG_NAME) then
514: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: return;

Line 514: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

510: -- Check API version number
511: IF NOT FND_API.Compatible_API_Call (
512: l_api_version_number, p_api_version_number, l_api_name,
513: G_PKG_NAME) then
514: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: return;
516: END IF;
517:
518: -- Initialize the message table if requested.

Line 539: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

535: p_delete_cascade => p_delete_cascade
536: );
537:
538: -- If API call returns with an error status...
539: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
540: (l_return_status = FND_API.G_RET_STS_ERROR) then
541: RAISE FND_API.G_EXC_ERROR;
542: end if;
543:

Line 540: (l_return_status = FND_API.G_RET_STS_ERROR) then

536: );
537:
538: -- If API call returns with an error status...
539: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
540: (l_return_status = FND_API.G_RET_STS_ERROR) then
541: RAISE FND_API.G_EXC_ERROR;
542: end if;
543:
544: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 541: RAISE FND_API.G_EXC_ERROR;

537:
538: -- If API call returns with an error status...
539: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
540: (l_return_status = FND_API.G_RET_STS_ERROR) then
541: RAISE FND_API.G_EXC_ERROR;
542: end if;
543:
544: p_return_status := FND_API.G_RET_STS_SUCCESS;
545:

Line 544: p_return_status := FND_API.G_RET_STS_SUCCESS;

540: (l_return_status = FND_API.G_RET_STS_ERROR) then
541: RAISE FND_API.G_EXC_ERROR;
542: end if;
543:
544: p_return_status := FND_API.G_RET_STS_SUCCESS;
545:
546: EXCEPTION
547: WHEN FND_API.G_EXC_ERROR THEN
548: p_return_status := FND_API.G_RET_STS_ERROR;

Line 547: WHEN FND_API.G_EXC_ERROR THEN

543:
544: p_return_status := FND_API.G_RET_STS_SUCCESS;
545:
546: EXCEPTION
547: WHEN FND_API.G_EXC_ERROR THEN
548: p_return_status := FND_API.G_RET_STS_ERROR;
549: rollback to start_delete_region;
550: WHEN OTHERS THEN
551: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 548: p_return_status := FND_API.G_RET_STS_ERROR;

544: p_return_status := FND_API.G_RET_STS_SUCCESS;
545:
546: EXCEPTION
547: WHEN FND_API.G_EXC_ERROR THEN
548: p_return_status := FND_API.G_RET_STS_ERROR;
549: rollback to start_delete_region;
550: WHEN OTHERS THEN
551: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: rollback to start_delete_region;

Line 551: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

547: WHEN FND_API.G_EXC_ERROR THEN
548: p_return_status := FND_API.G_RET_STS_ERROR;
549: rollback to start_delete_region;
550: WHEN OTHERS THEN
551: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: rollback to start_delete_region;
553: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
554: SUBSTR (SQLERRM, 1, 240) );
555: FND_MSG_PUB.Add;

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

598: -- Version Initial version number = 1.0
599: -- History Current version number = 1.0
600: --=======================================================
601: procedure DOWNLOAD_REGION (
602: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
603: p_api_version_number IN NUMBER,
604: p_init_msg_tbl IN BOOLEAN := FALSE,
605: p_msg_count OUT NOCOPY NUMBER,
606: p_msg_data OUT NOCOPY VARCHAR2,

Line 608: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,

604: p_init_msg_tbl IN BOOLEAN := FALSE,
605: p_msg_count OUT NOCOPY NUMBER,
606: p_msg_data OUT NOCOPY VARCHAR2,
607: p_return_status OUT NOCOPY VARCHAR2,
608: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
609: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
610: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
611: p_region_pk_tbl IN AK_REGION_PUB.Region_PK_Tbl_Type
612: := AK_REGION_PUB.G_MISS_REGION_PK_TBL

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

605: p_msg_count OUT NOCOPY NUMBER,
606: p_msg_data OUT NOCOPY VARCHAR2,
607: p_return_status OUT NOCOPY VARCHAR2,
608: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
609: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
610: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
611: p_region_pk_tbl IN AK_REGION_PUB.Region_PK_Tbl_Type
612: := AK_REGION_PUB.G_MISS_REGION_PK_TBL
613: ) is

Line 610: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

606: p_msg_data OUT NOCOPY VARCHAR2,
607: p_return_status OUT NOCOPY VARCHAR2,
608: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
609: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
610: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
611: p_region_pk_tbl IN AK_REGION_PUB.Region_PK_Tbl_Type
612: := AK_REGION_PUB.G_MISS_REGION_PK_TBL
613: ) is
614: l_api_version_number CONSTANT number := 1.0;

Line 626: IF NOT FND_API.Compatible_API_Call (

622: l_region_pk_tbl AK_REGION_PUB.Region_PK_Tbl_Type;
623: begin
624:
625: -- Check verion number
626: IF NOT FND_API.Compatible_API_Call (
627: l_api_version_number, p_api_version_number, l_api_name,
628: G_PKG_NAME) then
629: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: return;

Line 629: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

625: -- Check verion number
626: IF NOT FND_API.Compatible_API_Call (
627: l_api_version_number, p_api_version_number, l_api_name,
628: G_PKG_NAME) then
629: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: return;
631: END IF;
632:
633: -- Initialize the message table if requested.

Line 666: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

662: from dual;
663: end if;
664:
665: -- If API call returns with an error status...
666: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
667: (l_return_status = FND_API.G_RET_STS_ERROR) then
668: --dbms_output.put_line(G_PKG_NAME || ' download_header failed');
669: RAISE FND_API.G_EXC_ERROR;
670: end if;

Line 667: (l_return_status = FND_API.G_RET_STS_ERROR) then

663: end if;
664:
665: -- If API call returns with an error status...
666: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
667: (l_return_status = FND_API.G_RET_STS_ERROR) then
668: --dbms_output.put_line(G_PKG_NAME || ' download_header failed');
669: RAISE FND_API.G_EXC_ERROR;
670: end if;
671:

Line 669: RAISE FND_API.G_EXC_ERROR;

665: -- If API call returns with an error status...
666: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
667: (l_return_status = FND_API.G_RET_STS_ERROR) then
668: --dbms_output.put_line(G_PKG_NAME || ' download_header failed');
669: RAISE FND_API.G_EXC_ERROR;
670: end if;
671:
672: -- - call the download procedure for regions to retrieve the
673: -- selected regions and their referenced objects and attributes

Line 687: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

683: );
684:
685: -- If download call returns with an error status or
686: -- download failed to retrieve any information from the database..
687: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
688: (l_return_status = FND_API.G_RET_STS_ERROR) then
689: --dbms_output.put_line(G_PKG_NAME || 'download failed');
690: RAISE FND_API.G_EXC_ERROR;
691: end if;

Line 688: (l_return_status = FND_API.G_RET_STS_ERROR) then

684:
685: -- If download call returns with an error status or
686: -- download failed to retrieve any information from the database..
687: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
688: (l_return_status = FND_API.G_RET_STS_ERROR) then
689: --dbms_output.put_line(G_PKG_NAME || 'download failed');
690: RAISE FND_API.G_EXC_ERROR;
691: end if;
692:

Line 690: RAISE FND_API.G_EXC_ERROR;

686: -- download failed to retrieve any information from the database..
687: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
688: (l_return_status = FND_API.G_RET_STS_ERROR) then
689: --dbms_output.put_line(G_PKG_NAME || 'download failed');
690: RAISE FND_API.G_EXC_ERROR;
691: end if;
692:
693: --dbms_output.put_line('got ' || to_char(l_buffer_tbl.count) || ' lines');
694:

Line 695: p_return_status := FND_API.G_RET_STS_SUCCESS;

691: end if;
692:
693: --dbms_output.put_line('got ' || to_char(l_buffer_tbl.count) || ' lines');
694:
695: p_return_status := FND_API.G_RET_STS_SUCCESS;
696:
697: FND_MSG_PUB.Count_And_Get (
698: p_count => p_msg_count,
699: p_data => p_msg_data);

Line 702: WHEN FND_API.G_EXC_ERROR THEN

698: p_count => p_msg_count,
699: p_data => p_msg_data);
700:
701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: rollback to Start_download;
704: p_return_status := FND_API.G_RET_STS_ERROR;
705: FND_MSG_PUB.Count_And_Get (
706: p_count => p_msg_count,

Line 704: p_return_status := FND_API.G_RET_STS_ERROR;

700:
701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: rollback to Start_download;
704: p_return_status := FND_API.G_RET_STS_ERROR;
705: FND_MSG_PUB.Count_And_Get (
706: p_count => p_msg_count,
707: p_data => p_msg_data);
708: WHEN OTHERS THEN

Line 709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

705: FND_MSG_PUB.Count_And_Get (
706: p_count => p_msg_count,
707: p_data => p_msg_data);
708: WHEN OTHERS THEN
709: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: rollback to Start_download;
711: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
712: SUBSTR (SQLERRM, 1, 240) );
713: FND_MSG_PUB.Add;

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

735: -- Version Initial version number = 1.0
736: -- History Current version number = 1.0
737: --=======================================================
738: procedure UPDATE_ITEM (
739: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
740: p_api_version_number IN NUMBER,
741: p_init_msg_tbl IN BOOLEAN := FALSE,
742: p_msg_count OUT NOCOPY NUMBER,
743: p_msg_data OUT NOCOPY VARCHAR2,

Line 749: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,

745: p_region_application_id IN NUMBER,
746: p_region_code IN VARCHAR2,
747: p_attribute_application_id IN NUMBER,
748: p_attribute_code IN VARCHAR2,
749: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
750: p_node_display_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_node_query_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
753: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,

Line 750: p_node_display_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

746: p_region_code IN VARCHAR2,
747: p_attribute_application_id IN NUMBER,
748: p_attribute_code IN VARCHAR2,
749: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
750: p_node_display_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_node_query_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
753: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
754: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 751: p_node_query_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

747: p_attribute_application_id IN NUMBER,
748: p_attribute_code IN VARCHAR2,
749: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
750: p_node_display_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_node_query_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
753: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
754: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

748: p_attribute_code IN VARCHAR2,
749: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
750: p_node_display_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_node_query_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
753: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
754: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

749: p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
750: p_node_display_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_node_query_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
753: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
754: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

750: p_node_display_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
751: p_node_query_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
753: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
754: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

751: p_node_query_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
752: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
753: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
754: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_object_attribute_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

752: p_attribute_label_length IN NUMBER := FND_API.G_MISS_NUM,
753: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
754: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_object_attribute_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

753: p_display_value_length IN NUMBER := FND_API.G_MISS_NUM,
754: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_object_attribute_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_update_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 758: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,

754: p_bold IN VARCHAR2 := FND_API.G_MISS_CHAR,
755: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_object_attribute_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_update_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 759: p_object_attribute_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

755: p_italic IN VARCHAR2 := FND_API.G_MISS_CHAR,
756: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_object_attribute_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_update_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 760: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,

756: p_vertical_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
757: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_object_attribute_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_update_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 761: p_update_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

757: p_horizontal_alignment IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_object_attribute_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_update_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,

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

758: p_item_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_object_attribute_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_update_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
766: p_default_value_date IN DATE := FND_API.G_MISS_DATE,

Line 763: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

759: p_object_attribute_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
760: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_update_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
766: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
767: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

760: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
761: p_update_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
766: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
767: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

761: p_update_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
762: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
766: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
767: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

762: p_required_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
766: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
767: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,

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

763: p_security_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
766: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
767: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
771: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

764: p_default_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
766: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
767: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
771: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

765: p_default_value_number IN NUMBER := FND_API.G_MISS_NUM,
766: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
767: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
771: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

766: p_default_value_date IN DATE := FND_API.G_MISS_DATE,
767: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
771: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
774: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

767: p_lov_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
768: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
771: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
774: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 772: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

768: p_lov_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
769: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
771: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
774: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 773: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

769: p_lov_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
771: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
774: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
777: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,

Line 774: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

770: p_lov_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
771: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
774: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
777: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
778: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 775: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

771: p_lov_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
772: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
774: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
777: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
778: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
779: p_display_height IN NUMBER := FND_API.G_MISS_NUM,

Line 776: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

772: p_lov_default_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
774: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
777: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
778: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
779: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
780: p_submit IN VARCHAR2,

Line 777: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,

773: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
774: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
777: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
778: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
779: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
780: p_submit IN VARCHAR2,
781: p_encrypt IN VARCHAR2,

Line 778: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,

774: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
775: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
777: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
778: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
779: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
780: p_submit IN VARCHAR2,
781: p_encrypt IN VARCHAR2,
782: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 779: p_display_height IN NUMBER := FND_API.G_MISS_NUM,

775: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
777: p_order_sequence IN NUMBER := FND_API.G_MISS_NUM,
778: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
779: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
780: p_submit IN VARCHAR2,
781: p_encrypt IN VARCHAR2,
782: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
783: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 782: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

778: p_order_direction IN VARCHAR2 := FND_API.G_MISS_CHAR,
779: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
780: p_submit IN VARCHAR2,
781: p_encrypt IN VARCHAR2,
782: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
783: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
784: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
786: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 783: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

779: p_display_height IN NUMBER := FND_API.G_MISS_NUM,
780: p_submit IN VARCHAR2,
781: p_encrypt IN VARCHAR2,
782: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
783: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
784: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
786: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 784: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

780: p_submit IN VARCHAR2,
781: p_encrypt IN VARCHAR2,
782: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
783: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
784: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
786: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 785: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,

781: p_encrypt IN VARCHAR2,
782: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
783: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
784: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
786: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 786: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

782: p_css_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
783: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
784: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
786: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 787: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,

783: p_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
784: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
786: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
791: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 788: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,

784: p_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
785: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
786: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
791: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
792: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 789: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

785: p_nested_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
786: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
791: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
792: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 790: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,

786: p_nested_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
787: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
791: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
792: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
794: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 791: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

787: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
791: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
792: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
794: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 792: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

788: p_poplist_viewobject IN VARCHAR2 := FND_API.G_MISS_CHAR,
789: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
791: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
792: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
794: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 793: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

789: p_poplist_display_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
791: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
792: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
794: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 794: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

790: p_poplist_value_attr IN VARCHAR2 := FND_API.G_MISS_CHAR,
791: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
792: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
794: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 795: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

791: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
792: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
794: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 796: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,

792: p_item_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
794: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 797: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

793: p_css_label_class_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
794: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
801: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 798: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

794: p_menu_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
801: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 799: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

795: p_flexfield_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
801: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 800: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,

796: p_flexfield_application_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
801: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 801: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

797: p_tabular_function_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
798: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
801: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 802: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

798: p_tip_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
799: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
801: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 803: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,

799: p_tip_message_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
800: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
801: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 804: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

800: p_tip_message_application_id IN NUMBER := FND_API.G_MISS_NUM,
801: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 805: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,

801: p_flex_segment_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
802: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_expansion IN NUMBER := FND_API.G_MISS_NUM,

Line 806: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

802: p_entity_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
803: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
810: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,

Line 807: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,

803: p_anchor IN VARCHAR2 := FND_API.G_MISS_CHAR,
804: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
810: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
811: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 808: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

804: p_poplist_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
805: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
810: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
811: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 809: p_expansion IN NUMBER := FND_API.G_MISS_NUM,

805: p_user_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
806: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
810: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
811: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
813: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 810: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,

806: p_sortby_view_attribute_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
807: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
810: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
811: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
813: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 811: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,

807: p_admin_customizable IN VARCHAR2 := FND_API.G_MISS_CHAR,
808: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
810: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
811: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
813: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 812: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,

808: p_invoke_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
809: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
810: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
811: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
813: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 813: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

809: p_expansion IN NUMBER := FND_API.G_MISS_NUM,
810: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
811: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
813: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
817: ) is

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

810: p_als_max_length IN NUMBER := FND_API.G_MISS_NUM,
811: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
813: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
817: ) is
818: l_api_version_number CONSTANT number := 1.0;

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

811: p_initial_sort_sequence IN VARCHAR2 := FND_API.G_MISS_CHAR,
812: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
813: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
817: ) is
818: l_api_version_number CONSTANT number := 1.0;
819: l_api_name CONSTANT varchar2(30) := 'Update_Item';

Line 816: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

812: p_customization_application_id IN NUMBER := FND_API.G_MISS_NUM,
813: p_customization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_attribute_label_long IN VARCHAR2 := FND_API.G_MISS_CHAR,
815: p_attribute_label_short IN VARCHAR2 := FND_API.G_MISS_CHAR,
816: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
817: ) is
818: l_api_version_number CONSTANT number := 1.0;
819: l_api_name CONSTANT varchar2(30) := 'Update_Item';
820: l_return_status VARCHAR2(1);

Line 825: IF NOT FND_API.Compatible_API_Call (

821: l_pass NUMBER := 2;
822: l_copy_redo_flag BOOLEAN := FALSE;
823: begin
824: -- Check API version number
825: IF NOT FND_API.Compatible_API_Call (
826: l_api_version_number, p_api_version_number, l_api_name,
827: G_PKG_NAME) then
828: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: return;

Line 828: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

824: -- Check API version number
825: IF NOT FND_API.Compatible_API_Call (
826: l_api_version_number, p_api_version_number, l_api_name,
827: G_PKG_NAME) then
828: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: return;
830: END IF;
831:
832: -- Initialize the message table if requested.

Line 924: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

920: p_copy_redo_flag => l_copy_redo_flag
921: );
922:
923: -- If API call returns with an error status...
924: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
925: (l_return_status = FND_API.G_RET_STS_ERROR) then
926: --dbms_output.put_line(l_api_name || ' Update_Item failed');
927: RAISE FND_API.G_EXC_ERROR;
928: end if;

Line 925: (l_return_status = FND_API.G_RET_STS_ERROR) then

921: );
922:
923: -- If API call returns with an error status...
924: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
925: (l_return_status = FND_API.G_RET_STS_ERROR) then
926: --dbms_output.put_line(l_api_name || ' Update_Item failed');
927: RAISE FND_API.G_EXC_ERROR;
928: end if;
929:

Line 927: RAISE FND_API.G_EXC_ERROR;

923: -- If API call returns with an error status...
924: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
925: (l_return_status = FND_API.G_RET_STS_ERROR) then
926: --dbms_output.put_line(l_api_name || ' Update_Item failed');
927: RAISE FND_API.G_EXC_ERROR;
928: end if;
929:
930: p_return_status := FND_API.G_RET_STS_SUCCESS;
931:

Line 930: p_return_status := FND_API.G_RET_STS_SUCCESS;

926: --dbms_output.put_line(l_api_name || ' Update_Item failed');
927: RAISE FND_API.G_EXC_ERROR;
928: end if;
929:
930: p_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: p_return_status := FND_API.G_RET_STS_ERROR;

Line 933: WHEN FND_API.G_EXC_ERROR THEN

929:
930: p_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: p_return_status := FND_API.G_RET_STS_ERROR;
935: rollback to start_update_item;
936: WHEN OTHERS THEN
937: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 934: p_return_status := FND_API.G_RET_STS_ERROR;

930: p_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: p_return_status := FND_API.G_RET_STS_ERROR;
935: rollback to start_update_item;
936: WHEN OTHERS THEN
937: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: rollback to start_update_item;

Line 937: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

933: WHEN FND_API.G_EXC_ERROR THEN
934: p_return_status := FND_API.G_RET_STS_ERROR;
935: rollback to start_update_item;
936: WHEN OTHERS THEN
937: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: rollback to start_update_item;
939: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
940: SUBSTR (SQLERRM, 1, 240) );
941: FND_MSG_PUB.Add;

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

959: -- Version Initial version number = 1.0
960: -- History Current version number = 1.0
961: --=======================================================
962: procedure UPDATE_REGION (
963: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
964: p_api_version_number IN NUMBER,
965: p_init_msg_tbl IN BOOLEAN := FALSE,
966: p_msg_count OUT NOCOPY NUMBER,
967: p_msg_data OUT NOCOPY VARCHAR2,

Line 971: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

967: p_msg_data OUT NOCOPY VARCHAR2,
968: p_return_status OUT NOCOPY VARCHAR2,
969: p_region_application_id IN NUMBER,
970: p_region_code IN VARCHAR2,
971: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
972: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
975: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 972: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,

968: p_return_status OUT NOCOPY VARCHAR2,
969: p_region_application_id IN NUMBER,
970: p_region_code IN VARCHAR2,
971: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
972: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
975: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 973: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,

969: p_region_application_id IN NUMBER,
970: p_region_code IN VARCHAR2,
971: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
972: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
975: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 974: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,

970: p_region_code IN VARCHAR2,
971: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
972: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
975: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 975: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

971: p_database_object_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
972: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
975: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 976: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

972: p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
975: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,

Line 977: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,

973: p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
975: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
981: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 978: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,

974: p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
975: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
981: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 979: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

975: p_region_defaulting_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
981: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_isform_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 980: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,

976: p_region_defaulting_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
981: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_isform_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 981: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

977: p_region_validation_api_pkg IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
981: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_isform_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 982: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

978: p_region_validation_api_proc IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
981: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_isform_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 983: p_isform_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

979: p_appmodule_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
981: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_isform_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 984: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,

980: p_num_rows_display IN NUMBER := FND_API.G_MISS_NUM,
981: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_isform_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 985: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,

981: p_region_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_isform_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 986: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,

982: p_image_file_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_isform_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 987: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

983: p_isform_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 988: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,

984: p_help_target IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 989: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

985: p_style_sheet_filename IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 990: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

986: p_version IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 991: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

987: p_applicationmodule_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 992: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

988: p_add_indexed_children IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 993: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

989: p_stateful_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
997: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 994: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

990: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
997: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
998: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 995: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,

991: p_children_view_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
992: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
997: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
998: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 996: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,

992: p_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
997: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
998: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
1000: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 997: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,

993: p_advanced_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
997: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
998: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
1000: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
1001: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 998: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,

994: p_customize_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
997: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
998: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
1000: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
1001: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1002: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 999: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,

995: p_default_search_panel IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
997: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
998: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
1000: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
1001: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1002: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
1003: ) is

Line 1000: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,

996: p_results_based_search IN VARCHAR2 := FND_API.G_MISS_CHAR,
997: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
998: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
1000: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
1001: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1002: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
1003: ) is
1004: l_api_version_number CONSTANT number := 1.0;

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

997: p_display_graph_table IN VARCHAR2 := FND_API.G_MISS_CHAR,
998: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
1000: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
1001: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1002: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
1003: ) is
1004: l_api_version_number CONSTANT number := 1.0;
1005: l_api_name CONSTANT varchar2(30) := 'Update_Region';

Line 1002: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

998: p_disable_header IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_standalone IN VARCHAR2 := FND_API.G_MISS_CHAR,
1000: p_auto_customization_criteria IN VARCHAR2 := FND_API.G_MISS_CHAR,
1001: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1002: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
1003: ) is
1004: l_api_version_number CONSTANT number := 1.0;
1005: l_api_name CONSTANT varchar2(30) := 'Update_Region';
1006: l_return_status VARCHAR2(1);

Line 1011: IF NOT FND_API.Compatible_API_Call (

1007: l_pass NUMBER := 2;
1008: l_copy_redo_flag BOOLEAN := FALSE;
1009: begin
1010: -- Check API version number
1011: IF NOT FND_API.Compatible_API_Call (
1012: l_api_version_number, p_api_version_number, l_api_name,
1013: G_PKG_NAME) then
1014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: return;

Line 1014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1010: -- Check API version number
1011: IF NOT FND_API.Compatible_API_Call (
1012: l_api_version_number, p_api_version_number, l_api_name,
1013: G_PKG_NAME) then
1014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: return;
1016: END IF;
1017:
1018: -- Initialize the message table if requested.

Line 1072: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

1068: p_copy_redo_flag => l_copy_redo_flag
1069: );
1070:
1071: -- If API call returns with an error status...
1072: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1073: (l_return_status = FND_API.G_RET_STS_ERROR) then
1074: --dbms_output.put_line(l_api_name || ' Update_Region failed');
1075: RAISE FND_API.G_EXC_ERROR;
1076: end if;

Line 1073: (l_return_status = FND_API.G_RET_STS_ERROR) then

1069: );
1070:
1071: -- If API call returns with an error status...
1072: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1073: (l_return_status = FND_API.G_RET_STS_ERROR) then
1074: --dbms_output.put_line(l_api_name || ' Update_Region failed');
1075: RAISE FND_API.G_EXC_ERROR;
1076: end if;
1077:

Line 1075: RAISE FND_API.G_EXC_ERROR;

1071: -- If API call returns with an error status...
1072: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1073: (l_return_status = FND_API.G_RET_STS_ERROR) then
1074: --dbms_output.put_line(l_api_name || ' Update_Region failed');
1075: RAISE FND_API.G_EXC_ERROR;
1076: end if;
1077:
1078: p_return_status := FND_API.G_RET_STS_SUCCESS;
1079:

Line 1078: p_return_status := FND_API.G_RET_STS_SUCCESS;

1074: --dbms_output.put_line(l_api_name || ' Update_Region failed');
1075: RAISE FND_API.G_EXC_ERROR;
1076: end if;
1077:
1078: p_return_status := FND_API.G_RET_STS_SUCCESS;
1079:
1080: EXCEPTION
1081: WHEN FND_API.G_EXC_ERROR THEN
1082: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1081: WHEN FND_API.G_EXC_ERROR THEN

1077:
1078: p_return_status := FND_API.G_RET_STS_SUCCESS;
1079:
1080: EXCEPTION
1081: WHEN FND_API.G_EXC_ERROR THEN
1082: p_return_status := FND_API.G_RET_STS_ERROR;
1083: rollback to start_update_region;
1084: WHEN OTHERS THEN
1085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1082: p_return_status := FND_API.G_RET_STS_ERROR;

1078: p_return_status := FND_API.G_RET_STS_SUCCESS;
1079:
1080: EXCEPTION
1081: WHEN FND_API.G_EXC_ERROR THEN
1082: p_return_status := FND_API.G_RET_STS_ERROR;
1083: rollback to start_update_region;
1084: WHEN OTHERS THEN
1085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: rollback to start_update_region;

Line 1085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1081: WHEN FND_API.G_EXC_ERROR THEN
1082: p_return_status := FND_API.G_RET_STS_ERROR;
1083: rollback to start_update_region;
1084: WHEN OTHERS THEN
1085: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: rollback to start_update_region;
1087: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1088: SUBSTR (SQLERRM, 1, 240) );
1089: FND_MSG_PUB.Add;