37: p_data_entry_mode NUMBER,
38: p_layout_mode NUMBER default null,
39: p_auto_row_count NUMBER,
40: p_default_parent_spec VARCHAR2,
41: p_last_updated_by NUMBER := fnd_global.user_id,
42: p_created_by NUMBER := fnd_global.user_id,
43: p_last_update_login NUMBER := fnd_global.user_id,
44: x_plan_relationship_id IN OUT NOCOPY NUMBER);
45:
38: p_layout_mode NUMBER default null,
39: p_auto_row_count NUMBER,
40: p_default_parent_spec VARCHAR2,
41: p_last_updated_by NUMBER := fnd_global.user_id,
42: p_created_by NUMBER := fnd_global.user_id,
43: p_last_update_login NUMBER := fnd_global.user_id,
44: x_plan_relationship_id IN OUT NOCOPY NUMBER);
45:
46:
39: p_auto_row_count NUMBER,
40: p_default_parent_spec VARCHAR2,
41: p_last_updated_by NUMBER := fnd_global.user_id,
42: p_created_by NUMBER := fnd_global.user_id,
43: p_last_update_login NUMBER := fnd_global.user_id,
44: x_plan_relationship_id IN OUT NOCOPY NUMBER);
45:
46:
47: PROCEDURE insert_element_rel(p_plan_relationship_id NUMBER,
48: p_parent_char_id NUMBER,
49: p_child_char_id NUMBER,
50: p_element_relationship_type NUMBER,
51: p_link_flag VARCHAR2,
52: p_last_updated_by NUMBER := fnd_global.user_id,
53: p_created_by NUMBER := fnd_global.user_id,
54: p_last_update_login NUMBER := fnd_global.user_id,
55: x_element_relationship_id OUT NOCOPY NUMBER);
56:
49: p_child_char_id NUMBER,
50: p_element_relationship_type NUMBER,
51: p_link_flag VARCHAR2,
52: p_last_updated_by NUMBER := fnd_global.user_id,
53: p_created_by NUMBER := fnd_global.user_id,
54: p_last_update_login NUMBER := fnd_global.user_id,
55: x_element_relationship_id OUT NOCOPY NUMBER);
56:
57: PROCEDURE insert_element_rel_chk(p_parent_char_id NUMBER,
50: p_element_relationship_type NUMBER,
51: p_link_flag VARCHAR2,
52: p_last_updated_by NUMBER := fnd_global.user_id,
53: p_created_by NUMBER := fnd_global.user_id,
54: p_last_update_login NUMBER := fnd_global.user_id,
55: x_element_relationship_id OUT NOCOPY NUMBER);
56:
57: PROCEDURE insert_element_rel_chk(p_parent_char_id NUMBER,
58: p_child_char_id NUMBER,
65: p_low_value VARCHAR2,
66: -- p_low_value_id NUMBER,
67: p_high_value VARCHAR2,
68: -- p_high_value_id NUMBER,
69: p_last_updated_by NUMBER := fnd_global.user_id,
70: p_created_by NUMBER := fnd_global.user_id,
71: p_last_update_login NUMBER := fnd_global.user_id,
72: x_criteria_id OUT NOCOPY NUMBER);
73:
66: -- p_low_value_id NUMBER,
67: p_high_value VARCHAR2,
68: -- p_high_value_id NUMBER,
69: p_last_updated_by NUMBER := fnd_global.user_id,
70: p_created_by NUMBER := fnd_global.user_id,
71: p_last_update_login NUMBER := fnd_global.user_id,
72: x_criteria_id OUT NOCOPY NUMBER);
73:
74: PROCEDURE update_plan_rel(p_plan_relationship_id NUMBER,
67: p_high_value VARCHAR2,
68: -- p_high_value_id NUMBER,
69: p_last_updated_by NUMBER := fnd_global.user_id,
70: p_created_by NUMBER := fnd_global.user_id,
71: p_last_update_login NUMBER := fnd_global.user_id,
72: x_criteria_id OUT NOCOPY NUMBER);
73:
74: PROCEDURE update_plan_rel(p_plan_relationship_id NUMBER,
75: p_parent_plan_id NUMBER,
78: p_data_entry_mode NUMBER,
79: p_layout_mode NUMBER default null,
80: p_auto_row_count NUMBER,
81: p_default_parent_spec VARCHAR2,
82: p_last_updated_by NUMBER:=fnd_global.user_id,
83: p_created_by NUMBER:=fnd_global.user_id,
84: p_last_update_login NUMBER:=fnd_global.user_id
85: );
86:
79: p_layout_mode NUMBER default null,
80: p_auto_row_count NUMBER,
81: p_default_parent_spec VARCHAR2,
82: p_last_updated_by NUMBER:=fnd_global.user_id,
83: p_created_by NUMBER:=fnd_global.user_id,
84: p_last_update_login NUMBER:=fnd_global.user_id
85: );
86:
87: PROCEDURE update_element_rel(
80: p_auto_row_count NUMBER,
81: p_default_parent_spec VARCHAR2,
82: p_last_updated_by NUMBER:=fnd_global.user_id,
83: p_created_by NUMBER:=fnd_global.user_id,
84: p_last_update_login NUMBER:=fnd_global.user_id
85: );
86:
87: PROCEDURE update_element_rel(
88: p_element_relationship_id NUMBER,
90: p_parent_char_id NUMBER,
91: p_child_char_id NUMBER,
92: p_element_relationship_type NUMBER,
93: p_link_flag VARCHAR2,
94: p_last_updated_by NUMBER := fnd_global.user_id,
95: p_created_by NUMBER := fnd_global.user_id,
96: p_last_update_login NUMBER := fnd_global.user_id,
97: p_row_id VARCHAR2);
98:
91: p_child_char_id NUMBER,
92: p_element_relationship_type NUMBER,
93: p_link_flag VARCHAR2,
94: p_last_updated_by NUMBER := fnd_global.user_id,
95: p_created_by NUMBER := fnd_global.user_id,
96: p_last_update_login NUMBER := fnd_global.user_id,
97: p_row_id VARCHAR2);
98:
99:
92: p_element_relationship_type NUMBER,
93: p_link_flag VARCHAR2,
94: p_last_updated_by NUMBER := fnd_global.user_id,
95: p_created_by NUMBER := fnd_global.user_id,
96: p_last_update_login NUMBER := fnd_global.user_id,
97: p_row_id VARCHAR2);
98:
99:
100: PROCEDURE update_criteria_rel(
103: p_char_id NUMBER,
104: p_operator NUMBER,
105: p_low_value VARCHAR2,
106: p_high_value VARCHAR2,
107: p_last_updated_by NUMBER := fnd_global.user_id,
108: p_created_by NUMBER := fnd_global.user_id,
109: p_last_update_login NUMBER := fnd_global.user_id,
110: p_criteria_id NUMBER);
111:
104: p_operator NUMBER,
105: p_low_value VARCHAR2,
106: p_high_value VARCHAR2,
107: p_last_updated_by NUMBER := fnd_global.user_id,
108: p_created_by NUMBER := fnd_global.user_id,
109: p_last_update_login NUMBER := fnd_global.user_id,
110: p_criteria_id NUMBER);
111:
112:
105: p_low_value VARCHAR2,
106: p_high_value VARCHAR2,
107: p_last_updated_by NUMBER := fnd_global.user_id,
108: p_created_by NUMBER := fnd_global.user_id,
109: p_last_update_login NUMBER := fnd_global.user_id,
110: p_criteria_id NUMBER);
111:
112:
113: PROCEDURE delete_element_rel(p_element_relationship_id NUMBER);