APPS.AK_CUSTOM_GRP dependencies on FND_API

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

26: -- Version Initial version number = 1.0
27: -- History Current version number = 1.0
28: --=======================================================
29: procedure CREATE_CUSTOM (
30: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: p_api_version_number IN NUMBER,
32: p_init_msg_tbl IN BOOLEAN := FALSE,
33: p_msg_count OUT NOCOPY NUMBER,
34: p_msg_data OUT NOCOPY VARCHAR2,

Line 40: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

36: p_custom_appl_id IN NUMBER,
37: p_custom_code IN VARCHAR2,
38: p_region_appl_id IN NUMBER,
39: p_region_code IN VARCHAR2,
40: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,

Line 41: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

37: p_custom_code IN VARCHAR2,
38: p_region_appl_id IN NUMBER,
39: p_region_code IN VARCHAR2,
40: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,

Line 42: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

38: p_region_appl_id IN NUMBER,
39: p_region_code IN VARCHAR2,
40: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 43: p_site_id IN NUMBER := FND_API.G_MISS_NUM,

39: p_region_code IN VARCHAR2,
40: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,

Line 44: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,

40: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

41: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 46: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

42: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
43: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 47: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,

43: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

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

44: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

45: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
46: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

46: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
47: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 51: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

47: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
48: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

48: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
56: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

49: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
56: p_creation_date IN DATE := FND_API.G_MISS_DATE,
57: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

50: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
56: p_creation_date IN DATE := FND_API.G_MISS_DATE,
57: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
58: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

51: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
56: p_creation_date IN DATE := FND_API.G_MISS_DATE,
57: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
58: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
59: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

52: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
56: p_creation_date IN DATE := FND_API.G_MISS_DATE,
57: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
58: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
59: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
60: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

53: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
56: p_creation_date IN DATE := FND_API.G_MISS_DATE,
57: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
58: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
59: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
60: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
61: p_pass IN NUMBER,

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

54: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
56: p_creation_date IN DATE := FND_API.G_MISS_DATE,
57: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
58: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
59: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
60: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
61: p_pass IN NUMBER,
62: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

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

55: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
56: p_creation_date IN DATE := FND_API.G_MISS_DATE,
57: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
58: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
59: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
60: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
61: p_pass IN NUMBER,
62: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
63: );

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

56: p_creation_date IN DATE := FND_API.G_MISS_DATE,
57: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
58: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
59: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
60: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
61: p_pass IN NUMBER,
62: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
63: );
64:

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

80: -- Version Initial version number = 1.0
81: -- History Current version number = 1.0
82: --=======================================================
83: procedure CREATE_CUST_REGION (
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: p_api_version_number IN NUMBER,
86: p_init_msg_tbl IN BOOLEAN := FALSE,
87: p_msg_count OUT NOCOPY NUMBER,
88: p_msg_data OUT NOCOPY VARCHAR2,

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

91: p_custom_code IN VARCHAR2,
92: p_region_appl_id IN NUMBER,
93: p_region_code IN VARCHAR2,
94: p_property_name IN VARCHAR2,
95: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
97: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

92: p_region_appl_id IN NUMBER,
93: p_region_code IN VARCHAR2,
94: p_property_name IN VARCHAR2,
95: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
97: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
100: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

93: p_region_code IN VARCHAR2,
94: p_property_name IN VARCHAR2,
95: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
97: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
100: p_creation_date IN DATE := FND_API.G_MISS_DATE,
101: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 98: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,

94: p_property_name IN VARCHAR2,
95: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
97: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
100: p_creation_date IN DATE := FND_API.G_MISS_DATE,
101: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
102: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

95: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
96: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
97: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
100: p_creation_date IN DATE := FND_API.G_MISS_DATE,
101: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
102: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
103: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

96: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
97: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
100: p_creation_date IN DATE := FND_API.G_MISS_DATE,
101: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
102: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
103: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
104: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

97: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
98: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
100: p_creation_date IN DATE := FND_API.G_MISS_DATE,
101: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
102: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
103: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
104: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
105: p_pass IN NUMBER,

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

98: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
99: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
100: p_creation_date IN DATE := FND_API.G_MISS_DATE,
101: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
102: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
103: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
104: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
105: p_pass IN NUMBER,
106: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

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

99: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
100: p_creation_date IN DATE := FND_API.G_MISS_DATE,
101: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
102: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
103: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
104: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
105: p_pass IN NUMBER,
106: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
107: );

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

100: p_creation_date IN DATE := FND_API.G_MISS_DATE,
101: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
102: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
103: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
104: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
105: p_pass IN NUMBER,
106: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
107: );
108:

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

124: -- Version Initial version number = 1.0
125: -- History Current version number = 1.0
126: --=======================================================
127: procedure CREATE_CUST_REG_ITEM (
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129: p_api_version_number IN NUMBER,
130: p_init_msg_tbl IN BOOLEAN := FALSE,
131: p_msg_count OUT NOCOPY NUMBER,
132: p_msg_data OUT NOCOPY VARCHAR2,

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

137: p_region_code IN VARCHAR2,
138: p_attr_appl_id IN NUMBER,
139: p_attr_code IN VARCHAR2,
140: p_property_name IN VARCHAR2,
141: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
143: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 142: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,

138: p_attr_appl_id IN NUMBER,
139: p_attr_code IN VARCHAR2,
140: p_property_name IN VARCHAR2,
141: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
143: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

139: p_attr_code IN VARCHAR2,
140: p_property_name IN VARCHAR2,
141: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
143: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

140: p_property_name IN VARCHAR2,
141: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
143: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

141: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
143: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

142: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
143: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
150: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

143: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
150: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
151: p_pass IN NUMBER,

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

144: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
150: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
151: p_pass IN NUMBER,
152: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

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

145: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
150: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
151: p_pass IN NUMBER,
152: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
153: );

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

146: p_creation_date IN DATE := FND_API.G_MISS_DATE,
147: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
150: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
151: p_pass IN NUMBER,
152: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
153: );
154:

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

170: -- Version Initial version number = 1.0
171: -- History Current version number = 1.0
172: --=======================================================
173: procedure CREATE_CRITERIA (
174: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: p_api_version_number IN NUMBER,
176: p_init_msg_tbl IN BOOLEAN := FALSE,
177: p_msg_count OUT NOCOPY NUMBER,
178: p_msg_data OUT NOCOPY VARCHAR2,

Line 187: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,

183: p_region_code IN VARCHAR2,
184: p_attr_appl_id IN NUMBER,
185: p_attr_code IN VARCHAR2,
186: p_sequence_number IN NUMBER,
187: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
190: p_value_date IN DATE := FND_API.G_MISS_DATE,
191: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

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

184: p_attr_appl_id IN NUMBER,
185: p_attr_code IN VARCHAR2,
186: p_sequence_number IN NUMBER,
187: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
190: p_value_date IN DATE := FND_API.G_MISS_DATE,
191: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
192: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

185: p_attr_code IN VARCHAR2,
186: p_sequence_number IN NUMBER,
187: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
190: p_value_date IN DATE := FND_API.G_MISS_DATE,
191: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
192: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
193: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

186: p_sequence_number IN NUMBER,
187: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
190: p_value_date IN DATE := FND_API.G_MISS_DATE,
191: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
192: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
193: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 191: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

187: p_operation IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
190: p_value_date IN DATE := FND_API.G_MISS_DATE,
191: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
192: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
193: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_creation_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 192: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

188: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
190: p_value_date IN DATE := FND_API.G_MISS_DATE,
191: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
192: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
193: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_creation_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

189: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
190: p_value_date IN DATE := FND_API.G_MISS_DATE,
191: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
192: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
193: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_creation_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

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

190: p_value_date IN DATE := FND_API.G_MISS_DATE,
191: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
192: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
193: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_creation_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
198: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,

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

191: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
192: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
193: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_creation_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
198: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
199: p_pass IN NUMBER,

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

192: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
193: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_creation_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
198: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
199: p_pass IN NUMBER,
200: p_copy_redo_flag IN OUT NOCOPY BOOLEAN

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

193: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
194: p_creation_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
198: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
199: p_pass IN NUMBER,
200: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
201: );

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

194: p_creation_date IN DATE := FND_API.G_MISS_DATE,
195: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
196: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
197: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
198: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
199: p_pass IN NUMBER,
200: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
201: );
202:

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

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

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

248: p_init_msg_tbl IN BOOLEAN := FALSE,
249: p_msg_count OUT NOCOPY NUMBER,
250: p_msg_data OUT NOCOPY VARCHAR2,
251: p_return_status OUT NOCOPY VARCHAR2,
252: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
256: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

249: p_msg_count OUT NOCOPY NUMBER,
250: p_msg_data OUT NOCOPY VARCHAR2,
251: p_return_status OUT NOCOPY VARCHAR2,
252: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
256: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR

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

250: p_msg_data OUT NOCOPY VARCHAR2,
251: p_return_status OUT NOCOPY VARCHAR2,
252: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
256: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR
258: );

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

252: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
253: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
256: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR
258: );
259:
260: --=======================================================

Line 257: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR

253: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_custom_pk_tbl IN AK_CUSTOM_PUB.Custom_PK_Tbl_Type := AK_CUSTOM_PUB.G_MISS_CUSTOM_PK_TBL,
256: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR
258: );
259:
260: --=======================================================
261: -- Procedure UPDATE_CUSTOM

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

275: -- Version Initial version number = 1.0
276: -- History Current version number = 1.0
277: --=======================================================
278: procedure UPDATE_CUSTOM (
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_api_version_number IN NUMBER,
281: p_init_msg_tbl IN BOOLEAN := FALSE,
282: p_msg_count OUT NOCOPY NUMBER,
283: p_msg_data OUT NOCOPY VARCHAR2,

Line 289: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,

285: p_custom_appl_id IN NUMBER,
286: p_custom_appl_code IN VARCHAR2,
287: p_region_application_id IN NUMBER,
288: p_region_code IN VARCHAR2,
289: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
293: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,

Line 290: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

286: p_custom_appl_code IN VARCHAR2,
287: p_region_application_id IN NUMBER,
288: p_region_code IN VARCHAR2,
289: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
293: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,

Line 291: p_org_id IN NUMBER := FND_API.G_MISS_NUM,

287: p_region_application_id IN NUMBER,
288: p_region_code IN VARCHAR2,
289: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
293: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 292: p_site_id IN NUMBER := FND_API.G_MISS_NUM,

288: p_region_code IN VARCHAR2,
289: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
293: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,

Line 293: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,

289: p_verticalization_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
293: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 294: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,

290: p_localization_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
293: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 295: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

291: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
292: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
293: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 296: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,

292: p_site_id IN NUMBER := FND_API.G_MISS_NUM,
293: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

Line 297: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,

293: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
301: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 298: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,

294: p_web_user_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
301: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
302: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

295: p_default_customization_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
301: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
302: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 300: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

296: p_customization_level_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
301: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
302: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 301: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

297: p_developer_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
301: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
302: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
305: p_creation_date IN DATE := FND_API.G_MISS_DATE,

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

298: p_reference_path IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
301: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
302: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
305: p_creation_date IN DATE := FND_API.G_MISS_DATE,
306: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

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

299: p_function_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
301: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
302: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
305: p_creation_date IN DATE := FND_API.G_MISS_DATE,
306: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
307: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

300: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
301: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
302: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
305: p_creation_date IN DATE := FND_API.G_MISS_DATE,
306: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
307: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
308: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

301: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
302: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
305: p_creation_date IN DATE := FND_API.G_MISS_DATE,
306: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
307: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
308: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
309: );

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

302: p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
305: p_creation_date IN DATE := FND_API.G_MISS_DATE,
306: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
307: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
308: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
309: );
310:

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

303: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
305: p_creation_date IN DATE := FND_API.G_MISS_DATE,
306: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
307: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
308: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
309: );
310:
311: --=======================================================

Line 308: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

304: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
305: p_creation_date IN DATE := FND_API.G_MISS_DATE,
306: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
307: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
308: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
309: );
310:
311: --=======================================================
312: -- Procedure UPDATE_CUST_REGION

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

326: -- Version Initial version number = 1.0
327: -- History Current version number = 1.0
328: --=======================================================
329: procedure UPDATE_CUST_REGION (
330: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
331: p_api_version_number IN NUMBER,
332: p_init_msg_tbl IN BOOLEAN := FALSE,
333: p_msg_count OUT NOCOPY NUMBER,
334: p_msg_data OUT NOCOPY VARCHAR2,

Line 341: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

337: p_custom_appl_code IN VARCHAR2,
338: p_region_application_id IN NUMBER,
339: p_region_code IN VARCHAR2,
340: p_property_name IN VARCHAR2,
341: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
343: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 342: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,

338: p_region_application_id IN NUMBER,
339: p_region_code IN VARCHAR2,
340: p_property_name IN VARCHAR2,
341: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
343: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
346: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 343: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,

339: p_region_code IN VARCHAR2,
340: p_property_name IN VARCHAR2,
341: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
343: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 344: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,

340: p_property_name IN VARCHAR2,
341: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
343: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

341: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
342: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
343: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

342: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
343: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
350: );

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

343: p_criteria_join_condition IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
350: );
351:

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

344: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
350: );
351:
352: --=======================================================

Line 349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

345: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
346: p_creation_date IN DATE := FND_API.G_MISS_DATE,
347: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
348: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
349: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
350: );
351:
352: --=======================================================
353: -- Procedure UPDATE_CUST_REG_ITEM

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

367: -- Version Initial version number = 1.0
368: -- History Current version number = 1.0
369: --=======================================================
370: procedure UPDATE_CUST_REG_ITEM (
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: p_api_version_number IN NUMBER,
373: p_init_msg_tbl IN BOOLEAN := FALSE,
374: p_msg_count OUT NOCOPY NUMBER,
375: p_msg_data OUT NOCOPY VARCHAR2,

Line 384: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

380: p_region_code IN VARCHAR2,
381: p_attribute_appl_id IN NUMBER,
382: p_attribute_code IN VARCHAR2,
383: p_property_name IN VARCHAR2,
384: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
386: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
387: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
388: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 385: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,

381: p_attribute_appl_id IN NUMBER,
382: p_attribute_code IN VARCHAR2,
383: p_property_name IN VARCHAR2,
384: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
386: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
387: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
388: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
389: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 386: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

382: p_attribute_code IN VARCHAR2,
383: p_property_name IN VARCHAR2,
384: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
386: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
387: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
388: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
389: p_creation_date IN DATE := FND_API.G_MISS_DATE,
390: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 387: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,

383: p_property_name IN VARCHAR2,
384: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
386: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
387: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
388: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
389: p_creation_date IN DATE := FND_API.G_MISS_DATE,
390: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
391: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

384: p_property_varchar2_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
385: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
386: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
387: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
388: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
389: p_creation_date IN DATE := FND_API.G_MISS_DATE,
390: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
391: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
392: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

385: p_property_number_value IN NUMBER := FND_API.G_MISS_NUM,
386: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
387: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
388: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
389: p_creation_date IN DATE := FND_API.G_MISS_DATE,
390: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
391: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
392: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
393: );

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

386: p_property_date_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
387: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
388: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
389: p_creation_date IN DATE := FND_API.G_MISS_DATE,
390: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
391: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
392: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
393: );
394:

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

387: p_property_varchar2_value_tl IN VARCHAR2 := FND_API.G_MISS_CHAR,
388: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
389: p_creation_date IN DATE := FND_API.G_MISS_DATE,
390: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
391: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
392: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
393: );
394:
395: --=======================================================

Line 392: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

388: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
389: p_creation_date IN DATE := FND_API.G_MISS_DATE,
390: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
391: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
392: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
393: );
394:
395: --=======================================================
396: -- Procedure UPDATE_CRITERIA

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

410: -- Version Initial version number = 1.0
411: -- History Current version number = 1.0
412: --=======================================================
413: procedure UPDATE_CRITERIA (
414: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
415: p_api_version_number IN NUMBER,
416: p_init_msg_tbl IN BOOLEAN := FALSE,
417: p_msg_count OUT NOCOPY NUMBER,
418: p_msg_data OUT NOCOPY VARCHAR2,

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

424: p_attribute_appl_id IN NUMBER,
425: p_attribute_code IN VARCHAR2,
426: p_sequence_number IN NUMBER,
427: p_operation IN VARCHAR2,
428: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
430: p_value_date IN DATE := FND_API.G_MISS_DATE,
431: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
432: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

425: p_attribute_code IN VARCHAR2,
426: p_sequence_number IN NUMBER,
427: p_operation IN VARCHAR2,
428: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
430: p_value_date IN DATE := FND_API.G_MISS_DATE,
431: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
432: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
433: p_created_by IN NUMBER := FND_API.G_MISS_NUM,

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

426: p_sequence_number IN NUMBER,
427: p_operation IN VARCHAR2,
428: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
430: p_value_date IN DATE := FND_API.G_MISS_DATE,
431: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
432: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
433: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
434: p_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 431: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,

427: p_operation IN VARCHAR2,
428: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
430: p_value_date IN DATE := FND_API.G_MISS_DATE,
431: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
432: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
433: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
434: p_creation_date IN DATE := FND_API.G_MISS_DATE,
435: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 432: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

428: p_value_varchar2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
429: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
430: p_value_date IN DATE := FND_API.G_MISS_DATE,
431: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
432: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
433: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
434: p_creation_date IN DATE := FND_API.G_MISS_DATE,
435: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
436: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

429: p_value_number IN NUMBER := FND_API.G_MISS_NUM,
430: p_value_date IN DATE := FND_API.G_MISS_DATE,
431: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
432: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
433: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
434: p_creation_date IN DATE := FND_API.G_MISS_DATE,
435: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
436: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
437: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

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

430: p_value_date IN DATE := FND_API.G_MISS_DATE,
431: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
432: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
433: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
434: p_creation_date IN DATE := FND_API.G_MISS_DATE,
435: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
436: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
437: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
438: );

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

431: p_start_date_Active IN DATE := FND_API.G_MISS_DATE,
432: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
433: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
434: p_creation_date IN DATE := FND_API.G_MISS_DATE,
435: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
436: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
437: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
438: );
439:

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

432: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
433: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
434: p_creation_date IN DATE := FND_API.G_MISS_DATE,
435: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
436: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
437: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
438: );
439:
440: end AK_CUSTOM_GRP;

Line 437: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM

433: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
434: p_creation_date IN DATE := FND_API.G_MISS_DATE,
435: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
436: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
437: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
438: );
439:
440: end AK_CUSTOM_GRP;