42: p_dist_st_based_on_parent_flag,
43: p_ws_id,
44: p_tasks_rules_function,
45: 1,
46: fnd_global.user_id,
47: sysdate,
48: fnd_global.user_id,
49: sysdate,
50: fnd_global.login_id
44: p_tasks_rules_function,
45: 1,
46: fnd_global.user_id,
47: sysdate,
48: fnd_global.user_id,
49: sysdate,
50: fnd_global.login_id
51: );
52:
46: fnd_global.user_id,
47: sysdate,
48: fnd_global.user_id,
49: sysdate,
50: fnd_global.login_id
51: );
52:
53: open c;
54: fetch c into x_rowid;
123: dist_st_based_on_parent_flag = p_dist_st_based_on_parent_flag,
124: ws_id = p_ws_id,
125: tasks_rules_function = p_tasks_rules_function,
126: last_update_date = sysdate,
127: last_updated_by = fnd_global.user_id,
128: last_update_login = fnd_global.login_id
129: where ws_association_prop_id = p_ws_association_prop_id;
130:
131: if (sql%notfound) then
124: ws_id = p_ws_id,
125: tasks_rules_function = p_tasks_rules_function,
126: last_update_date = sysdate,
127: last_updated_by = fnd_global.user_id,
128: last_update_login = fnd_global.login_id
129: where ws_association_prop_id = p_ws_association_prop_id;
130:
131: if (sql%notfound) then
132: raise no_data_found;