DBA Data[Home] [Help]

APPS.QA_SS_PARENT_CHILD_PKG dependencies on FND_GLOBAL

Line 41: p_last_updated_by NUMBER := fnd_global.user_id,

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:

Line 42: p_created_by NUMBER := fnd_global.user_id,

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:

Line 43: p_last_update_login NUMBER := fnd_global.user_id,

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,

Line 52: p_last_updated_by NUMBER := fnd_global.user_id,

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:

Line 53: p_created_by NUMBER := fnd_global.user_id,

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,

Line 54: p_last_update_login NUMBER := fnd_global.user_id,

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,

Line 69: p_last_updated_by NUMBER := fnd_global.user_id,

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:

Line 70: p_created_by NUMBER := fnd_global.user_id,

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,

Line 71: p_last_update_login NUMBER := fnd_global.user_id,

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,

Line 82: p_last_updated_by NUMBER:=fnd_global.user_id,

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:

Line 83: p_created_by NUMBER:=fnd_global.user_id,

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(

Line 84: p_last_update_login NUMBER:=fnd_global.user_id

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,

Line 94: p_last_updated_by NUMBER := fnd_global.user_id,

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:

Line 95: p_created_by NUMBER := fnd_global.user_id,

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:

Line 96: p_last_update_login NUMBER := fnd_global.user_id,

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(

Line 107: p_last_updated_by NUMBER := fnd_global.user_id,

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:

Line 108: p_created_by NUMBER := fnd_global.user_id,

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:

Line 109: p_last_update_login NUMBER := fnd_global.user_id,

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