77: -- failure code will be returned and the entire transaction
78: -- will be rolled back
79: PROCEDURE Add_Record_To_List_Interactive
80: ( p_list_id IN NUMBER
81: , p_column_name IN SYSTEM.varchar_tbl_type
82: , p_column_value IN SYSTEM.varchar_tbl_type
83: , p_callback_time IN DATE DEFAULT NULL
84: , x_failure_code OUT NOCOPY VARCHAR2
85: );
78: -- will be rolled back
79: PROCEDURE Add_Record_To_List_Interactive
80: ( p_list_id IN NUMBER
81: , p_column_name IN SYSTEM.varchar_tbl_type
82: , p_column_value IN SYSTEM.varchar_tbl_type
83: , p_callback_time IN DATE DEFAULT NULL
84: , x_failure_code OUT NOCOPY VARCHAR2
85: );
86:
90: -- but fails validation, the record will remain in the calling
91: -- list as an invalid record
92: PROCEDURE Add_Record_To_List
93: ( p_list_id IN NUMBER
94: , p_column_name IN SYSTEM.varchar_tbl_type
95: , p_column_value IN SYSTEM.varchar_tbl_type
96: , p_callback_time IN DATE DEFAULT NULL
97: , x_failure_code OUT NOCOPY VARCHAR2
98: );
91: -- list as an invalid record
92: PROCEDURE Add_Record_To_List
93: ( p_list_id IN NUMBER
94: , p_column_name IN SYSTEM.varchar_tbl_type
95: , p_column_value IN SYSTEM.varchar_tbl_type
96: , p_callback_time IN DATE DEFAULT NULL
97: , x_failure_code OUT NOCOPY VARCHAR2
98: );
99: